MySQL 'da_admin' user all of the sudden not working anymore

Hi,

I was using da_admin user to make backups of all my databases.
But all of the sudden I was getting 'Access Denied'.

So the password isn't working anymore. I checked the mysql database in the table users, and there is only root, no da_admin user.
Is that supposed to?
Should I create a new da_admin, or can I use the default root user?
And can I set a password on the root MySQL user? I'm not sure if DirectAdmin uses this is any way.

Thank you in advance.

Directadmin does set a root password on the root Mysql user by default.

Looks like the da_admin user got deleted them some how.

Try this:

See if you can login as root with that password if you don't have the root password.
If yes, create a new da_admin user with that password.

If not, you can also create a new Mysql root user password and da_admin user and pass. You can find all commands here:
https://help.directadmin.com/item.php?id=45

Hello,

florius said:

So the password isn't working anymore. I checked the mysql database in the table users, and there is only root, no da_admin user.
Is that supposed to?

Click to expand...

The user da_admin should exist, it's a Directadmin replacement of root user to connect to MySQL/MariaDB with super user privileges.

florius said:

Should I create a new da_admin, or can I use the default root user?

Click to expand...

Yes, you should re-create the user.

florius said:

And can I set a password on the root MySQL user? I'm not sure if DirectAdmin uses this is any way.

Click to expand...

The root user still exists alongside with da_admin and the both have different a password by default.