Search  
   
Browse by Category
 
Netfirms 24/7 Support .: DATABASE MANAGEMENT .: How do I access my MySQL database remotely?

How do I access my MySQL database remotely?

To connect to your MySQL database remotely, enable remote access by following these steps:

I. Enable Remote MySQL Access from the Netfirms Control Panel
  1. Login to the Netfirms Control Panel at https://controlpanel.netfirms.com
  2. Click Site Tools
  3. Click Database Manager
  4. For the database you wish to connect to, click Admin
  5. Click Settings
  6. Using the pull-down menu, select Allow external connections
  7. Click Modify

II. Configure MySQL Connection Settings

You may use a MySQL client (ie. MySQL Front, HeidiSQL) or a Perl/PHP script or command line (% mysql -hmysql.netfirms.com -P3306 -pPassword -uUsername) to connect to your database remotely. Enter the following settings:

Database ID (as indicated in your Control Panel)
Username (as indicated in your Control Panel)
Password (as set by you in your Control Panel)
Host: mysql.netfirms.com
Port: 3306

How helpful was this article to you?


.: Powered by Lore 1.5.6
Visit Netfirms.com Web Hosting | Copyright © 1998 - 2006 Netfirms, Inc. All Rights Reserved.