Cannot assign multiple databases to single user per your instructions

[LionGate]

I am running Centos6 with Plesk 11 and I am trying to assign a single user to have access to multiple databases. I am following the instructions given here: http://kb.parallels.com/en/115783

When I run the command GRANT ALL PRIVILEGES ON `newdb`.* TO 'olduser'@'%'; from the SQL tab in phpmyadmin, I am getting the following error:

#1044 - Access denied for user 'openemm2'@'%' to database 'openemm_cms'

openemm2 is the username I have assigned to this database -- why the error and what can I do about it?

 

[abdi]

#1044 - Access denied for user 'openemm2'@'%' to database 'openemm_cms'

The reason is right there ...

You need to login to MySQL as admin to execute those commands. You can do that via SHELL or navigate to system settings -> db management

 

[LionGate]

How do you log into phpmyadmin as admin? Plesk only allows you to log in as the user assigned to the DB. I can't create a second user for this DB called admin, as I just get a message that says admin already exists.

 

[abdi]

http://forum.parallels.com/showthread.php?55596-One-user-multiple-MySQL-databases

 

[LionGate]

Ahhh -- I see -- you have to go in through the server admin panel to get to those settings. Light bulb comes on.

 

[abdi]

Yes you gotta go through the server admin (wherein you see all the dbs in phpmyadmin)

 

[LionGate]

Thanks! You're my hero. ;-)