Connect to MySQL with Navicat
You can connect to your server MySQL databases using Navicat. Navicat is a "Remote MySQL database tool" that allows you access to your database from your local home computer. To connect with navicat you will need to download the latest software.
Download and Install Navicat
You can download navicat at the following url. This version is a Trial version. Navicat is not free they do require a payment to get the Trial removed from your installation.
Once you get the Executable for the program saved to your computer. Click the Installer icon to install Navicat.
Add your IP to Remote MySQL
Before you can get Navicat to connect, you will need to add your IP to the Remote MySQL connection.
You can do this by Logging into your cPanel click the Remote MySQL icon in the Databases section.
Add your IP to the Add Access Host and Click Ad host.
Steps to connect to your database with Navicat
please understand version changes and free trials are the sole responsibility of Navicat and Argon Web Management, Inc. does not control the availability of any Navicat downloads. This is for instructional purposes only.
- Open Navicat.
- Click the Connection button at the top right of Navicat.
- Enter your Database Connection credentials.
Connection name: Name this whatever you want
Host Name/IP Address: Use your Domain name or Your cPanel IP address
User Name: Your cPanel user or database user that was created
Password: he cPanel or created user password
Click Test Connection.
- You should get a Connection Successful pop up.
If not you will need to check the IP in Remote MySQL or check your username and password you are using. You also may need to use the IP and not your domain.
- Click Ok again to accept the Connection Settings.
- Your Database connection will show in the left pane listing the names of the database.Click one of the databases to look at the tables.
Now you can see all the options in Navicat. The tables will list in the main window.
Was this answer helpful?
For those of you who need to perform image manipulations such as build thumbnails, etc... the...
Introduction In this tutorial you will find out about the .htaccess file and the power...
For a comprehensive explanation on how to use a .htaccess file and how to create one, please see...
Common CGI Paths Perl 5: #! /usr/bin/perl Qmail: /usr/sbin/sendmail Date: /bin/date Domain...
NOTE: If you are using our Xenon Server cluster, you will need to make this change to...