Access denied - Laravel/MySQL

Question

When i try to go on my app, i have this message :

SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost'

But when i make php artisan migrate, that work and tables are create on my local database ...

When i open mysql, i have :

Service : Mysql@localhost:3306
User : root
Password : ****

and my .env

APP_NAME=Laravel
APP_ENV=development
APP_KEY=**********************************
APP_DEBUG=true
APP_URL=localhost
TELESCOPE_ENABLED=true

LOG_CHANNEL=stack

DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=mydatabase
DB_USERNAME=root
DB_PASSWORD=root

My guess: Your CLI environment uses different DB credentials as your web environment — jrswgtr, Mar 09 '20 at 07:54
Check the password for the root account using PHPMyAdmin or something similair. — geertjanknapen, Mar 09 '20 at 08:15
It's fix, i forgot to said, i use Homestead, and we have to use the Homestead database, not local. — Simon, Mar 09 '20 at 08:31

score -1 · Answer 1 · answered Mar 09 '20 at 07:55

-1

You need to set a permission:-

try: GRANT ALL PRIVILEGES ON * . * TO 'your_user'@'localhost';

The error on your site now is the permission denied.

answered Mar 09 '20 at 07:55

Arpit Jain

1,217
8
27

not working, i tried `GRANT ALL PRIVILEGES ON * . * TO 'root'@'localhost';` but i have the same problem. Same with `GRANT ALL PRIVILEGES ON mydatabase.* TO 'root'@'localhost';` – Simon Mar 09 '20 at 08:00
@YannChapuis Can you please try with this ```php artisan config:clear``` and then open mysql – Arpit Jain Mar 09 '20 at 08:25

Access denied - Laravel/MySQL

1 Answers1