chadsxe Posted October 31, 2010 Report Share Posted October 31, 2010 Hi - I am currently trying to figure out how to set up a connection from MySQL Workbench. I have Created a new DB from cpanelCreated a new user for that DB from cpanelAssigned that use to the DB I am then opening up the MySQL Workbench enviroment and attempting to create a new connection. The connection wizard looks like sooo.... I feel this out as so.. Hostname - chadramos.net username - "the user I created in cpanel" default schema - whatever I decide to name the schema I then hit test connection and enter the password that I assigned to the user and I get a message that states that "Your connection attempt failed for use '******' from your host to server at chadramos.net:3306:" It also asks me to - check that mysql is running on server chadramos.net - check that mysql is running on port 3306 - check that user has rights to connect to chadramos.net from your address - make sure you are both provigind a password if needed and using the correct password. Any adivce? Regards Chad Quote Link to comment Share on other sites More sharing options...
Brian Posted October 31, 2010 Report Share Posted October 31, 2010 Hiya Chad, Give this a shot: 1) Login to cPanel 2) Type 'Remote' into the top left finder, this will bring up the Remote MySQL interface 3) Add the IP address you're attempting to connect from 4) Give it a shot! You can also consult this, basically has the same instructions: https://support.hawkhost.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=144 This should do the trick for you, as it sounds like you've covered everything else Quote Link to comment Share on other sites More sharing options...
chadsxe Posted November 1, 2010 Author Report Share Posted November 1, 2010 Hiya Chad, Give this a shot: 1) Login to cPanel 2) Type 'Remote' into the top left finder, this will bring up the Remote MySQL interface 3) Add the IP address you're attempting to connect from 4) Give it a shot! You can also consult this, basically has the same instructions: https://support.hawkhost.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=144 This should do the trick for you, as it sounds like you've covered everything else That worked. Thank you. Chad Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.