BASIC AND USEFUL MYSQL SHELL COMMANDS

BASIC AND USEFUL MYSQL SHELL COMMANDS.

some of the basic and useful commands in mysql .every one should know.



How to login to MySQL :
mysql -u root -p

How to create a MySQL database via Shell:

After you logged in, execute this command (replace dbname with the name of the database you want to create):

mysql> create database dbname;

Output:
Query OK, 1 row affected (0.01 sec)

How to delete a MySQL database via Shell:

How to create a MySQL User via Shell:

(replace dbusername with the username you want to create)

How to set a password for the MySQL User you just created:

(replace passhere with the password you would like to set)

How to grant privileges for the username to the database:

How to display database tables in a MySQL database?

First enter the database by executing:

Now show tables:

To search for a specific table without remembering its exact name:
(where keyword is the partial name you remember)

How to exit MySQL via Shell:

or subscribe in as a reader