• 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.

acces psa db from other host

J

joerg@

Guest
Hello,

we want to access the psa database from an other host in our network to read out some data.

When we try we get an error message that access ist denied. I suggest this is because access is only allowed from localhost.

Where can/must i setup access from other host ??

Thanks for hints

Joerg
 
My syntax may be incorrect. I'm doing this from memory, but this should at least give you an idea of what to do.

As root, first login to mysql on the server and open the database that you want to allow someone to access remotely:

mysql -u admin -p name-of-database
[enter plesk admin password when prompted]

>GRANT ALL TO username@ip-address-of-remote-server IDENTIFIED BY 'password-for-username';

NOTE: a) You need to include the single quotes around the password I think. I'm not sure. b) granting ALL is dangerous. It allows the user to drop tables and even access the filesystem. Not good. So you should really limit it to what is necessary (e.g. only grant updates and selects or whatever. Have a look at the mysql documentation with regards to the GRANT command.

REMEMBER: My syntax could be completely wrong. I may have forgotten the right commands and none of this will work. It may even damage things. Use with caution!

NOTE2: You may also need to open up your firewall to allow remote mysql connections from the IP of the remote user. From the sounds of things you don't need to do this in your case. But this indicates that you are currently allowing access to mysql from anywhere, and this is potentially a bad thing.

Faris.
 
Hello Faris,

thanks for your reply.

I installed phpmyadmin and added the user over the GUI, this worked fine,.

Best wishes

Joerg
 
Back
Top