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

Richard G

Verified User
Joined
Jul 6, 2008
Messages
5,254
Location
Maastricht
Oke first have a look if your da_admin mysql pass is still working.
Go to /usr/local/directadmin/scripts/setup.txt and see for the da_admin password there. Mind this is something else then the mysql root pass which is also in there.
If this does not work, also check /usr/local/directadmin/conf/my.cnf for the da_admin pass.

If they work, do you still need to change the da_admin pass for mysql?

P.s. what mysql are you running? Mysql or mariadb and what version?
 

wattie

Verified User
Joined
May 31, 2008
Messages
1,099
Location
Bulgaria
When you start MySQL with root user without password (the from the guide that you follow with the --skip-grant-tables option), run the following SQL statement:

Code:
REPAIR TABLE  mysql.user
After that, you may be able to login again. But that is maybe not the only corrupted table. You may want to repair all of them. This command should do it:

Code:
mysqlcheck -A --auto-repair
 
Top