To change your database password, follow these steps:
1. Go to the main MySQL databases menu and click on the name of the database.
2. A list of database users will appear. Click on the "Change Password" link to change the password for the database user.
3. Enter the new password and click the "Change" button. You don't need to know the old password to make this change.
When setting up your script, you'll need to know four things about your database: the database name, database username, password, and hostname.
The database name will look like ControlPanelUsername_DatabaseName. The ControlPanelUsername is the name you use to sign into the control panel, and DatabaseName is the name you give to the database.
For example, if you sign into the control panel as "gary" and create a database named "count," your database name would be gary_count.
The database username can be the same as the database name or you can choose a different username. It will look like ControlPanelUsername_DatabaseUserName.
The database password is set during database creation and should be different from your control panel password.
The hostname usually designated as 'localhost' because the script and database are on the same server. If the script doesn't allow text entry for the hostname, enter the IP address of your site.
After creating a database, you'll be given all this information on a screen. Take note of the values and enter them into your script configuration.
For example, if your database name is "sitehelper_chat" with username "sitehelper_gary", and your password is "youneverguess", and your access host is "localhost", your PHP script for database credentials would look like this:
<?php
$servername = "localhost";
$username = "sitehelper_gary";
$database = "sitehelper_chat";
$password = "youneverguess";
?>
