Connect to MySQL with Navicat

 

You can connect to your server MySQL databases using NavicatNavicat 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.

http://www.navicat.com/en/download/download.html

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

  1. Open Navicat.
  2. Click the Connection button at the top right of Navicat. 
  3. Enter your Database Connection credentials.

    Database Credentials

    Connection name: Name this whatever you want
    Host Name/IP Address: Use your Domain name or Your cPanel IP address
    Port: 3306
    User Name: Your cPanel user or database user that was created
    Password: he cPanel or created user password

    Click Test Connection.

  4. 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.

  5. Click Ok again to accept the Connection Settings. 
  6. 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.

     

     

     

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.

War diese Antwort hilfreich?

 Artikel drucken

Lesen Sie auch

Simple .htaccess Tutorial

Introduction   In this tutorial you will find out about the .htaccess file and the power...

I need to be able to create thumbnails and my image program is asking for the path to Imagemagick?

For those of you who need to perform image manipulations such as build thumbnails, etc... the...

Common server path information

Common CGI Paths Perl 5: #! /usr/bin/perl Qmail: /usr/sbin/sendmail Date: /bin/date Domain...

.htaccess Tips and Tricks for Argon Hosting Cloud Server

For a comprehensive explanation on how to use a .htaccess file and how to create one, please see...

How do I connect to a mysql database that I have created in Plesk?

In order to connect to the database you just created in Plesk to your scripts or programs, you...