|
How do I manage 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:
- PHPMyAdmin: This is free web-based application that can connect to
and manage MySQL Databases. This is access by going to: http://mysql.oochie.com
- 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. See: http://www.sqlmanager.net/products/mysql/manager/download
Connection Information:
IP Address: mysql.oochie.com
Port: 3306
Database: The database name you created.
Username: The database username you created.
Password: The database password you created.
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.
|