How to login MySql in CentOS Or Linux?

How to login MySql in CentOS Or Linux?
Here i will show you that how can you use MySql on CentOS or Linux Os

Open Your terminal and login with your root login
now run this command to login in mysql

mysql -u root -p
It will ask you for password

Enter password:
Enter your password here which you have set for mysql

It will show show you a successfull message OR insert mysql as selected tab
mysql>

Two points you must keep in your mind:

1) All MySQL commands end with a semicolon; if does not end with a semicolon, the command will not execute.


2) MySQL commands are usually written in uppercase and databases, tables, usernames, or text are in lowercase to make them easier to distinguish. MySQL command line is not case sensitive.

To show all database:

SHOW DATABASES;

Use exit command to come out from the mysql> promt

mysql> exit
it will show msg
bye