cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Helper I

mysql database allow direct access

Hi folks, I have no problem creating databases. I do seem to have a problem allowing direct access to MySQL databases with Plesk hosting. At least I think that's the problem.

 

 

Can someone tell me how to do this ? Im assuming this is the problem as I have no problem working with my MSSQL databases.

Any help appreciated thanks.

1 REPLY 1
Super User II
Super User II

Re: mysql database allow direct access

Hello  ,

I hope you are well. You can prevent direct access to your mysql database. Follow these steps;

  • To configure mySQL in a way that it's not accessible from outside the server. See Restricting MySQL connections from localhost to improve security and it should be done on Firewall level as well (talk to the sysadmin)

  • Have the web app use a database user account that is limited in access to whatever tables and features the app needs to function.

Zulfiqar Anees | GoDaddy Pro | Founder/CEO at FastTech Media, TechMag, and ZulWeb.