My web site is hosted in a hosting company. I have no permission to add new user or change privileges. How can I get my Navicat to access my remote database?
Does your hosting company offer SSH connection? If the answer is yes, you can use Navicat to connect with your remote MySQL server via a SSH tunnel.

Steps:

1. Open the Terminal program and enter this command :

ssh -L 3307:remote_IP_address:3306 username@remote_IP_address

2. After you login your remote server by above command, you can create a connection in Navicat.

Navicat connection properties setting example:

host : 127.0.0.1 (Note: If MySQL server and SSH server are running on different machines, please use the correct host address of MySQL server from the remote network.)

username : database_user_name
password : database_password

port number : 3307 (It should match with the above command line).

For this method, it's the same as SSH Tunnel. It's not necessary to configure the MySQL privilege system.
Rating: (3471 Votes)
Was this answer helpful?: Yes   No
Related Topics
My web site is hosted in a hosting company. How can I get my Navicat to access my remote database?

Why I cannot connect to my MySQL Server?

I have a MySQL database set up with Hostway, how can I connect to it?

Why I received this error: 'Access denied for user abc@xxx.com.'

Print Article
Add to Favorites
Rate this Article