Solution: grant all privileges on *. * to Joe @ localhost identified
'1 ';
Flush privileges;
Log in with Joe 1
Appendix:
Mysql>
Grant permission 1, permission 2 ,... Permission n onDatabase
Name. Table name to user name @ user address
Identified by 'Connection password ';
Permission 1, permission 2 ,... Permission n
Select, insert, update, delete, create, drop, index, alter, Grant, references, reload, shutdown, process, file
And other 14 permissions.
When permission 1, permission 2 ,... Permission N is replaced by all privileges or all, indicating that all permissions are granted to the user.
When the database name. Table Name
Replaced by *. *, which grants the user the permission to operate all tables in all databases on the server.
The user address can be localhost, IP address, machine name, or domain name. Yes.
Use '%' to connect from any address.
The 'Connection password' cannot be blank; otherwise, creation fails.
Mysql> Grant
Select, insert, update, delete, create, drop on vtdc. employee
Joe@10.163.225.87 identified by '000000 ′;
Assign the database to user Joe from 10.163.225.87
The Select, insert, update, delete, create, drop, and other operations on the vtdc employee table are permitted, and the password is set to 123.
Mysql> Grant
All privileges on vtdc. * To joe@10.163.225.87 identified by '000000 ′;
To
User Joe from 10.163.225.87 assigns permissions to perform all operations on all tables in the database vtdc and sets the password to 123.
Mysql> Grant
All privileges on *. * To joe@10.163.225.87 identified by '000000 ′;
To
User Joe of 10.163.225.87 assigns permissions to perform all operations on all tables in all databases and sets the password to 123.
Mysql> Grant
All privileges on *. * to Joe @ localhost identified by '000000 ′;
To Local User Joe
Assign permissions to perform all operations on all tables in all databases and set the password to 123.