MySQL cannot modify how the password is handled

Two solutions to MySQL's inability to modify passwords

Method One:

#/etc/init.d/mysql Stop

# Mysqld_safe--user=mysql--skip-grant-tables--skip-networking &

# mysql-u Root MySQL

mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';

mysql> FLUSH privileges;

Mysql> quit

#/etc/init.d/mysql Restart

# mysql-uroot-p

Enter Password: < Enter the new password newpassword>

Mysql>

Method Two:

Use the username and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:

# mysql-udebian-sys-maint-p

Enter Password: < Enter the password for [client] section >

This column more highlights: http://www.bianceng.cn/database/MySQL/

mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';

mysql> FLUSH privileges;

Mysql> quit

# mysql-uroot-p

Enter Password: < Enter the new password newpassword>

Mysql>

Ubuntu MySQL installation path changes and password modification

First, modify the MySQL installation path

1 Stop MySQL Service

Sudo/etc/init.d/mysql stop

2 Copy existing data directory to target directory

sudo cp/var/lib/mysql/home/mysql

3 Modify Permissions

sudo chown-r mysql:mysql/home/mysql

sudo chmod 755/home/mysql

sudo chmod 660/home/mysql ib*

sudo chmod 755/home/mysql/mysql

sudo chmod 660/home/mysql/mysql/*

4 Modify MySQL configuration file

sudo vi/etc/mysql/my.cnf

Modify DataDir to/home/mysql

5 Modify Ubuntu-specific security mechanism

sudo vi/etc/apparmor.d/usr.sbin.mysqld

Modify/var/lib/mysql to/home/mysql

6 delete Ubuntu generated ~ file

sudo rm/etc/apparmor.d/usr.sbin.mysqld~

7 Reboot Complete

Sudo/etc/init.d/apparmor restart

Sudo/etc/init.d/mysql start

Two modify MySQL database password

Edit the user table directly with update

Mysql-u Root

mysql> use MySQL;

mysql> UPDATE user SET Password = Password (' newpass ') WHERE user = ' root ';

mysql> FLUSH privileges;

When you lose the root password, you can do this.

Mysqld_safe--skip-grant-tables&

Mysql-u Root MySQL

mysql> UPDATE user SET Password=password ("New password") WHERE user= ' root ';

mysql> FLUSH privileges;