mysql8授权 grant all privileges on 语句报错 You have an error in your SQL syntax

最新推荐文章于 2024-02-25 15:29:06 发布

古林觭梦

最新推荐文章于 2024-02-25 15:29:06 发布

阅读量3.3k

点赞数 1

文章标签： sql 数据库 mysql

本文链接：https://blog.csdn.net/weixin_44368250/article/details/128866109

版权

mysql8授权 grant all privileges on 语句报错 You have an error in your SQL syntax;

报错语句

**mysql>GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;**
ERROR 1064 (42000): 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 '. TO 'admin'@'%' IDENTIFIED BY '123' WITH GRANT OPTION' at line 1`

mysql8.0版本使用语句变为：

grant all privileges on *.* to 'root'@'localhost';

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

古林觭梦

关注关注

1
点赞
踩
12

收藏

觉得还不错? 一键收藏
3
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

完美解决：ERROR 1064 (42000): You have an error in your SQL syntax； check the manual that corresponds to

Mortalz7

11-15

5万+

ERROR 1064 (42000): 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 'mortalz7' with grant option' at line 1

ERROR 1064 (42000): You have an error in your SQL syntax； check the manual

lyana的博客

04-27

3377

我的错误语句是 set password for root@localhost = password(‘123456’); 我用的是Linux系统下的mysql8.0，刚开始以为是自己的标点符号打错了，但是改来改去都不对，我就索性把这句话放进了windows的navicate运行了一下，发现完全没错！那是怎么回事呢？我的navicate里连了两个mysql服务器，一个是部署在我本机的5.0，一个是windows server的8.0，我就突然想起自己曾经也踩过这个坑！没错！就是版本问题！我由于最近新

3 条评论您还未登录，请先登录后发表或查看评论

mysql＞ GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘shujinghuan‘ WITH GRANT OPTION； ERRO

舒一笑的博客

01-31

2531

命令的语法发生了变化。在 MySQL 5.7 之后的版本中，不再支持在。这条 MySQL 命令出现错误的原因是因为在较新版本的 MySQL 中，命令来创建用户并设置密码。完成这两个步骤后，不要忘记执行。命令来给用户分配权限。命令创建用户，然后再使用。

mysql8 添加一个用户并给与所有权限报错解决

Ggome的博客

09-08

867

报错 You have an error in your SQL syntax。grant all privileges on 语句。

MySQL8.0 :grant all privileges on *.* to 报错问题

weixin_44161444的博客

04-24

3379

mysql 8.0 修改密码报错

grant all privileges on *.* to 报错问题

weixin_34342992的博客

11-20

6054

mysql8.0无法给用户授权或提示You are not allowed to create a user with GRANT、for the right syntax to use near 'identified by xxx'的问题提示意思是不能用grant创建用户，mysql8.0以前的版本可以使用grant在授权的时候隐式的创建用户，8.0以后已经不支持，所以必须先创建用户，然后再授...

nginx MySQL80 报错 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 '. TO 'root'@'%' IDENTIFIED BY '123456'' at line 1

07-14

对不起，刚才的回答中有一个错误。...在上述语句中，没有多余的点号“.”，正确的语法是将 "ON *.*" 放在 "GRANT ALL PRIVILEGES" 之后。再次对之前的错误表示歉意，并感谢您的指正。如果您还有其他问题，请随时提问。

1064 (42000): you have an error in your sql syntax

最新发布

08-15

1064 (42000): 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 'fire-cmd --zone=public --add-port=3306/tcp --...

mysql> GRANT ALL PRIVILEGES ON *.* TO 'exporter'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION; ERROR 1064 (42000): 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 '123456' WITH GRANT OPTION' at line 1

06-07

GRANT ALL PRIVILEGES ON *.* TO 'exporter'@'%' WITH GRANT OPTION; ``` 请注意，首先必须创建用户并设置其密码，然后才能授予该用户所有权限。此外，在MySQL 8.0中，GRANT命令不允许在'IDENTIFIED BY'子句中指定...

mysql远程连接权限grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant option语句报错

chenshida_的博客

06-09

2万+

mysql远程连接权限grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant option语句报错记录一下自己安装mysql遇到的小坑 grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant option 只适用于mysql8.0之前的版本之后采用这句: create user root@'%' identif

Mysql-8 执行授权语句错误：ERROR 1064 (42000)

孙大圣的博客

02-25

1132

在Mysql 8版本中，不能使用GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password'WITH GRANT OPTION;

mysql中远程连接权限语句grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant optio报错

jiangjunyuan168的博客

11-25

9486

grant all privileges on *.* to ‘root‘@‘%‘ identified by ‘123456‘ with grant optio 原因： mysql的版本问题，这条语句适用于MySQL8.0之前解决： mysql8.0及以上版本需要使用以下语句： create user root@'%' identified by '123456'; grant all privileges on *.* to root@'%' with grant option; .....

mysql添加用户权限报1064 - You have an error in your SQL syntax问题解决

weixin_38383877的博客

11-08

3819

mysql添加用户及权限报错：出现这样错的原因有两个： 1、语法有问题（这里没有问题） 2、mysql版本是否支持此种写法找到一位大神说：你检查下mysql版本是mysql server 8.不支持同时创建用户和授予权限，只能分开写，结果一试便成功了感谢大神的帮助...

centos7.5 登入mysql,进行授权报错 mysql＞ grant all privileges on *.* to ‘lvhanzhi‘@‘%‘ identified by ‘Bgx123.

lflmuximuxi的博客

11-18

244

centos7.5 登入mysql,进行授权报错 mysql> grant all privileges on . to ‘lvhanzhi’@’%’ identified by ‘Bgx123.com’; ERROR 3009 (HY000): Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50560, now running 50725. Please use mysql_upgrade

mysql 错误 You have an error in your SQL syntax； check the manual that corresponds to your MySQL serve

piaomiaozaitianya的博客

01-12

1321

这个一般就是sql 语法错误，一般常见的就是多了逗号“,” 。但是有一种错误可能会被忽略，当你的sql语句认为正确的时候，不妨看看是不是字段里又关键词当字段，一般编辑器会边颜色，比如关键词 key, describe等，用关键词当字段时候语法需要加 "`"符号比如：select a,b,c,`describe`,`key` from t_test ...

mybatis链接数据库mysql8.0Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL synta