MySQL - Setting up a connection from MySQL Workbench (SQL Development)


chadsxe
 Share

Recommended Posts

Hi - I am currently trying to figure out how to set up a connection from MySQL Workbench. I have

  • Created a new DB from cpanel
  • Created a new user for that DB from cpanel
  • Assigned 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....

Untitled-1-2.jpg

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

Link to comment
Share on other sites

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 :)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share