MySQL Information

From Free Hosting Wiki
(Difference between revisions)
Jump to: navigation, search
[unchecked revision][quality revision]
(rev)
Line 1: Line 1:
 
Before being able to use MySQL, you should [[Create a MySQL Database And User]] through cPanel.
 
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:
 
Then you need to configure your script to connect to MySQL, the following settings should be used:
* Host/Server Name = '''localhost'''
+
* Host/Server Name: '''localhost'''
* Port = '''3306''' (not necessary)
+
* Port: '''3306''' (not necessary)
* Username = ''Your cPanel username followed by an underscore and the MySQL username you configured in cPanel''
+
* 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''
+
* 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''
+
* 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]]

Revision as of 17:22, 4 August 2010

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