Knowledgebase: Databases
How do I manage a MySQL database?
Posted by Joe Rebis (Import) on 29 September 2006 02:33 PM

 

Managing a MySQL database:

 

A MySQL database physically resides on a separate server. You will not be able to download it by FTP. Instead you will edit the database live in real-time.

 

To do this, you will need to connect to the database using a database management tool. For MySQL you have two choices:

  1. MySQL Manager Lite: This is software is free (currently) but has some limits to it's use. You can download it directly form their website. It has a very nice interface and it worth the full version purchase if you plan to use your database often. How do I manage a MS SQL database? [SEE: EMS SQL Manager downloads]
  2. PHPMyAdmin: This is free web-based application that can connect to and manage MySQL Databases. You will need to upload the application to your website and modify the configuration to connect to the database you wish to manage. [SEE: phpMyAdmin.net]

 

Connection Information:

IP Address: Please search the KB for "Important IP Addresses".

Port: 3306

Database: The database name you created.

Username: The database username you created.

Password: The database password you created.

 

NOTE: Instead of the IP address you can also use: sql.ephost.com or sql.your-domain.com. We suggest that you use the internal IP address above when connecting to the database from your scripts.

 

Complete details on how to manage your database from a programming standpoint is beyond the scope of this document. More information as well as tutorials can be found on the MySQL website.

 

SEE ALSO

 

 

(648 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).

Copyright © 2015 EPhost, Inc. All rights reserved.