Access denied for user da_admin – MySQL error in DirectAdmin
Generally we’ll get the next MySQL errors in DirectAdmin.
Error connecting to MySQL: Entry denied for consumer: ‘da_admin@localhost’ (Utilizing password: YES)
Please observe the steps given under to repair this situation.
1) Please guarantee that the MySQL root password is right. If you already know the password, observe the second step.
a) Yow will discover out the MySQL root password within the following file.
/usr/native/directadmin/scripts/setup.txt
b) If you’re not capable of finding out the password, it is advisable to restart the MySQL utilizing the choice ‘skip-grant-tables’.
/and so on/init.d/mysqld cease
mysqld_safe –skip-grant-tables &
After this it is possible for you to to entry MySQL with out root password.
c) As soon as you’ll be able to entry MySQL command immediate, run the next instructions to reset the MySQL root password.
use mysql
UPDATE consumer SET password=PASSWORD(’newpass’) WHERE consumer=’root’;
FLUSH PRIVILEGES;
Give up
d) Shutdown and begin the MySQL.
killall -9 mysqld_safe
killall -9 mysqld
/and so on/init.d/mysqld begin
2) We are able to now reset password of da_admin MySQL consumer.
a) Sort the next command.
mysql -uroot –p
b) Enter the MySQL root password.
c) Run the next instructions in MySQL immediate.
GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY ‘daadminpass’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
stop
That can set the password for da_admin in MySQL.
3) We want to ensure it’s setup appropriately for DA to make use of. Edit the MySQL configuration file and enter the brand new da-admin password.
/usr/native/directadmin/conf/mysql.conf
consumer=da_admin
passwd=newdapass
That can repair the problems and it is possible for you to to entry DirectAdmin once more.
When you want any additional assist please attain our assist division.