User not assigned to database????

[CursingEyE]

Hey all,

I have moved over from our old crappy hosting to a new DA server, I had to move the databases manually as there is no easy way to do this without changing the database names. Its all working however in the logs I keep seeing

"User username wasn't assigned to database username_shop, adding it in the backup."

Is there anyway to assign them to it to fix this error.

Thanks

 

[floyd]

I just experienced this too. I need the answer as well.

 

[andyreed]

I just experienced this too. I need the answer as well.

This tutorial might help: http://dev.mysql.com/doc/refman/5.1/en/adding-users.html

 

[DirectAdmin Support]

Hello,

User username wasn't assigned to database username_shop, adding it in the backup.

is referring to how DA manages databases. When you create a database through DA, it assigns the user you set to that database, eg "username_dbuser". However, all databases also have the "username" assigned to the database as well.. this is hidden. This user is what DA uses for restores (changes the pass temporarily, then sets it back). Anyway, the error means you're missing the "username" user on the database. You can either add it to the database with the guide listed by Andy (eg: with /phpMyAdmin using the user/pass from /usr/local/directadmin/dconf/directadmin.conf), or simply delete the database, create it through DA so all users are present, then re-add your sql data to it (without deleting it).

John