acces psa db from other host

[joerg@]

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

 

[faris]

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.

 

[joerg@]

Hello Faris,

thanks for your reply.

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

Best wishes

Joerg

 

[faris]

Hehe. Excellent

Faris.