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