Welcome to the Treehouse Community
Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.
Looking to learn something new?
Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.
Start your free trial
Jeffrey Cheong
5,653 PointsHow to connect your Web hosting account to MySQL Workbench
I am trying to connect my Hosting account with GoDaddy to the MySQL workbench, im trying to get the ip and setting it up with workbench but It's not connecting. Can anyone help please?
4 Answers
Nathan Tallack
22,159 PointsCould you perhaps paste the log output from your workbench that it shows when it TRIES to connect? Be sure to redact any personal info from your paste so that you don't show your real login details. ;)
Jeffrey Cheong
5,653 PointsI would click on the 'test connection' button and then a pop-up with a with the following header 'Failed to Connect to MySQL at (account IP address) with user Jeff' with a sentence below saying 'Access denied for user 'Jeff'@IPaddress (using password:YES).
I've tried searching on YouTube for help but nothing really was helpful.
Simon Macpherson
1,482 PointsJeffrey,
Ensure you have enabled direct database access (DDA). DDA is only available on paid hosting plans. Assuming this is enabled, you may need to reset your password.
To reset your password:
- Log in to your Account Manager.
- Click Web Hosting.
- Next to the hosting account you want to use, click Manage.
- In the Databases area, click MySQL or MSSQL depending on the database type for which you want the host name.
- From your list of databases, click Actions next to the database you want to use, and then click Details.
- Your database's details displays including its username, host name, and a link to reset its password.
- Reset the password.
- Try authenticating again via MySQL Workbench.
Note: all of this information is available on the Go Daddy website.
Jeffrey Cheong
5,653 PointsHi Simon,
Okay so I tried all of the above and when I click on 'test connection' I get this error:
Failed to connect to MySQL at 'IP Address':3306 with user 'myusername'
Access denied for user 'myusername'@'Home IP Address' using password:YES
Simon Macpherson
1,482 PointsJeffrey,
This issue is probably related to MySQL authentication ordering.
Please paste the relevant excerpt from the workbench log so we can see more detail when the client is trying to connect. Omit all personal information i.e. username, password etc.
Jeffrey Cheong
5,653 PointsThis is the most recent log:
`Current user language: English (United States)
21:58:58 [INF][ Workbench]: UI is up 21:58:58 [INF][ Workbench]: Running the application 21:59:00 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Access denied for user 'presuser1'@'home-IP-ADDRESS' (using password: NO) 21:59:00 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Access denied for user 'presuser1'@'home-IP-ADDRESS' (using password: NO) 21:59:01 [INF][ WQE backend]: User cancelled connection 21:59:02 [INF][ WBContext]: Connection to PresDB1 cancelled by user: Cancelled 21:59:16 [ERR][ grt]: Invalid path element 'doc' in path: /wb/doc/physicalModels/0/catalog 21:59:43 [ERR][ grt]: Invalid path element 'doc' in path: /wb/doc/physicalModels/0/catalog `