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

• Creating a New Database (MS SQL & MySQL)
• Managing MS SQL
• Managing MySQL
• Data Source Names
• All DB Topics

SEE ALSO: Database Knowledge base Articles | "Important IP Addresses" knowledge base article

Contact Support

If you are still having issues, please contact us for further help.
1-877-EPHOST1 | support@ephost.com