When a newly installed CMS is showing the MySQL error SQLSTATE[HY000] [1045] Access denied for user 'dbUSER'@'XXX.XXX.XXX.XXX' (using password: YES)
. Many CMS installation problems can be solved using the proper database and user settings.
Check Database and User
- Ensure all privileges are granted to the user
- Log into cPanel
- Navigate to MySQL Databases, located in the Databases section
- Scroll to Current Databases
- Locate the specific user for the database under the Privileged Users column
- Click the link of the database user's name next to the trash icon
- Select ALL PRIVILEGES
- Click Make Changes
- Test the credentials from the terminal command line using
mysql -p -u userna5 DATABASE
NOTE: You will be prompted to enter the password. The password will be hidden when pasting.
REPLACE: userna5 with the database username and DATABASE with the database name. - Use complete user/database name in settings
TIP: Databases and users created from cPanel will always have the cPanel username prefixed.
REPLACE: userna5_databasename replacing userna5 with the cPanel username and database name with the database name.
NOTE: If the database will reside on our server, ensure you use 'localhost' for the host.
Comments
0 comments
Article is closed for comments.