linux下MySQL忘记密码找回方法

1

service mysql stop

service mysql stop

1

/home/web/mysql/bin/mysqld_safe --user=mysql --datadir=/data/var --skip-grant-tables &

/home/web/mysql/bin/mysqld_safe --user=mysql --datadir=/data/var --skip-grant-tables &

1

/home/web/mysql/bin/mysql

/home/web/mysql/bin/mysql

1

use mysql

use mysql

1

update user set password=password("xmspace.net") where user="root";

update user set password=password("xmspace.net") where user="root";

1

flush privileges;

flush privileges;

1

service mysql restart

service mysql restart