Frequently Asked Questions (FAQ)

MySQL

What is MySQL?
MySQL is an open source SQL (Structured Query Language) relational database management system. The MySQL software uses the GPL (GNU General Public License) meaning that it can be downloaded and used for free.

How do I create a database?
1) Log into your Cpanel
2) Under Site Management click on SQL Database
3) Next to Db type in the name of the database you wish to create
4) Under users, enter the name and password of the user that will access the database
5) Then on the line that contains 'User', 'Db', and 'Add User to Db', choose the name the user and the name of the database that you wish to give permission to access that database and click 'Add User to Db'.
6) Methods to access the database using Perl and PHP will then appear below the user's name under a heading called "Connection Strings".
- Tips: Remember to enter "YOUR username" + "_" BEFORE 1) the name of the database and 2) user you added to that database in order to connect to the database. Refer to the examples shown below "Connection Strings" as described above.

How do I modify (add/delete stuff) my database?
1) Log into your Cpanel
2) Under Site Management click on SQL Database
3) Click on phpMyAdmin
- Documentation for phpMyAdmin can be found here

What is my host name/server name in order to connect to my database from a Perl/PHP script I wrote?
- localhost