CPanel SQLSTATE[HY000] [1045] Access denied for user

user_10951395 0
Viewed 2562

I'm a fresher in Cpanel laravel hosting. I'm facing a specific problem SQLSTATE[HY000] [1045] Access denied for user 'mbaam_trodian'@'localhost' (using password: YES) (SQL: select * from users where email = phar@gmail.com limit 1) and can't found any solution for 3 days.

Localhost: localhost setting

database user:

database user settings

.env file:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=mbaam_smart_hospital
DB_USERNAME=mbaam_trodian
DB_PASSWORD=*************
cpanel laravel access-denied hosting mysql
3 Answers

Try and removed all special characters from database password and replace with only alphabet or alphanumeric. for instance, DB_PASSWORD= mbamTrod0105

user_155190460
  1. make database user in your cpanel
  2. add newly created user into your .env file
  3. clear cache php artisan cache:clear and then php artisan config:cache or you can delete the files into bootstrap/cache folder then your laravel project work fine
user_120219240

mine worked after I created new user and assigned to the db.

user_164180160
Related