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

Not able to access MYSQL DB from remotly

Hi,

 

I have been trying to connect to MYSQL DB from workbench. It is failing for last few days, Trying to explain support team in india they don't even understand the issue. 

1. It's plesk hosting

2. PHPMyAdmin it's working fine

3. From workbench it's not working 

Mysql 2.png

4. From online MYSQL tester https://www.rainbowspuppiessunshine.com/tools/dbtest/index.php it's not working 

Mysql 1.png

Host 148.72.232.184:3306
Database name Test123
User name test123
Password test123
 
Looks like the IP is not accepting any connections from outside network. 
 
Regards
5 REPLIES 5
Super User III
Super User III

Re: Not able to access MYSQL DB from remotly

@Udayakumar 

 

In mysql did you grant the user access from your local IP address.

 

The default permissions typically setup is user@localhost

You would need to add user@YOUR IP

 



I am a GoDaddy End User - Just Like You
Check out my site! | I currently manage over 300 WordPress Websites
* Please note that I offer free advice on this forum. If you would like personalized help, please contact me. Otherwise, please ask your question in the proper forum so the answer can assist EVERYONE in the community and not just you. Thanks! *

Once your issue is resolved,
please be sure to come back and click accept for the solution

Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community

Re: Not able to access MYSQL DB from remotly/?isc=gdcommment

It's GoDaddy shared DB server, I don't have access to the settings
Super User III
Super User III

Re: Not able to access MYSQL DB from remotly/?isc=gdcommment

@Udayakumar 

 

In phpMyAdmin you would need to run the following SQL statements

GRANT ALL ON `Test123`.* TO 'test123'@'YOURIP' IDENTIFIED BY 'test123';
FLUSH PRIVILEGES;

 

I do know that on certain servers,  GoDaddy only allows connections from within their network for security purposes. 



I am a GoDaddy End User - Just Like You
Check out my site! | I currently manage over 300 WordPress Websites
* Please note that I offer free advice on this forum. If you would like personalized help, please contact me. Otherwise, please ask your question in the proper forum so the answer can assist EVERYONE in the community and not just you. Thanks! *

Once your issue is resolved,
please be sure to come back and click accept for the solution

Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community

Re: Not able to access MYSQL DB from remotly/?isc=gdcommment/?isc=gdcommment

I don't think I have rights to execute the command

[image: image.png]
Super User III
Super User III

Re: Not able to access MYSQL DB from remotly/?isc=gdcommment/?isc=gdcommment

@Udayakumar 

 

The image didn't come through but if it gave an error message, you may not - As I said GoDaddy does lock some of this down for security purposes



I am a GoDaddy End User - Just Like You
Check out my site! | I currently manage over 300 WordPress Websites
* Please note that I offer free advice on this forum. If you would like personalized help, please contact me. Otherwise, please ask your question in the proper forum so the answer can assist EVERYONE in the community and not just you. Thanks! *

Once your issue is resolved,
please be sure to come back and click accept for the solution

Get Better Support on the Community Boards!
Etiquette When Asking for Help from the Community