How to change ‘da_admin’ User Password in MySQL

Login to mysql server using current da_admin include the following commands in the shell prompt:

1. Use mysql database(type command at mysql> prompt):

         mysql> use mysql;

2.  Change password for user da_admin, enter:

         mysql> update user set password=PASSWORD("NEWPASSWD") where User='da_admin';

3. Finally, reload the privileges with:

         mysql> flush privileges;
         mysql> quit;

4. DirectAdmin will need to be configured with the new password. Edit with vim/nano or your favorite editor the file:

         vi /usr/local/directadmin/conf/mysql.conf

5. Edit the password line and delete the old password and copy the ‘NEWPASSWD’ in place.