Linux reset phpmyadmin root password through command

The following column phpmyadmin Getting Started Tutorial will introduce to you how to reset the phpmyadmin root password in Linux through commands. I hope it will be helpful to friends in need!

phpmyadmin Forgot your password, use the following code to modify it:

1. Stop the mysql service:

/etc/init.d/mysql stop

2. Skip verification and start MySQL

/usr/local/mysql/bin/mysqld_safe –-skip-grant-tables >/dev/null 2>&1 &

3. Prepare to reset the new password

/usr/local/mysql/bin/mysql -u root mysql

4. Reset the new password

update user set authentication_string = Password('新密码') where User = 'root';

5. Update Permissions

flush privileges;

6.Exit

exit;

7.Restart MYSQL

killall mysqld
/etc/init.d/mysql start
end

The above is the detailed content of Linux reset phpmyadmin root password through command. For more information, please follow other related articles on the PHP Chinese website!