1.添加用户并添加与用户相同的数据库名且给该数据库授予全部权限
mysql> use mysql;
Database changed
mysql> insert into user(Host,User,Password) value('%','users',password('xxgcsoft1101'));
Query OK, 1 row affected
mysql> flush priveges;
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priveges' at line 1
mysql> flush privil
eges;
Query OK, 0 rows affected
mysql> create Database userDB;
Query OK, 1 row affected
mysql> grant all privileges on userDB.* to users@localhost identified by 'users.me';
Query OK, 0 rows affected
mysql> flush privileges;
Query OK, 0 rows affected
2.mysql 初始化
mysql -u root -p
use mysql;
select user,Host,password from user;
update user set Host='%',password=password('password') where user='root' and Host='::1' ;
flussh privileges;