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

[dannygoh]

I follow the guide here https://help.directadmin.com/item.php?id=45

When I ran the command, it have error below;

mysql> ALTER USER 'da_admin'@'localhost' IDENTIFIED BY 'qwerty';
ERROR 1805 (HY000): Column count of mysql.user is wrong. Expected 45, found 43. The table is probably corrupted

 

[Richard G]

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?

 

[Richard G]

Also check if the root pass is still working which you can find in the setup.txt I pointed at.

 

[wattie]

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:

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:

mysqlcheck -A --auto-repair