MySQL Common commands

1. Turn on and off the MySQL service

Win platform: net start MYSQL55; net stop Mysql55linux platform: service MySQL start   ; service MySQL stop

2. Command log in to MySQL database

Mysql-h Localhost-u Root-p

3. View all database names and all tables for the specified database

Show Databases;use mysql;show tables;

4. View the current database name, database version information, user name, link number

Select Database (); select version (); Select User ();
Select CONNECT_ID ()

5. View the current date and time

Select Now (); select Curdate (); select Curtime ();

6. View all threads, status analysis

Show Processlist;or Show Full processlist

7. View status information and variable information

Show status Like "..." Show variables like "..."

MySQL Common commands