How to Change MYSQL ‘da_admin’ User Password

Login to mysql server using current da_admin and 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 privileges 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 password line and delete the old password and copy the NEWPASSWD in place.

Updated on: 28/09/2018