Linux > DirectAdmin

Error connecting to MySQL: Access denied for user: ‘da_admin@localhost’

(1/1)

jominj:
When connecting to the MySQL screens in DirectAdmin, if this error appears, that would indicated that the “da_admin” user has not been setup correctly. To resolve this do the following.

* Make sure the root mysql password works. The 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:

--- Code: ---service mysqld stop
mysqld_safe –skip-grant-tables &
--- End code ---

That should start up mysql without the need for a root password. Once in, type


--- Code: ---use mysql
UPDATE user SET password=PASSWORD(‘newpass’) WHERE user=’root’;
FLUSH PRIVILEGES;
quit

--- End code ---
That will reset the root password for you.

Type “killall -9 mysqld_safe; killall -9 mysqld” to shut down mysqld.

Start it up again with


--- Code: ---/sbin/service mysqld start
--- End code ---


* Once the root mysql password is set and known, then you can begin the process of resetting the da_admin mysql user. Type:

--- Code: ---mysql -uroot -p
--- End code ---
Then press enter. You’ll be asked for the password. Once in mysql, type:


--- Code: ---GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY ‘newdapass’ WITH GRANT OPTION;
FLUSH PRIVILEGES;
quit
--- End code ---

That should set the password for da_admin in mysql.


* Now we need to make sure it’s setup correctly for DA to use. Edit /usr/local/directadmin/conf/mysql.conf and set
user=da_admin
passwd=newdapass


* Test it out in DirectAdmin.

Navigation

[0] Message Index