Assigning a MySQL Database User to a MySQL Database

Assigning the database user to a database

To assign a MySQL database user to a database, you can follow these steps:

1. Log in to cPanel.
2. Scroll down and click on ‘Manage My Databases’.
3. Under ‘Add User To Database’, from the dropdown menus, select the user and the database you would like the user to be assigned to.
4. Next, assign the privileges that you would like the user to have, for most cases, use the “ALL PRIVILEGES” box and click ‘Make Changes’.

All done, make sure to update your CMS’s configuration file with the database/database user and password.

Updating the database user password

To update a database user password, follow these steps:

1. Log in to cPanel.
2. Scroll down and click on ‘Manage My Databases’.
3. Under “Current Users” click on the ‘Change Password’ button.
4. Enter a new and secure password for the user. You can also use the password generator option if you prefer.
5. Click ‘Change Password’.

Make sure to update your CMS’s configuration file with the database/database user and password. Below are some steps to update your WordPress configuration file (wp-config.php) the process should be fairly similar for most CMS’s.

Updating your WordPress configuration file

If you update the database user password or assign a new database/database user to your WordPress website, you will more than likely have to update your wp-config.php file for your website to function correctly. Here’s how:

1. Log in to cPanel.
2. Click on File Manager and navigate to your website folder (usually under public__html).
3. Right-click on the file “wp-config.php and click ‘Edit’.
4. Scroll down till you find the following items
   • define( 'DB_NAME', 'database_name_here' );
   • define( 'DB_USER', 'database_user_here' );
   • define( 'DB_PASSWORD', 'password_here' );
5. Enter the updated database, database user and password where applicable between the quotes and click ‘Save’