問題描述

如何更改 ubuntu 服務(wù)器中的 MySQL 根密碼和用戶名?在設(shè)置任何更改之前是否需要停止 mysql 服務(wù)?

我也有 phpmyadmin 設(shè)置，phpmyadmin 會自動更新嗎?

在 Ubuntu Linux 上設(shè)置/更改/重置 MySQL 根密碼.在終端中輸入以下幾行.

1. 停止 MySQL 服務(wù)器:sudo/etc/init.d/mysql stop
2. 啟動mysqld配置:sudo mysqld --skip-grant-tables &

在某些情況下，您必須先創(chuàng)建 /var/run/mysqld:

 sudo mkdir -v/var/run/mysqld &&須藤 chown mysql/var/run/mysqld

3. 以root身份登錄MySQL:mysql -u root mysql
4. 將 YOURNEWPASSWORD 替換為您的新密碼:

對于 MySQL <8.0

 更新mysql.user放密碼 = PASSWORD('你的新密碼')在哪里用戶 = 'root';同花順特權(quán)；出口;

<塊引用>

注意:在某些版本上，如果 password 列不存在，您可能需要嘗試:
UPDATE user SET authentication_string=password('YOURNEWPASSWORD') WHERE user='root';

注意:此方法不被認(rèn)為是最安全的密碼重置方式，但確實有效.

對于 MySQL >= 8.0

ALTER USER 'root'@'localhost' IDENTIFIED BY 'YOURNEWPASSWORD';

參考文獻(xiàn):

1. 在 Ubuntu 上設(shè)置/更改/重置 MySQL 根密碼Linux
2. 如何重置根密碼 (v5.6)
3. 如何重置根密碼 (v8.0)

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.

1. Stop the MySQL Server: sudo /etc/init.d/mysql stop
2. 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

3. Login to MySQL as root: mysql -u root mysql
4. Replace YOURNEWPASSWORD with your new password:

For MySQL < 8.0

    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.

For MySQL >= 8.0

ALTER USER 'root'@'localhost' IDENTIFIED BY 'YOURNEWPASSWORD';

References:

1. Set / Change / Reset the MySQL root password on Ubuntu Linux
2. How to Reset the Root Password (v5.6)
3. How to Reset the Root Password (v8.0)

這篇關(guān)于MySQL:如何重置或更改 MySQL 根密碼?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！