Thursday, January 24, 2008

MySql Remote connection Using Navicat

What is Navicat?

Navicat is a set of graphical database management, reporting and monitoring tools for MySQL database systems. It allows to to perform all database management functions from a comfortable interface, rather than the command line. You can create tables, manage data, set user permissions, run queries and much more. Also includes comes a backup options, server monitoring and tools to create reports and more. The included Import Wizard allows you to import data from various sources, including MS Access database, Excel, text files and many other formats. MySQL Studio is an extremely useful package for anyone that is either administering or using MySQL server on a regular basis, since it not only makes day-today routine jobs a lot easier, but also provides an overall much easier way to manage advanced MySQL functionality.

You can download Navicat from

http://www.topshareware.com/Navicat-download-40530.htm
http://www.navicat.com/download.html

Connection Settings.
--------------------

Host name : yourdomain name/server IP
Port : 3306
Username : database user name (for cpanel server it is cpanel-username_dbuser
Password : dbuser password.

Also you should have to check whether the server allowing remote connection to the server. If not please check my topic about enabling remote connection in the server.

No comments: