一,修改密码
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
修改密码
set password for 'root'@'localhost'=password('12345678');
但是又报下面的错
ERROR 1064 (42000): 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 'password('12345678')' at line 1
换了一种方式成功了
mysql> alter user'root'@'localhost' identified by '12345678';
Query OK, 0 rows affected (0.01 sec)
二,用户不能授权
ERROR 1410 (42000): You are not allowed to create a user with GRANT
产生用户不能授权的原因是mysql 数据库中user 表中的特定用户(root) 的host 的属性值为localhost.
mysql> update user set host='%' where user='root'; //特定用户的host 修改
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> grant all privileges on luckyframe.* to root@'%'; // 指定用户授权
Query OK, 0 rows affected (0.01 sec)
mysql> flush privileges; //刷新生效
Query OK, 0 rows affected (0.01 sec)