MySQL Information

From Free Hosting Wiki
(Difference between revisions)
Jump to: navigation, search
[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 22: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.

Personal tools
Namespaces

Variants
Actions