设置q1用户的权限为只读
grant SELECT on abc.* to q1@'%' identified by '123' with grant option;
FLUSH PRIVILEGES;为什么在 select * from user \G 的时候,那个 Select_priv: N 为N ?
Host: %
User: q1
Password: *23AE809DDACAF96AF0FD78ED04B6A265E05AA257
Select_priv: N
Insert_priv: N
Update_priv: N
grant SELECT on abc.* to q1@'%' identified by '123' with grant option;
FLUSH PRIVILEGES;为什么在 select * from user \G 的时候,那个 Select_priv: N 为N ?
Host: %
User: q1
Password: *23AE809DDACAF96AF0FD78ED04B6A265E05AA257
Select_priv: N
Insert_priv: N
Update_priv: N
grant SELECT on *.* to q1@'%' identified by '123' with grant option;
我查看了编码,都是gbk 的
就是在mysql命令提示符里面,中文就全部是乱码,怎么解决。。