Click Connections button from the main screen. Enter the name you wish to associate the connection with in Connection Name (this name will be used to indicate the connection in the Server Navigator). Enter either the hostname or IP address of you MySQL server in Host name. Check Use Compression if you want to compress the communication between Navicat and the MySQL server. Enter the port number into Port (3306 is the default port number on which MySQL runs). Provide the user name and password for the connection in User name and Password. Click the Save button to save your changes. The connection you have just set up should be displayed in the Server Navigator , Double click on the connection item to open your connection to the server. Remember that you can set up and open connections to multiple servers in Navicat.


Tips for using MySQL server for the first time

The following information is some tips that would assist you to start your MySQL server for first time:

1. MySQL database download URL : http://dev.mysql.com/downloads/mysql/5.0.html

After you intalled MySQL on your computer, please open Terminal program. Please try to use the following command to start the server:
For e.g.,
i.) cd /usr/local/mysql/bin
ii.) sudo ./safe_mysqld

For more detail on installation of MySQL Mac OS X version, please visit at http://dev.mysql.com/doc/mysql/en/mac-os-x-installation.html.

2. Localhost connection setting

If you installed MySQL database on your local computer, the default username is "root" and password is empty.

Navicat Localhost Connection Setting is similiar as following :
Connection name : <It can be any name. The connection name will be shown in left panel of Navicat main screen>
Host : localhost
Username : root
Password : (empty)
Port : 3306 (default)

Before you established local connection between Navicat and your local MySQL server, please firstly start your local MySQL server.

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

Navicat Remote Connection Setting is similiar as following :

Connection name : <It can be any name. The connection name will be shown in left panel of Navicat main screen>
Host : IPaddress 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)


4. SSH Tunnel

Does your remote server supports SSH connection? If yes, you can use Navicat to connect with your remote MySQL server via a SSH tunnel.

It's not necessary to modify your existing MySQL Privileges setting.

For SSH Tunnel setup details, please visit [SSH Tunnel Configuration].

5. Testing Account for your evaluation

We offer a testing account for you to evaluate Navicat more easily. Navicat remote connection setting for testing account:
Connection name : <It can be any name. The connection name will be shown in left panel of Navicat main screen>
Host: server1.navicat.com
username : navicat
password : testnavicat
Port number : 4406

NOTE: Navicat would be able to access your remote MySQL server whether it is running on Linux, Unix, Mac, Windows platform. If you couldn't connect your remote MySQL server via Internet, please kindly visit the FAQ section for detailed explanation.

Open an existing database
After establishing a connection to a server the Server Navigator will show a list of databases on the server. Double click on the preferred database to shows all the tables, queries and backups associated with the database.

Create a new database
After establishing a connection to a server, right click on the server connection in the Server Navigator and select New Database from the menu. Enter the name for the new database and click OK to create the database on the server. If the database was successfully created on the server it will be displayed in the Server Navigator. You can now double click on the database to open it.

Open an existing table
Open a connection to a MySQL server and then open a database on the server. In the Database Window, double click on a table to open the table in the Table window.

Create a new table
With an existing database open in the Database window select the Tables tab and click the New Table button at the Database window.

The Table Design Window provides a grid where you can enter fields together with their types and properties. A field's type can be selected from the Field Type list by clicking on the combo button. To set primary key, please double-click on Primary key box.

Select the Indexes tab to define the index(es) for the table. The Field Name grid is used to define the field(s) that make up the index. After defining all fields and indexes click Save, enter the name of the new table and click OK.

Download Mac OS X version of MySQL Database
http://dev.mysql.com/downloads/mysql/5.0.html

Version Information
Navicat (Mac OS X) version : 6.0 or higher