PDA

View Full Version : How do I connect to my database using MySQL Workbench?



Max
February 15th, 2011, 02:07 PM
Before connecting connecting to your database using MySQL Workbench, you'll have to first get the host name or the IP address of the Hostek MySQL server your database is on.

For customers using the WCP control panel:

Login to your control panel
Under Databases, Click on MySQL.
You can find the host next to the database name.


For cPanel Customers:
You should be able to use your domain name as the host. However in order to connect externally to your database with programs such as MySQL workbench you'll need to enable remote MySQL access to your database.

Login to your cPanel
Under Databases go to Remote MySQL.
If you have a specific static IP you want to grant remote access to, you can enter it here and click on "Add Host". Otherwise you can grant remote access from any IP by entering % as the host and click on Add Host.




For WCP Customers:

Login to your hosting control Panel and go to your domain.
Click on MySQL Database and then click on your database.
Use the IP extenal address listed under Connection Information. (IPs started with 10.10.x.x will not work with MySQL Workbench because they are internal IPs within Hostek.)


Now you are ready to make a connection with MySQL Workbench.

Click on New Connection.
Connection Name: You can enter a name for this connection. This can be set to anything you would like.
Enter the IP address or hostname for your database.
Use the default port (3306).
Enter your database username.
Under Default Schema, type in your database name.
Test the connection to make sure your information is correct. You will be prompted for a password.
If the test is sucessful, click on OK. Otherwise double check the information you entered.
Your connection should be listed on the default Workbench screen. Double click on the connection name to connect.


Examples:
http://hostek.com/images/forum/workbench1.png

http://hostek.com/images/forum/workbench2.png