MySQL Information
From Free Hosting Wiki
(Difference between revisions)
| Line 3: | Line 3: | ||
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: | ||
| − | + | ;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.''' | '''''Remember:'' Free hosting accounts do not have remote MySQL access.''' | ||
[[Category:KB]] | [[Category:KB]] | ||
Latest revision as of 21:59, 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.
