User Management for mysql in Linux

The database part in the deployment system is mysql, which is used in linux.

In mysql, there is no password for Local root Login by default.

Execute a grant statement as follows:
Grant all on *. * to 'livesky 'IDENTIFIED by '20140901 ';

Explanation: Create a new user "livesky" and set the password to "123456". Grant all permissions to all tables in all databases to the user. The user can log on to any host, if you set the user to log on from the local device only, use the following statement:

Grant all on *. * to 'livesky @ localhost' IDENTIFIED by '123 ';

Set successfully. log on to another host and be notified every time "ERROR 1045 (28000): Access denied for user 'livesky '@ '192. 168.3.30 '(using password: YES) "is strange. the user name and password are correct. I don't understand.

Later, I asked the experts to say that after setting this item, I had to restart mysql to "service mysql restart"

After the restart, haha... OK.