MySQL Error

[GPNHosting]

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

Any ideas why this is happening? Any way to fix this?

[GPNHosting]

When I login as a user and attempt to restore a database it gives me the following:
------------------
Error Restoring database



Details
That database is not yours

[DirectAdmin Support]

Hello,

The "Access denied" error would be caused becuase the "da_admin" user isn't setup in mysql. It needs to be setup to have full root privileges. Normally this is done during the install, but if mysql already existed, and you chose to not overwrite it during the install, then the user won't be added.

The 2nd error: That database is not yours

means that the naming convention fo the database is off. The database name needs to match up with the username: username_db. For the next release of DA, the database restores will automaticaly adapt to a different username. (backup/restore feature).

John

[GPNHosting]

Hi, thanks all fixed.
Much easier than CPanel. Took about 10 minutes :).

[HeRCuL70]

i have same error too. how can i fix it?

[DirectAdmin Support]

http://help.directadmin.com/item.php?id=45

[HeRCuL70]

i know it.when i do it, i get the same error after 5 min