PDOException: SQLSTATE[HY000] [1044] Access denied for user

Permalink 1 user found helpful
When I am installing concrete5 version 8.5.1, there are 2 long long errors.

First error:
PDOException: SQLSTATE[HY000] [1044] Access denied for user

Second error:
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[HY000] [1044] Access denied for user 'unaux_23970071'@'192.168.%' to database 'home'

What can I do?

2 Attachments

View Replies:
JohntheFish replied on at Permalink Reply
JohntheFish
These errors look like they are to do with database user permissions. The database user that you give to concrete5 during the setup needs permission to do stuff with the databse. See item 5 at
https://documentation.concrete5.org/developers/installation/installa...

If you can't get full permissions for the db user, then you could try and set up a db user with INSERT, SELECT, UPDATE, DELETE, CREATE, DROP and ALTER. They used to be sufficient, but I don't know if that remains so for the current c5 core.

If you need help setting up the above, you could try your ISP technical support.
HosteyMega replied on at Permalink Reply 1 Attachment
Ok thanks! The installation can start now, but there is a new error occurred:
Please refer to the attached photo!
JohntheFish replied on at Permalink Reply
JohntheFish
What is the database collation set as?