mysql 密码修改问题

最新推荐文章于 2024-05-28 16:29:01 发布

沉默的小明兄

最新推荐文章于 2024-05-28 16:29:01 发布

阅读量1.4k

点赞数 2

分类专栏：其他文章标签： mysql password

本文链接：https://blog.csdn.net/u013362433/article/details/103107295

版权

在MySQL 8.0.2及更高版本中，由于user表结构改变，使用`update user set password`会出现错误。正确更新root密码的方式是通过跳过权限验证启动MySQL，在命令行中进行修改。详细步骤包括检查user表结构，然后使用适当命令无误地更新root用户的密码。

摘要由CSDN通过智能技术生成

1.update user set password=password(‘123456’) where User=‘root’；

mysql>
mysql> UPDATE user SET PASSWORD=PASSWORD('123456') WHERE User='root';
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 '('123456') WHERE User='root'' at line 1
mysql> user mysql;
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 'user mysql' at line 1
mysql> use mysql;
Database changed
mysql> UPDATE user SET PASSWORD=PASSWORD('123456') WHERE User='root';
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 '('123456') WHERE User='root'' at line 1
mysql> update user set password=password('123456') where User='root'
    -> ;
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 '('123456') where User='root'' at line 1
mysql>

出现了语法错误之后，查看user表中字段。

2. 查看mysql user 表

mysql> desc user;
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Field                    | Type                              | Null | Key | Default               | Extra |
+--------------------------+-----------------------------------+------+-----+-----------------------+-------+
| Host                     | char(255)                         | NO   | PRI |                       |       |
| User                     | char(32)                          | NO   | PRI |                       |       |
| Select_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Insert_priv              | enum('N','Y')                     | NO   |     | N                     |       |
| Update_priv              | enum(