How to connect to mysql database remotely with mysql workbench | GoDaddy | 2018

How to connect to mysql database remotely with mysql workbench | GoDaddy | 2018



If you liked this video, then please Like and consider subscribing to our channel for more videos.

Hopefully, you enjoyed Connect to MYSQL database remotely Tutorial. Leave your thoughts in the comments below.
———————————————————————————————————–
Follow us

For any further support, drop an email at [email protected]
————————————————————————————————————

Connect remotely to databases

Connecting remotely to a database lets you manage it using tools like MySQL Query Browser, MySQL Workbench.

MYSQL CLIENT APPLICATIONS

MySQL provides several GUI (graphical user interface) client applications that you can use:

MySQL Workbench: This integrated tools environment enables you to manage databases, run queries, and much more. It replaces the older MySQL GUI Tools application bundle.

MySQL Workbench

MySQL Workbench enables you to quickly and securely connect to your MySQL databases using an SSH tunnel. To do this, follow these steps:

1. Start MySQL Workbench.
2.From the workspace page, click New Connection. The Setup New Connection dialog appears.
3. In the Connection Name text box, type a name for the connection.
4. In the Connection Method list box, select Standard (TCP/IP) over SSH.
5. In the SSH Hostname text box, type example.com, where example.com represents your domain name.
6. In the SSH Username text box, type your GoDaddy Hosting (cPanel) account username.
7. In the MySQL Hostname text box, type localhost or (127.0.0.1).
8. Confirm that the MySQL Server Port text box is set to 3306.
9.In the Username text box, type one of the following usernames:
A. Your GoDaddy Hosting (cPanel) account username: With this username, you can access all of the MySQL databases on your hosting account.
B. A MySQL database username you created in cPanel: With this username, you can access all of the MySQL databases for which the specified user has been granted privileges.
10.Click Test Connection. The Open SSH Tunnel dialog box appears.
11. In the Password text box, type your GoDaddy Hosting (cPanel) account password.
12. Click OK. The Connect to MySQL Server dialog box appears.
13. In the Password text box, type the password for the username you specified in step 9.
14. Click OK. If the connection is successful, you receive a Connection parameters are the correct message. If you do not receive this message, check the values you specified in steps 3 to 9, and then try again.
15. On the Setup New Connection dialog box, click OK.
16. You can now run queries, create tables, and more. For example, from the workspace page, under Open Connection to Start Querying, double-click the connection name you specified in step 3. MySQL Workbench connects to your account and displays your databases.

13 thoughts on “How to connect to mysql database remotely with mysql workbench | GoDaddy | 2018

  1. hi guys, question, so once you create your database in Godaddy you can access it from any computer from any script?

  2. I tried to use it using cpanel in interserver, but it won't let me… what all do I need to make this connection? like, do I have to downlaod the MySQL onto my mac before a connection will be allowed to my cPanel MySQL??

  3. This worked for me!
    Thank you very much. I've been looking for a way to connect to my cPanel databases using MySQL Workbench. I followed your steps to the letter. The SSH hostname is my cPanel login username and the username is the database username tied to the database I need to connect to.
    This method can only connect you to a single database per connection. You cannot have a single connection to all your databased.
    Cheers.

  4. Hi I get that error java.sql.SQLNonTransientConnectionException: Public Key Retrieval is not allowed could you help me

  5. Hi , I am try to connect mysql from godaddy to workbench but I have a problem in the connection , I see other video and they give some permission with the ipadress on "mysql remote" you create that permission after or before your video??

Leave a Reply

Your email address will not be published. Required fields are marked *