Skip to main content
Help Center
The GoDaddy Community will undergo maintenance starting on Tuesday, August 3rd at 3pm PST / 6pm EST. Learn more
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Go to solution
Mike12
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 ACCEPTED SOLUTION
Zulfiqar
Resolver VI

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 | Founder/CEO at FastTech Media, TechMag, TechKnowable, and ZulWeb | GoDaddy Pro.

View solution in original post

1 REPLY 1
Zulfiqar
Resolver VI

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 | Founder/CEO at FastTech Media, TechMag, TechKnowable, and ZulWeb | GoDaddy Pro.

View solution in original post