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 Hosting
  3. Choose Databases
  4. Click MySQL
  5. For the database you wish to connect to, click the corresponding plus sign located to the left of the Database Name
  6. From the Connection tab, refer to the Remote Connection section to select Allow from the Remote Access pull-down menu
  7. Click Update
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 - 2009 Netfirms, Inc. All Rights Reserved.