HostSEO Blog

Stories and News from IT Industry, Reviews & Tips | Technology Blog


How to connect to a database using the Workbench MySQL client

  • Category : MySQL Question
  • Posted on : Dec 18, 2021
  • Views : 1,076
  • By : HostSEO

Remote MySQL connection is disabled on our shared servers due to security reasons, but you can easily set up an SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding.

To connect to your MySQL database with the Workbench software you should do the following:

1. Follow the steps from this guide or contact our hosting support via live chat or the ticket system to enable SSH access for your account.
2. Open your Workbench application > Database > Connect to database to add a new connection or click on + icon. The setup window will show up, fill out the fields as follows:

Connection Method: Standard TCP/IP over SSH
SSH Hostname: your server hostname and port (e.g., server1.web-hosting.com:21098)
SSH Username: your cPanel username
SSH Password: click on Store in Vault â$¦ and type in your cPanel password

MySQL Hostname: 127.0.0.1
MySQL Server Port: 3306
Username: your database username
Password: click on Store in Vault â$¦ and type in your database password



Once done, you will need to re-enter your database password in the prompt window one more time.

3. After that a shortcut will be added, you will be able to connect to your database by clicking on it:





That's it!

              
                      Need any help? Contact our HelpDesk

 

Subscribe Now

10,000 successful online businessmen like to have our content directly delivered to their inbox. Subscribe to our newsletter!

Archive Calendar

SatSunMonTueWedThuFri
 12345
6789101112
13141516171819
20212223242526
27282930 

Born in 2004 ... Trusted By Clients n' Experts

SEO Stars

They never made me feel silly for asking questions. Help me understand how to attract more people and improve my search engine ranking.

Read More

Emily Schneller Manager at Sabre Inc
SEO Stars

Took advantage of Hostseo's superb tech support and I must say, it is a very perfect one. It is very fast, servers reliability is incredible.

Read More

Leena Mäkinen Creative producer
SEO Stars

We're operating a worldwide network of servers with high quality standards requirements, we’ve choose hostseo to be our perfect partner.

Read More

Ziff Davis CEO at Mashable
SEO Stars

It’s very comfortable to know I can rely about all technical issues on Hostseo and mostly that my website and emails are safe and secured here.

Read More

Isaac H. Entrepreneur
SEO Stars

With hostseo as a hosting partner we are more flexible and save money due to the better packages with great pricing, free SEO n' free SSL too!

Read More

Madeline E. Internet Professional