管理mysql

启动mysql

 /etc/init.d/mysqld start

 

显示数据库

show databases ;

 

选择数据库

use databasename ;

 

显示表：

show tables ;

 

添加用户

GRANT [privileges] ON [databasename *].[tablename *] TO [username]@[userIp  %] IDENTIFIED BY ['password'];