MySQL—— How to reset the root password

最新推荐文章于 2025-04-24 09:54:49 发布

Machanical-Thinking

最新推荐文章于 2025-04-24 09:54:49 发布

阅读量627

点赞数

分类专栏：开发工具

本文链接：https://blog.csdn.net/qq_34302921/article/details/86740750

版权

开发工具专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了当忘记MySQL数据库的root用户密码时，如何通过一系列操作来重置密码。包括停止MySQL服务、以安全模式启动数据库、更新root用户密码并刷新权限，最后重启MySQL服务并验证新密码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Steps to change password when you have forgotten:

1. Stop MySQL Server

/etc/init.d/mysql stop

2. Start the database without loading the grant tables or enabling networking:

mysqld_safe --skip-grant-tables &
mysql -u root

3. Setup new MySQL root user password

use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit;

4. Stop MySQL Server:

/etc/init.d/mysql stop

5. Start MySQL server and test it

mysql -u root -p

OK, That’s all.

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Machanical-Thinking

关注关注

0
点赞
踩
0

收藏

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

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

How to install WordPress

易天海

08-02

730

https://wordpress.org/support/article/how-to-install-wordpress/ WordPress is well-known for its ease of installation. Under most circumstances, installing WordPress is a very simple process and takes less than five minutes to complete.Many web hostsnow ..

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this st

civil的专栏

11-17

6906

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

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

MySQL root用户密码忘记怎么办（Reset root account password）

最新发布

xuezhangmen的博客

04-24

2760

mysql用户分为root用户（超级管理员，拥有所有权限）和普通用户，mysql服务器通过权限表来控制用户对数据库的访问,这些权限表存于root用户下的mysql数据库中。注意：mysql新版本用于存用户密码的字段名为authentication_string，而不是 password，且新密码必须使用password函数进行加密。第四步：将输入mysqld --skip-grant-tables命令的命令行窗口关闭，接下来就可以使用新密码登录mysql服务器了。怎么样，是不是觉得很简单呢？

MySQL reset root password

weixin_34128501的博客

10-08

289

2019独角兽企业重金招聘Python工程师标准>>> ...

Mac OS X - Reset MySQL Root Password

afunyusong的专栏

12-22

810

Mac OS X - Reset MySQL Root Password 在mac下reset root password后登录时有时会出现： ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.解决方法：Reset MySQL root

mysql reset root password_编程经验：mysql reset root password

weixin_32458131的博客

02-06

268

//************************************************#停止mysql服务，以及启动mysql时不启动grant-tables(授权表)C:\Program Files\MySQL\MySQL Server 5.5\bin>net stop mysqlMySQL服务正在停止..MySQL服务已成功停止。C:\Program Files\MySQL...

MySQL 8 You must reset your password using ALTER USER statement before executing this statement.

08-27

In MySQL 8, when you first install the server or reset the root password, you will see the message "You must reset your password using ALTER USER statement before executing this statement."....

Ubuntu18 重置MySQL8 root密码

coding_2020的博客

05-25

1520

Ubuntu 18.04 重置MySQL8 root密码问题购买云服务器后，选择了带MySQL环境的镜像，查看日志知道初始密码是空，但是使用’mysql -u root --skip-password’ 无法登陆数据库。官方参考：2.10.4 Securing the Initial MySQL Account # 查看MySQL安装日志 root@VM-0-16-ubuntu:/data# head /var/log/mysql/error.log|grep -E 'root' --color=au

[solved]access denied for user 'root'@'localhost' (using password no) ubuntu mysql

追梦船的专栏

01-26

1140

又忘记mysql密码了! 在网上找了找方法,找到了个十分简单的方法. 亲测ubutu可用.其他系统没有测试. sudo dpkg-reconfigure mysql-server-N.N N.N换成你mysql server的版本号. 而后按照步骤重置密码即可. 参考: https://help.ubuntu.com/community/MysqlPasswordRes

Reset the MySQL Root Password

白桦栎的博客

12-26

231

原文：Reset the MySQL Root Password Reset the MySQL Root Password By default, the MySQL installation that ships with XAMPP has an empty root password. This is a serioussecurity risk, especially if you plan to use XAMPP in production scenarios

How to Reset the Root Password 5.5

技术分享

11-29

484

B.5.3.2 How to Reset the Root Password If you have never assigned a root password for MySQL, the server does not require a password at all for connecting as root. However, this is insec

mysql reset root password_重置mysq root密码脚本

weixin_26933735的博客

02-26

447

你是不是遇到过这样的问题？1、一不小心，把刚安装的mysql root用户的密码忘记了。2、根据网上很多教程修改后，还是提示ERROR 1045 (28000): Access denied for user ‘root’@'localhost’ (using password: YES) 。3、一不小心，用root登陆mysql的时候，出现Access denied for user ‘root...

二进制安装MySQL 5.7.17 重置root密码

浮生若梦为欢几何

01-10

2771

拷贝support-files/my-default.cnf到/etc/my.cnf vim 编辑/etc/my.cnf,尾部追加一行 skip-grant-tables 重启MySQL服务进入MySQL，重置密码 mysql -u root #进入MySQL update user set authentication_string=PASSWORD('newpass') where

Mysql root 密码重置详解

鱼丸丶粗面

01-16

1721

Mysql root 密码重置详解

How to Reset MySQL root Password on CentOS

qingshuangwuhen的专栏

05-23

371

原网址：https://developer.codero.com/community/how-to-reset-mysql-root-password-on-centos/ There will be times when the root password for your MySQL instance is either forgotten or compromised. Thi

mysql 默认根密码,如何将MySQL根密码更改为默认密码？

weixin_39673184的博客

01-27

118

My initial installation for the MySQL had no password for root. I assigned a password for root and everything worked fine. Due to some reason (don't ask why) I had to revert back to the original setti...

How to Reset the root's Password for MySQL(MariaDB)

qq_28777839的博客

09-30

206

Unfortunately, I had forgotten the root's password of MySQL. Here, one of the methods is introduced, which works on my RasberryPi 3B+. Kill the process MySQL sudo killall mysqld #or sudo /etc/in...