MySQL Information
From Free Hosting Wiki
(Difference between revisions)
[quality revision] | [checked revision] |
(lnk) |
|||
Line 1: | Line 1: | ||
+ | With most web scripts, any data created when handling a page request is discarded when the script finishes. To be useful, scripts of consequence need persistant data storage. This usually means interacting with a database management system, such as MySQL. | ||
+ | |||
Before being able to use MySQL, you should [[How to Create a MySQL Database and User|create a MySQL database and user]] through cPanel. | Before being able to use MySQL, you should [[How to Create a MySQL Database and User|create a MySQL database and user]] through cPanel. | ||
Then you need to configure your script to connect to MySQL, the following settings should be used: | Then you need to configure your script to connect to MySQL, the following settings should be used: |
Revision as of 21:57, 30 January 2011
With most web scripts, any data created when handling a page request is discarded when the script finishes. To be useful, scripts of consequence need persistant data storage. This usually means interacting with a database management system, such as MySQL.
Before being able to use MySQL, you should create a MySQL database and user through cPanel. Then you need to configure your script to connect to MySQL, the following settings should be used:
- Host/Server Name: localhost
- Port: 3306 (not necessary)
- Username: Your cPanel username followed by an underscore and the MySQL username you configured in cPanel
- Password: The password that you used when creating the MySQL user
- Database: Your cPanel username followed by an underscore and the name of the database that you created in cPanel
Remember: Free hosting accounts do not have remote MySQL access.