I have a problem with laravel and mysql. It is possible for me to php artisan migrate and seed my database. But on the other side accessing to a page using the database is impossible for me. I receive the following error:
SQLSTATE[HY000][1698] Access denied for user 'root' @'localhost' (SQL: select * from `users`)
My .env is correctly filled in (I can migrate without worries)
My application runs under a ubuntu 18.04.
Does anyone have any idea where this might come from?
The root user in mysql 5.7 now requires sudo. That means phpMyAdmin will not be able to use mysql -u root anymore instead use sudo mysql -u root credentials.
What you need to do is create a new user with the same privileges as the root credentials and use that instead.
Here's how you can do it.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments