Originally Posted by tanvir
I have configured a two mail servers on openSUSE from here
. Now I want to change the password of MySQL and the server. Please tell me step by step how can I do it with out interrupting the services ?
Assuming you know your current 'root' passwords, to reset your system's 'root' password you need to login to your server via ssh and execute
it will ask you to enter and confirm your new system's 'root' password.
as for resetting the mysql's 'root' password, you need to login to your mysql server as root by executing:
once you're in, you need to change the database to 'mysql'
and then reset your mysql's 'root' password by executing:
mysql> update user set Password=PASSWORD('YOUR_NEW_PASS') WHERE User='root';
to quit the mysql shell type: