How to connect to a database using Sequel Pro
- Category : MySQL Question
- Posted on : Oct 18, 2021
- Views : 925
- By : HostSEO
Although remote MySQL connection is disabled on our shared servers due to security reasons, you can still easily set up an SSH tunnel between your PC and our server using SSH-tunneling with the MySQL port (3306) forwarding. It will allow you to connect to the database remotely via the SSH tunnel.
To connect to your MySQL database with the Sequel Pro MySQL client, you should perform the following steps:
1. Contact our hosting support via Live chat or the ticket system in order to enable SSH access for your account
2. Launch Sequel Pro
3. Choose SSH under the connection details:
4. Fill out the fields as follows:
Name: the name you want to give the favorite
MySQL Host: 127.0.0.1
Username: your MySQL database username
Password: password for your MySQL user
Database: (optional) leave blank to have access to all of your databases
Port: 3306
SSH Host: server your account is hosted on (e.g., server1.web-hosting.com)
SSH user: your cPanel username
SSH Password: your cPanel password
SSH Port: 21098
5. Click on Add to Favorites:
6. You will see your new connection on the left:
7. Double-click on it to connect to your MySQL databases:
That's it!
             Â
                     Need any help? Contact our HelpDesk
Categories
- cPanel Question 47
- cPanel Software Management 29
- cPanel Tutorials 13
- Development 29
- Domain 13
- General 19
- Linux Helpline (Easy Guide) 156
- Marketing 47
- MySQL Question 13
- News 2
- PHP Configuration 14
- SEO 4
- SEO 42
- Server Administration 84
- SSL Installation 54
- Tips and Tricks 24
- VPS 3
- Web Hosting 44
- Website Security 22
- WHM questions 13
- WordPress 148
Subscribe Now
10,000 successful online businessmen like to have our content directly delivered to their inbox. Subscribe to our newsletter!Archive Calendar
Sat | Sun | Mon | Tue | Wed | Thu | Fri |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 | 29 |
30 |
Recent Articles
-
Posted on : Sep 17
-
Posted on : Sep 10
-
Posted on : Aug 04
-
Posted on : Apr 01
Tags
- ts
- myisam
- vpn
- sql
- process
- kill
- tweak
- server load
- attack
- ddos mitigation
- Knowledge
- layer 7
- ddos
- webmail
- DMARC
- Development
- nginx
- seo vpn
- Hosting Security
- wireguard
- innodb
- exim
- smtp relay
- smtp
- VPS Hosting
- cpulimit
- Plesk
- Comparison
- cpu
- encryption
- WHM
- xampp
- sysstat
- optimize
- cheap vpn
- php-fpm
- mariadb
- apache
- Small Business
- Error
- Networking
- VPS
- SSD Hosting
- Link Building
- centos
- DNS
- optimization
- ubuntu