Dead-Knock MySQL (5)

High performance MySQL

--View hidden libraries//use MySQL

--Create new users//create user ' new ' @ ' localhost ' identified by ';

--Create user ' user name ' @ ' HOST/* Local login */' Password ' password '

mysql> create user ' new ' @ ' localhost ' identified by ';
Query OK, 0 rows Affected (0.00 sec)

6. Row ***************************
Host:localhost
User:new
Password:
Select_priv:n
Insert_priv:n
Update_priv:n
Delete_priv:n
Create_priv:n

Mysql> Grant All on * * to ' new ' @ ' localhost ';
Query OK, 0 rows affected (0.03 sec)

--Grant full permissions to ' new ' @ ' loalhost ' for each database

Mysql> Revoke SELECT On *. * from ' new ' @ ' localhost ';
Query OK, 0 rows Affected (0.00 sec)

--Modify permissions to grant query permissions

http://blog.csdn.net/wulantian/article/details/38230635

Detailed permissions

Dead-Knock MySQL (5)