• 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!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

MySQL permissions

B

Bradley Munday

Guest
Hello,

I need to grant a mysql user created in plesk some permissions. Currently the user is unable to perform imports.
After not finding anyway to do this through the Plesk interface I went command line and ran the following mySQL command:

GRANT ALL PRIVILEGES ON databasename.* TO username@'localhost' IDENTIFIED BY 'password';

Then FLUSH PRIVILEGES;

However, the user still receives errors when trying to import.

Can someone confirm that this command is the best way to give additional permissions when using Plesk.

Many thanks
 
Back
Top