Access denied for user da_admin – MySQL error in DirectAdmin

Usually we will encounter the subsequent MySQL issues in DirectAdmin.

Error connecting to MySQL: Access denied for consumer: ‘[email protected]’ (Employing password: YES)

Kindly take note of the steps given beneath to rectify this predicament.

1) Ensure that the MySQL root password is correct. Should you know the password, follow the second step.

a) You can uncover the MySQL root password in the following file.

/usr/local/directadmin/scripts/setup.txt

b) If you are unable to find out the password, you need to restart the MySQL using the option ‘skip-grant-tables’.

/etc/init.d/mysqld stop

mysqld_safe –skip-grant-tables &

After this, you will be able to access MySQL without root password.

c) Once you can access MySQL command prompt, execute the following commands to reset the MySQL root password.

use mysql

UPDATE user SET password=PASSWORD(’newpass’) WHERE user=’root’;

FLUSH PRIVILEGES;

Quit

d) Shutdown and start the MySQL.

killall -9 mysqld_safe

killall -9 mysqld

/etc/init.d/mysqld start

2) We can now reset the password of da_admin MySQL user.

a) Type the following command.

mysql -uroot –p

b) Enter the MySQL root password.

c) Execute the following commands in MySQL prompt.

GRANT ALL PRIVILEGES ON *.* TO [email protected] IDENTIFIED BY ‘daadminpass’ WITH GRANT OPTION;

FLUSH PRIVILEGES;

stop

That will set the password for da_admin in MySQL.

3) We need to ensure it is set up correctly for DA to use. Edit the MySQL configuration file and enter the new da-admin password.

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

user=da_admin

passwd=newdapass

That will resolve the issues and you will be able to access DirectAdmin again.

If you require any further assistance, please contact our support department.