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;
After that, we need to tell directadmin what are the new passwords. Edit with vim/nano or your favorite editor the file:
Edit the password line and delete the old password and copy the NEWPASSWD in place.
Updated on: 28/09/2018
Thank you!