今天通过Native for mysql 工具添加一个用户,并且为这个用户赋值相关数据库的只读权限,提示如下错误“1133 - Can't find any matching row in the user table”
我的Native for mysql 相关语句
INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) VALUES("localhost","test",PASSWORD("123456"),"","","");
grant select on `master`.* to test@localhost identified by '123456';
执行插入用户语句没有问题,但是执行权限赋值的时候提示:1133 - Can't find any matching row in the user table;
解决办法:插入新的用户成功时,需要刷新(flush privileges; )下mysql 权限列表。正确mysql5.6 插入用户,并为用户赋值相关用户权限。
INSERT INTO mysql.user(Host,User,Password,ssl_cipher,x509_issuer,x509_subject) VALUES("localhost","test",PASSWORD("123456"),"","","");
flush privileges;
grant select on `master`.* to test@localhost identified by '123456';
【mysql 提示 1133 - Can't find any matching row in the user table】
推荐阅读
- mysql sql语句实现隐藏手机号码中间四位
- Java(功能篇)|DruidDataSource 通过编码方式实现数据库读写分离。
- MySQL 基于存储过程 实现数据统计按日、周、月份统计模板
- MyBaties(基础篇)|mysql update语句 无法实现数据库更改操作
- mysql 数据库字段&表名 注释查询
- CTF题|BUUCTF-[极客大挑战 2019]EasySQL 1
- MySQL|MySQL高级-SQL优化步骤
- MySQL|MySQL 用户管理
- 国产数据库前50排名|介绍几个国产数据库