MySQL Information

From Free Hosting Wiki
(Difference between revisions)
Jump to: navigation, search
[unchecked revision][unchecked revision]
(Created page with "To use MySQL in your website you will first need to create a MySQL database and a MySQL User. You can do this from cPanel. (Don't forget to link the User to your Database). Then ...")
 
(rev)
Line 1: Line 1:
To use MySQL in your website you will first need to create a MySQL database and a MySQL User. You can do this from cPanel. (Don't forget to link the User to your Database).
+
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'
+
* 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''
 
+
 
+
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