启动mysql
/etc/init.d/mysqld start
显示数据库
show databases ;
选择数据库
use databasename ;
显示表:
show tables ;
添加用户
GRANT [privileges] ON [databasename *].[tablename *] TO [username]@[userIp %] IDENTIFIED BY ['password'];
启动mysql
/etc/init.d/mysqld start
显示数据库
show databases ;
选择数据库
use databasename ;
显示表:
show tables ;
添加用户
GRANT [privileges] ON [databasename *].[tablename *] TO [username]@[userIp %] IDENTIFIED BY ['password'];