The content of this article is to introduce how to change the mysql database password under Linux? How to change database password in Linux. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

How to modify Mysql under Linux (root password and modify root login permissions

The modified users are listed as root.

1. Know the root password of the original myql database;

①: Enter mysqladmin -u root -p password "new password" at the terminal command line and press Enter, Enter password: /* Enter the original old password*/
②: Log in to the mysql system to modify, mysql -uroot -p Enter password: /* Enter the original password */

mysql>use mysql;
mysql> update user set password=password(“新密碼”) where user=‘root’;        /* 密碼注意大小寫 */
mysql> flush privileges;
mysql> exit;
service mysqld/mysql statusservice mysqld/mysql restart/start

Then use the new password you just entered to log in.

2. I don’t know the original myql root password;
First of all, you must have root permissions on the operating system. If you don’t even have root permissions on the system, consider rooting the system first and then take the following steps. . Similar to logging in to the system in safe mode.

You need to stop the mysql service first. There are two situations. One can use service mysqld stop,

The other is /etc/init.d /mysqld stop

When prompted that mysql has stopped, proceed to the next step Shutting down MySQL. SUCCESS!

Enter on the terminal command line

mysqld_safe --skip-grant-tables &         /* 登錄mysql系統(tǒng) */

Enter mysql to log in to the mysql system

mysql> use mysql;
mysql> UPDATE user SET password=password(“新密碼”) WHERE user=‘root’;      /* 密碼注意大小寫 */
mysql> flush privileges;
mysql> exit;

Restart the mysql service

The new root password will be set successfully.

3. Modify root login permissions

After you modify the root password , this situation is very likely to occur

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

This is because the root login permission is insufficient , the specific modification method is as follows

You need to stop the mysql service first. There are two situations here. One can use service mysqld stop,

The other is /etc/init.d/mysqld stop

When prompted that mysql has stopped, proceed to the next step Shutting down MySQL. SUCCESS!

Enter mysql on the terminal command line to log in to the mysql system

mysqld_safe --skip-grant-tables &         /* 登錄mysql系統(tǒng) */

Then restart the mysql service.

First sentence: Log in as the authorized user root

Second sentence: Select the mysql library

Third sentence: View the mysql library The host value of the user table (that is, the host/IP name for connection access)
The fourth sentence: Modify the host value (add the host/IP address with the wildcard % content), of course you can also directly add the IP address
If there is an error in this step "ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'" It means that the record exists, skip this step
The fifth sentence: Refresh the MySQL system permissions related table
Sixth sentence: When checking the user table again, there are modifications. .
Restart the mysql service to complete.

MariaDB sets initialization password and changes password

Method 1:

mysql>use mysql;
mysql>update user set host = ‘%’ where user = ‘root’;
mysql>select host, user from user;
mysql> flush privileges;
mysql> exit;
service mysqld/mysql statusservice mysqld/mysql restart/start

Method 2:

[root@localhost ~]# mysql
MariaDB[(none)]> UPDATE mysql.user SET password = PASSWORD(‘newpassword’) WHERE USER = ‘root’;
MariaDB[(none)]> FLUSH PRIVILEGES;

Method 3:

[root@localhost ~]# mysql
MariaDB[(none)]> SET password=PASSWORD(‘newpassward’);

If root has set a password, use the following method

[root@localhost ~]# mysqladmin -u root password ‘newpassword’

How to modify Mysql under Linux ( Root's password and modification of root login permissions

The modified users are listed as root.

1. Know the root password of the original myql database;

①: In the terminal Enter mysqladmin -u root -p password "new password" on the command line, press Enter password: /* Enter the original old password */

②: Log in to the mysql system to modify, mysql -uroot -p press Enter password: /* Enter the original password */

[root@localhost ~]#mysqladmin -u root -p ‘oldpassword’ password ‘newpassword’

Then use the new password you just entered to log in.

2. I don’t know the original myql root password;

First of all, you must have root permissions on the operating system. If you do not even have root permissions on the system, consider rooting the system first and then take the following steps. It is similar to logging in to the system in safe mode.

You need to first Stop the mysql service. There are two situations here. One can use service mysqld stop,

The other is /etc/init.d/mysqld stop

When prompted that mysql has stopped, proceed Next step: Shutting down MySQL. SUCCESS!

Enter

mysql>use mysql;
mysql> update user set password=password(“新密碼”) where user=‘root’;        /* 密碼注意大小寫 */
mysql> flush privileges;
mysql> exit;
service mysqld/mysql statusservice mysqld/mysql restart/start

in the terminal command line

mysqld_safe --skip-grant-tables &         /* 登錄mysql系統(tǒng) */

Enter mysql to log in to the mysql system

mysql> use mysql;
mysql> UPDATE user SET password=password(“新密碼”) WHERE user=‘root’;      /* 密碼注意大小寫 */
mysql> flush privileges;
mysql> exit;

Restart the mysql service

This way The new root password has been set successfully.

3. Modify root login permissions

After you modify the root password, this situation is likely to occur

ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)

This It is because the root login permission is insufficient. The specific modification method is as follows

You need to stop the mysql service first. There are two situations here. One can use service mysqld stop,

The other is /etc/ init.d/mysqld stop

When prompted that mysql has stopped, proceed to the next step Shutting down MySQL. SUCCESS!

Enter on the terminal command line

mysqld_safe --skip-grant-tables &         /* 登錄mysql系統(tǒng) */

Enter mysql to log in to mysql System

mysql>use mysql;
mysql>update user set host = ‘%’ where user = ‘root’;
mysql>select host, user from user;
mysql> flush privileges;
mysql> exit;
service mysqld/mysql statusservice mysqld/mysql restart/start

Then restart the mysql service.

The first sentence: Log in as the authorized user root

The second sentence: Select the mysql library

The third sentence: View the host of the user table in the mysql library Value (the host/IP name for connection access)

Fourth sentence: Modify the host value (add the host/IP address with wildcard % content), of course you can also directly add the IP address

如果這步出錯(cuò)"ERROR 1062 (23000): Duplicate entry ‘%-root’ for key ‘PRIMARY’" 由說明該記錄有了，跳過這步

第五句：刷新MySQL的系統(tǒng)權(quán)限相關(guān)表

第六句：再重新查看user表時(shí)，有修改。。

重起mysql服務(wù)即可完成。

MariaDB設(shè)置初始化密碼及修改密碼
方法1：

[root@localhost ~]# mysql
MariaDB[(none)]> UPDATE mysql.user SET password = PASSWORD(‘newpassword’) WHERE USER = ‘root’;
MariaDB[(none)]> FLUSH PRIVILEGES;

方法2：

[root@localhost ~]# mysql
MariaDB[(none)]> SET password=PASSWORD(‘newpassward’);

方法3：

[root@localhost ~]# mysqladmin -u root password ‘newpassword’

如果root已經(jīng)設(shè)置過密碼，采用如下方法

[root@localhost ~]#mysqladmin -u root -p ‘oldpassword’ password ‘newpassword’

The above is the detailed content of How to change mysql database password under linux? How to change database password in Linux. For more information, please follow other related articles on the PHP Chinese website!