FAQ:Change MySQL Root Password

From VHCP Support

Jump to: navigation, search

How to change the MySQL Root Password?

  • Note if installed using the Debian packages that it makes a new MySQL admin user called vhcp by default


You can change the root password for MySQL as follows 

mysqladmin -u root password mynewpassword

or 

mysql --user=root -p

type the old password 

mysql> SET PASSWORD FOR 'root' = PASSWORD('password');
mysql> quit


Now can I update the new password in the vhcp system?

1. The new MySQL root password should be added in vhcp.conf. VHCP provides tool for this 

cd /var/www/webadmin/engine/
/var/www/webadmin/engine/
./vhcp-db-password

Please Enter Your Current Password: First type your current password and then the new one.


2. ProFTPD also needs the new root password for MySQL so you also have to edit the ProFTPD config file.

Edit /etc/proftpd.conf 

   # SQL SQLAuthTypes Crypt
   SQLAuthenticate on
   SQLConnectInfo vhcp@localhost root new_password
   SQLUserInfo ftp_users userid passwd uid gid homedir shell
   SQLGroupInfo ftp_group groupname gid members
   SQLMinID 2000

Restart ProFTPD 

/etc/init.d/proftpd restart


That's it! All needed changes are now done.

Retrieved from "http://support.vhcp.org/index.php/FAQ:Change_MySQL_Root_Password"
Personal tools