• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Cannot assign multiple databases to single user per your instructions

LionGate

New Pleskian
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?
 
#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
 
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.
 
Ahhh -- I see -- you have to go in through the server admin panel to get to those settings. Light bulb comes on.
 
Yes you gotta go through the server admin (wherein you see all the dbs in phpmyadmin)
 
Back
Top