View Single Post
  #2  
Old 29th July 2012, 09:52
rosehosting rosehosting is offline
Member
 
Join Date: Jun 2012
Posts: 39
Thanks: 0
Thanked 7 Times in 6 Posts
Default

Quote:
Originally Posted by tanvir View Post
Hello,

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 ?

Thanks
Tanvir
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

Code:
# passwd
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:

Code:
# mysql -u root -p
once you're in, you need to change the database to 'mysql'

Code:
mysql> use mysql;
and then reset your mysql's 'root' password by executing:

Code:
mysql> update user set Password=PASSWORD('YOUR_NEW_PASS') WHERE User='root';
to quit the mysql shell type:

Code:
mysql> \q
cheers
Reply With Quote