Database and Terminal nice to know commands

Login: mysql -u root -p
Show db/db's: show databases;
Select a DB: use mysql;
List tables: show tables;
Show users: select user, host from mysql.user;
Exit: exit

Leave a Reply

Your email address will not be published. Required fields are marked *