ERROR 1820 set password for root@'db'=password("1q2w3e4r")

[root@db software]# rpm -ivh MySQL-server-advanced-5.6.22-1.rhel5.x86_64.rpm 

[root@db software]# service mysql start

Starting MySQL.[  OK  ]

[root@db software]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.22-enterprise-commercial-advanced
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

mysql> set password for root@'db'=password("123456");
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement

[root@db software]# ping db
PING db (127.0.0.1) 56(84) bytes of data.
64 bytes from db (127.0.0.1): icmp_seq=1 ttl=64 time=0.127 ms
64 bytes from db (127.0.0.1): icmp_seq=2 ttl=64 time=0.020 ms

mysql> set password=password("1q2w3e4r");
Query OK, 0 rows affected (0.00 sec)


mysql> exit

[root@db software]# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.6.22-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
mysql> 
mysql>  show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
在MySQL中,使用"set password for 'root'@'localhost' = password('新密码');"这条语句可以修改root用户在localhost上的密码。这是一种修改root密码的方法,通过将新密码加密后更新到数据库中来实现密码的更改。 除了使用该语句,还有其他几种方法可以修改root密码: 方法1:使用"SET PASSWORD"命令 mysql -u root mysql> SET PASSWORD FOR 'root'@'localhost' = PASSWORD('新密码'); 方法2:使用mysqladmin命令 mysqladmin -u root password "新密码" 如果root用户已经设置过密码,可以使用以下方法: mysqladmin -u root password 旧密码 "新密码" 方法3:直接编辑user表 mysql -u root mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD('新密码') WHERE User = 'root'; mysql> FLUSH PRIVILEGES; 当丢失root密码时,可以使用以下步骤: 1. 运行"mysqld_safe --skip-grant-tables&"命令,启动MySQL服务并跳过权限验证; 2. 运行"mysql -u root mysql"命令,连接到MySQL数据库; 3. 运行以下命令来更新root用户的密码: mysql> UPDATE user SET password=PASSWORD("新密码") WHERE user='root'; mysql> FLUSH PRIVILEGES; 此外,还可以使用"ALTER USER"语句来修改root用户的密码: ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *3* [输入:SET PASSWORD FOR ‘root‘@‘localhost‘ = PASSWORD(‘你的新密码‘);后报错:ERROR 1064 (42000)](https://blog.csdn.net/weixin_38177508/article/details/128722436)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] - *2* [MySql 修改 root 密码](https://blog.csdn.net/wqs880527/article/details/105723471)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值