mysql-browser

A functional project written fully in Javacript, where users can enter their MySQL username and password and connect to their database and run simple commands.

Introduction

This project oprates the same as MySQL Workbench but in a lower level and simpler way. MySQL Web Admin (MWA) doesn't save any of your personal information such as password or username in the backend. Both frontend and backend are written in Javascript. For handling queries and REST APIs I have implemented node Express and Axios.

Instructions

MWA operates as users enter their hostname, username and password of their MySQL. After connecting they can select any schema from sechema's that are available and start working

MWA allows users to:

Select different schemas

Run MySQL commands in the textarea

Select tables/ views to display in a table

User Installation

1. Users can simply clone the project
2. Go to the main page of the repository and on the top click on the green button <> Code and copy the URL
3. Open your terminal and go to the directory you would like to clone the project
4. Type git clone and paste the URL that you have copied and press enter
5. After cloning, open two new terminals in the directory that you have clonned and run the following commands (cd mysql-browser/src/back-end) and (cd mysql-browser/src/front-end) and run (npm install) command, to install all modules and packages
6. On the terminal for the front-end folder and run the (npm start) command and in the terminal for the back-end folder and run (node back-end.js ) command
7. Browser will bring up the application and it is ready for use

Limitations

Users can't run all MySQL commands

Users can only run commands that start with select, show, display, create, insert, update

Commands are limited to prevent users from deleting their tables and views by mistake