MySQL:如何重置或更改 MySQL 根密码? [英] MySQL: How to reset or change the MySQL root password?
问题描述
如何更改 ubuntu 服务器中的 MySQL 根密码和用户名?在设置任何更改之前是否需要停止 mysql 服务?
我也有 phpmyadmin 设置,phpmyadmin 会自动更新吗?
在 Ubuntu Linux 上设置/更改/重置 MySQL 根密码.在终端中输入以下几行.
- 停止 MySQL 服务器:
sudo/etc/init.d/mysql stop
启动
mysqld
配置:sudo mysqld --skip-grant-tables &
在某些情况下,您必须先创建
/var/run/mysqld
:sudo mkdir -v/var/run/mysqld &&须藤 chown mysql/var/run/mysqld
- 运行:
sudo service mysql start
- 以 root 身份登录 MySQL:
mysql -u root mysql
将
YOURNEWPASSWORD
替换为您的新密码:更新mysql.user放密码 = PASSWORD('你的新密码')在哪里用户 = 'root';同花顺特权;出口;
<块引用>
注意:在某些版本上,如果 password
列不存在,您可能需要尝试:UPDATE user SET authentication_string=password('YOURNEWPASSWORD') WHERE user='root';
注意:此方法不被认为是最安全的密码重置方式,但确实有效.
参考文献:
How do I change the MySQL root password and username in ubuntu server? Do I need to stop the mysql service before setting any changes?
I have a phpmyadmin setup as well, will phpmyadmin get updated automatically?
Set / change / reset the MySQL root password on Ubuntu Linux. Enter the following lines in your terminal.
- Stop the MySQL Server:
sudo /etc/init.d/mysql stop
Start the
mysqld
configuration:sudo mysqld --skip-grant-tables &
In some cases, you've to create the
/var/run/mysqld
first:sudo mkdir -v /var/run/mysqld && sudo chown mysql /var/run/mysqld
- Run:
sudo service mysql start
- Login to MySQL as root:
mysql -u root mysql
Replace
YOURNEWPASSWORD
with your new password:UPDATE mysql.user SET Password = PASSWORD('YOURNEWPASSWORD') WHERE User = 'root'; FLUSH PRIVILEGES; exit;
Note: on some versions, if
password
column doesn't exist, you may want to try:
UPDATE user SET authentication_string=password('YOURNEWPASSWORD') WHERE user='root';
Note: This method is not regarded as the most secure way of resetting the password, however, it works.
References:
这篇关于MySQL:如何重置或更改 MySQL 根密码?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!