创建远程连接报错

Question

创建远程连接时使用grant SELECT,UPDATE,INSERT,DELETE on . to ‘work’@’%’ identified by ‘7950473’;报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 'identified by ‘7950473’'错。

Answer 1

突出部作战 2019-06-12 20:34:48

我看你的引号就有问题啊。。 所以才报语法错误‘work’@’%’ 是 'work' @ '%' 才对吧

• 提问者 iconh #1

  问题解决了，我没有把root的权限设置为%，连接时用的ip不是阿里云的公共ip,谢谢你