Search Our Database
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.