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)
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:mysqlbinwinmysqladmin.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 :
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)
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.
