With cPanel, individual database usernames are set up and assigned to connect with each database. A username can be linked to one database or it can be linked to several. Multiple usernames can also be assigned to each database.
Each user also has access privileges set for each database. This controls what functions the user can perform with the database.
Each script that connects to MySQL must have the database username and password set for use when making the database connection. The username will be of the format "uniqueid_username". The uniqueID will be the same for all databases and database users on your account and will be shown in the MySQL Databases tool.
Please be aware that these usernames and passwords are not the same as your login ID and password. These usernames are also not required to access phpMyAdmin in cPanel. phpMyAdmin is pre-installed in cPanel and configured to connect directly.
Forgot your database password and can't find it in your scripts? Learn how to create a new one. Be sure to update your scripts with the new password after creating it.
Important: For security, it is recommended to assign separate database usernames to each database created. It is also recommended to create only as many users as are necessary and to only assign them the privileges needed for the scripts being written.
