Error connecting to MySQL: Access denied for user: ‘da_admin@localhost’ (Using password: YES):

Today When connecting to the MySQL in DirectAdmin , I got this error and that would indicated that the “da_admin” user has not been setup correctly. To resolve this I did following:

1) You need to Make sure the root mysql password works. If you know it, Go to mysql,  If you don’t..  then mysql root password can be found in the /usr/local/directadmin/scripts/setup.txt , if it has not been deleted.

It’s under the header “mysql=”.

If it cannot be found, then mysqld will have to be restarted with the –skip-grant-tables option as follows :

==========================================

# [root@test ~]# service mysqld stop

# [root@test ~]# mysqld_safe –skip-grant-tables &

===========================================

This will  start up mysql without the need for a root password. Then run

# [root@test ~]# mysql

You must be enetered to mysql prompt without password, Now run the following command once you’re in:

————————————–

# mysql > use mysql

# mysql > UPDATE user SET password=PASSWORD(‘newpass’) WHERE user=’root’;

# mysql > FLUSH PRIVILEGES;

# mysql > quit

—————————————-

That will reset the root password for you.

killl all process of mysqld and restart the mysqld
# [root@test ~]# killall -9 mysqld_safe

# [root@test ~]# killall -9 mysqld

and start it again :

# [root@test ~]# /sbin/service mysqld start

Now next
2)Once the root mysql password is set, then you can start resetting the da_admin mysql user.

Run :

#  [root@test ~]# mysql -uroot -p

Then press enter. You’ll be asked for the password. Enter the password that you’ve reset in step 1. Once in mysql,

Run:

# mysql > GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY ‘newdapass’ WITH GRANT OPTION;

#  mysql > FLUSH PRIVILEGES;

# mysql > quit

This will  set the password for da_admin in mysql.

Next in step  3) Now you need to make sure it’s setup correctly for Direct Admin to use.

Edit /usr/local/directadmin/conf/mysql.conf and enter

===================

user=da_admin

passwd=newdapass

===================

4) Now test it in DirectAdmin. It should be fixed now!!!!!!!