How to work with MySQL databases

If you have a hosting account with us, you can use the information below to create a MySQL database:

1. allocate your database password (store this in a secure location)
2. access your control panel
3. click Web Tools
4. click MySQL Manager
5. click Add
6. select either MySQL 4 or MySQL 5
7. enter the database name (tip: add a number to the prefix provided)
8. enter the database password allocated earlier
9. click Next Step
10. note the database username displayed on the confirmation screen
11. click OK

Note: you cannot specify your database username. This is displayed when the database is first set up. You can view it later by clicking Details in the MySQL Manager section of your control panel.

If you need to administer the database, you can access phpMyAdmin from the Web Tools page of your control panel. When logging into phpMyAdmin, use the database username and password, not your hosting account username and password.

To change the database password, use MySQL Manager (under Web Tools, as above) - click the Password link next to the database you want to work with.

To connect to the database with scripts, use the connection details below:

	hostname	port
MySQL 4	username.dns-systems.net	3306
MySQL 5	mysql5.dns-systems.net	3307

Note that in the above table, username should be replaced with your hosting account username. For example, if your hosting account username is blazingfibre, then your MySQL 4 hostname will be blazingfibre.dns-systems.net. Do not use your database username here, use your hosting account username (the username used to log into your control panel).