My journey of 10000 lines of sql commands using 3 databases
| DataBases | Name | School | Company | OnlineShop | |
|---|---|---|---|---|---|
| Tables | School | Students | Teachers | Subjects | |
| Tables | Company | Employess | Clients | Projects | |
| Tables | Onlineshop | Items | Categories | Customers | Orders |
mysql> CREATE USER 'admin' IDENTIFIED BY 'password1234';
Query OK, 0 rows affected (0.02 sec) //CHANGE PASSWORD
mysql> ALTER USER 'admin' IDENTIFIED BY 'php1234'; Query OK, 0 rows affected (0.01 sec)
//GRANT ALL PRIVELLEGES TO ALL DB () ALL TABLES () TO THE USER 'ADMIN' WITH USER CAN SET PRIVELLEGES AND NEW USER
mysql> GRANT ALL ON . TO 'admin' WITH GRANT OPTION; Query OK, 0 rows affected (0.02 sec) //PRIVILEGES TO TAKE PLACE
mysql> FLUSH PRIVILEGES;
//EXIT TO LOG IN TO ADMIN
Created an repository using SQL ON MYSQL WORKBENCH. Feel free to reach out if any issues 🙌