#mysql error

1 messages · Page 1 of 1 (latest)

cunning mulch
#

Hello'
I have a problem with my database (the connection) My setup:

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=controlpanel
DB_USERNAME=root
DB_PASSWORD="password"

In the configuration of mysql the host root = localhost and not has 127.0.0.1
Error :

production.ERROR: PDOException: SQLSTATE[HY000] [1045] Access denied for user
spring bison
#

Your DB configuration is wrong. Please write in english

cunning mulch
#

Yes

#

I modify

glass tinsel
#

no its not

#

wrong password

#

do you have special characters in your password like #?*+><"or something?

#

cause this can cause troubles

cunning mulch
#

I have a special character in my password

#

even if the password and between "password"

#

DB_PASSWORD="mypassword"

glass tinsel
#

this hsould work unless there is a " in your password

#

but you also shouldnt use rootas the db user

#

you should create your own

cunning mulch
tardy shale
#

Can you login using the same info via mysql? This is absolutely an error of mysql not letting you login due to permissions, user, or pass. Seems to me like host is fine but it's worth keeping in mind.

glass tinsel
#

you probably also got the remote login of the root user disabled

tardy shale
#

funny I did not even know about that.. that is a handy tip

cunning mulch
#

it doesn't work, I don't understand