Search our database

How to change mysql ‘da_admin’ user password

1)   Login to mysql server using current ‘da_admin’ type the following command  at shell prompt:

  • Use mysql database(type command at mysql> prompt):
         mysql> use mysql;
  •  Change password for user da_admin, enter:
         mysql> update user set password=PASSWORD("NEWPASSWD") where User='da_admin';
  • Finally, reload the privilegies with:
         mysql> flush privileges;
         mysql> quit;
  • After that, we need to tell directadmin what are the new passwords. Edit with vim/nano or your favorite editor the file:
         vi /usr/local/directadmin/conf/mysql.conf
  • Edit the passwod line and delete the old password and copy the ‘NEWPASSWD’ in place.