Importing Excel, Access or XML Data into MySQL Using Navicat - Page 4

by: PHP Builder Staff

December 29, 2003

Tips on Setup Connection Between Navicat and Your MySQL Server

Localhost Connection Setting

If you installed MySQL database on your local PC (download here), the default username is "root" and password is empty.

Localhost connection setting is similiar as following :

Host : localhost
Username : root
Password : (empty)
Port : 3306 (default)

Before you established local connection between Navicat and your local MySQL server, please also use our Launcher program to start your local MySQL server. You could also use another program to start your local MySQL server (Path : C:\mysql\bin\winmysqladmin.exe).

Remote Connection Setting

After MySQL database was installed, it would only allow "localhost" connection by default. Therefore, most server-side scripts program (e.g. phpMyAdmin) can easily connect with the local database in the same server. You could use Telnet or SSH program to manage your remote server because it's localhost connection.

Any client PCs will be blocked by the remote MySQL server until the user privileges has been configured. Remote connection setting is similiar as following :

Host : IP address of remote MySQL server
Username : Your_username (username is 'root' if you just installed the MySQL server)
Password : Your_password (Emtpy value if you just installed the MySQL server)
Port : 3306 (default)

NOTE: Navicat would be able to access your remote MySQL server no matter it is running on Linux, Unix, Mac, Windows platform. If you couldn't connect your remote MySQL server via Internet, please visit the Navicat web site for detailed explanation on MySQL Privileges System.

« Previous Page

Comment and Contribute

0 Comments (click to add your comment)

Your comment has been submitted and is pending approval.

Author:

Comment:

Name/nickname:
Email:

Comment:

(Maximum characters: 1200). You have characters left.