• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • 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.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

mysql access settings

J

JDCmedia

Guest
I was trying to access my mysql db remotely and found the following article:
/////////////////////////////////////////////////////////////////////
If it's a Plesk server running MYSQL, then you need to tell SQL to allow remote access to MYSQL from another server. Run the following on the Plesk MYSQL database server that you're trying to access remotely, changing the password, ip address, and username:

To allow certain ips access to MYSQL:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dmysql -e "insert into user values ('111.111.111.111', 'databaseusernamehere', password('databasepasswordhere'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N')"

and then run:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` -e "flush privileges;"
(Note:_ The Y's and N's above indicate permissions)

//////////////////////////////////////////////////////////////////
I performed this by logging into each dedicated domain IP on my server. It seems that they all have access to ALL databases.
Is there anything negative to doing this? If so, can someone tell me what the default settings are so I can change them back?
Another note: I changed all the 'N' permissions to 'Y'. Is that bad? Where can I find out what each parameter permission is setting?

:confused:
 
By changing N to Y, you have opened up your database to the world. Anyone can change anything, including Plesk virtual hosting info.

VERY BAD.
 
Back
Top