Before you establish a local connection between Navicat and your local MySQL server, use the launcher program to start your local MySQL server. You can also use WinMySQLAdmin to start your MySQL server (c:\mysql\bin\winmysqladmin.exe).
After MySQL is installed, by default, it only allows "localhost" connections. Therefore, most server-side scripts (e.g. phpMyAdmin) can easily connect with the local database on the same server. You can use Telnet or an SSH client to manage your remote server because it's also a localhost connection.
Any client PC/s will be blocked by the remote MySQL server until the user privileges have been configured.
A remote connections settings would look like this:
Host : IP address of remote MySQL server Username : Your_username (username is 'root' if you just installed MySQL) Password : Your_password (Emtpy value if you just installed MySQL) Port : 3306 (default)
NOTE: Navicat can access your remote MySQL server no matter if it’s running on a Linux, Unix, Mac, Windows platform.