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/4.1.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. Some Information on how to start local MySQL server (Linux platform).

The mysqld_safe script is written so that it normally can start a server that was installed from either a source or a binary distribution of MySQL, even though these types of distributions typically install the server in slightly different locations. mysqld_safe expects one of the following conditions to be true:

The server and databases can be found relative to the directory from which mysqld_safe is invoked. For binary distributions, mysqld_safe looks under its working directory for `bin' and `data' directories. For source distributions, it looks for `libexec' and `var' directories. This condition should be met if you execute mysqld_safe from your MySQL installation directory (for example, `/usr/local/mysql' for a binary distribution).

If the server and databases cannot be found relative to the working directory, mysqld_safe attempts to locate them by absolute pathnames. Typical locations are `/usr/local/libexec' and `/usr/local/var'. The actual locations are determined from the values configured into the distribution at the time it was built. They should be correct if MySQL is installed in the location specified at configuration time.

Because mysqld_safe will try to find the server and databases relative to its own working directory, you can install a binary distribution of MySQL anywhere, as long as you run mysqld_safe from the MySQL installation directory:

shell> cd mysql_installation_directory
shell> bin/mysqld_safe &

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

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 Linux version of MySQL Database
http://dev.mysql.com/downloads/mysql/4.1.html

Version Information
Navicat (Linux) version : 6.0 or higher