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 andreasml - September 3

Thanks Daniel

It was my mistake. I just had missed to create the database in advance and then connect it to the CMSB. I wonder whether it would be possible to create the new database through the "One minute installation" page; if it had been possible, it would be easier for the novice user to do a quick and easy CMSB installation.

Kind regards

Andreas

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