Not able to access MYSQL DB from remotly

[Udayakumar]

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 

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

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

[PL281]

@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

[Udayakumar]

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

[PL281]

@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. 

[Udayakumar]

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

[image: image.png]

[PL281]

@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