MySQL 常用 Script

Mysql login script:
C:\Users\Nelson Chen>mysql –u root
C:\Users\Nelson Chen>mysql -u manning -p
Enter password: ******

Mysql create user script:
mysql>create user 'manning'@'localhost' identified by 'action';

Mysql grant all privledges script:
mysql>grant all privileges on *.* to 'manning'@'localhost' with grant option;

Mysql show database:
mysql>show databases;

Mysql change database:
mysql>use manning;
mysql>use mysql;
mysql>use test;

Mysql show status:
mysql>show status;