Where do I find my connection details for my MySQL Database?

The connection settings for MySQL can be different for each Weberz Hosting account or each database within a Weberz Hosting account. This is due to Weberz hosting their databases on separate servers than your website. This can be confusing since most installation instructions for scripts on the new default to using “localhost” for the database server name. On the Weberz Hosting network the database server name will never be “localhost” unless you run your own dedicated server that’s not connected to H-Sphere, the Weberz Hosting control panel.

All of the connection settings for your MySQL database are displayed in the control panel on the database management page. Here’s how you find the database management page in H-Sphere:

1. Login to the control panel system at http://www.weberz.com/
2. Choose “MySQL DB’s” from the “Databases” menu
   
3. Next click on the name of the database that you want the connection details for. This will take you to the Database Management page where you can locate the connection details.
   

On the Database Management page you will find all the information needed to connect to your MySQL database. Here’s an explaination for each item on the Database Management page:

• Hostname – The server name that should be used to connect to the MySQL server. This also lists the IP address of the server, however the server name should always be used when possible. If you use the IP address for your connection then your site may break if Weberz ever changes the IP address of the server. Weberz will always update the hostname listed with the proper IP address.
• Port Number – Weberz only uses the standard MySQL port of 3306 for our database servers. It’s displayed here to confirm with your web script in case it requires a port number to be specified.
• Database Name – The name of the database you created. When connecting to the database the name must be specified exactly as it appears here.
• phpMyAdmin – A link to the phpMyAdmin management portal where database tables can be managed and created. This is not part of the connection details but a good tool to use to manage your database tables and data.
• Database Users – A list of database usernames that you have authorized to access this database. Any of the usernames listed here, there is normally only one listed, can be used to connect to this database. The username will need to be entered exactly as listed to complete your connection to the database.

Database Passwords
Passwords for the database users are not displayed on the Database Management page in the control panel. If you have forgotten your password to the database you can reset the password for your database user by clicking the reset password icon next to the user.

If you do reset the password to your database then you will also have to put the new password into any web scripts or files that you have that already access databases using that database user account. If you fail to reset the password in your other web scripts or files their connections will immediately start to fail.