关于mysql允许远程连接问题

[qq_24344175]

用该语句设置用户时
grant all privileges on *.* to root@'172.16.150.%' identified by 'abc';

出现了


而我的user表中有



怎么解决，求大神

[道玄希言]

是不是你 root 权限不足呢？

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
 LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT  ON *.* TO 'root'@'172.16.150.%'
IDENTIFIED BY 'abc' WITH GRANT OPTION;

[道玄希言]

http://bbs.csdn.net/topics/360055452

[LongRui888]

你是远程登录，然后执行这个 授权语句，还是在本地登录然后执行这个语句的呢

[LongRui888]

你直接在本地登录，用root站好，localhost的host，登录，然后就可以执行上面的语句了。

[qq_24344175]

引用 4 楼 yupeigu 的回复:

你直接在本地登录，用root站好，localhost的host，登录，然后就可以执行上面的语句了。

我是用xshell远程登陆linux服务器i，然后运行mysql -h 127.0.0.1 -u root -p 然后输入密码

[qq_24344175]

引用 1 楼 yangb0803 的回复:

是不是你 root 权限不足呢？

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
 LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT  ON *.* TO 'root'@'172.16.150.%'
IDENTIFIED BY 'abc' WITH GRANT OPTION;

这算是赋予所有权限吗？

[qq_24344175]

引用 1 楼 yangb0803 的回复:

是不是你 root 权限不足呢？

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE,
REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES,
 LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT  ON *.* TO 'root'@'172.16.150.%'
IDENTIFIED BY 'abc' WITH GRANT OPTION;

已解决，谢谢