Error connecting to MySQL: 1045 - Access denied for user

4 posts by 2 authors in: Forums > CMS Builder
Last Post: September 3   (RSS)

By andreasml - August 31

Hi

I am trying to install the cmsb in a new directory, and after completing the one minute setup I get the following message back " Error connecting to MySQL: 1045 - Access denied for user".

Any assistance would be appreciated.

Kind Regards,

Andreas

By daniel - September 1 - edited: September 1

Hi Andreas, 

This error typically indicates some sort of permissions issue in the database configuration. There are many ways this could happen, but the first things I would check are:

  • *That the username/password being used is correct
  • *The database user has the correct privileges to access the site's database

Let me know if you're able to make any progress, otherwise, I may have some other troubleshooting steps I can point you towards.

Thanks!

Daniel

Technical Lead

interactivetools.com

By daniel - September 3

Hi Andreas,

CMSB should attempt to create a missing database if it doesn't exist and if the connecting user has the privileges to create databases. "Connect to database" and "create database" are different user permissions within MySQL, so it's possible to have users that work to connect but will not automatically create missing databases in this way. 

The way to change privileges in MySQL will differ depending on the environment and tools available, but commonly it can be done through PHPMyAdmin or directly with SQL commands (https://chartio.com/resources/tutorials/how-to-grant-all-privileges-on-a-database-in-mysql/)

Let me know if you have any other questions!

Thanks,

Daniel

Technical Lead

interactivetools.com