Articles on: Direct Admin

How to Change MYSQL ‘da_admin’ User Password

  1. 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;

  1. 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

Was this article helpful?

Share your feedback

Cancel

Thank you!