用mysql5.7.10的客户端,用以往的插入用户的方式老是报错,后来在官网以及stackoverflow上查询之后,找到如下解决办法。
以下所有操作必须以root管理员身份进行操作。
登陆mysql:
mysql -u root -p
输入密码:
密码1
进入名为mysql的database:
use mysql;
查看现有用户信息:
select host,user from user;
+---------------+-----------+
| host | user |
+---------------+-----------+
| 1.1.1.1 | abc |
| localhost | mysql.sys |
| localhost | root |
+---------------+-----------+
| host | user |
+---------------+-----------+
| 1.1.1.1 | abc |
| localhost | mysql.sys |
| localhost | root |
+---------------+-----------+
插入新的用户信息:
create user def;
用户密码设置:
update user set authentication_string=password("12345678") where user = "def";
设置用户权限:
grant all on database1.* to 'def'@'2.2.2.2';
刷新数据库:
flush privileges;
查看现有用户信息:
select host,user from user;
| host | user |
+---------------+-----------+
| 1.1.1.1 | abc |
| 2.2.2.2 | def |
| localhost | mysql.sys |
| localhost | root |
+---------------+-----------+
| localhost | mysql.sys |
| localhost | root |
+---------------+-----------+
搞定