cPanel Question posted in
The official documentation can be seen here.

Laravel Cpanel error :SQLSTATE[HY000] [1045] Access denied for user 'homeimpr_clranke'@'localhost' (using password: YES)

My env file as follow:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=admin_clrank
DB_USERNAME=admin_clranke
DB_PASSWORD=admin@123

i am getting the error and i have checked the username and password that are same.My website is in cpanel. config.php file is also delted.

Tags:

7

Answers


  1. 0

    Steps to debug:

    • check if you have .env file in server/cpanel usually we don’t publish .env files on server, if you have .env file then the username in your .env file and in error is different. Looks like database configuration is inside your config/database.php file.
    • check if database credentials in config/database.php file is correct
    • if nothing works create new database and user and then change your db credential in .env file if you are using .env else update credential in config/database.php file…
    Login or Signup to reply.
  2. 0

    Use console and artisan:

    php artisan config:cache

    This will clear cache configuration and then new settings will work.

    Login or Signup to reply.
  3. 0

    Try to use username and password as follows with quotation. i have no idea how it worked, but it really worked for me after searching a lot.

    DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=admin_clrank
DB_USERNAME='admin_clranke'
DB_PASSWORD='admin@123'
    Login or Signup to reply.
  4. 0

    it can be fixed by adding a ‘ single quote on database user and password

    DB_DATABASE=admin_clrank
DB_USERNAME='admin_clranke'
DB_PASSWORD='admin@123'

    like this. it will work fine for me

    Login or Signup to reply.
  5. 0

    1- Add single quote ‘ in username and password

    2- Then add this route in your web app and open it from browser:

    Route::get('/cleareverything', function () {
    
    $clearcache = Artisan::call('cache:clear');
    echo "Cache cleared<br>";

    $clearview = Artisan::call('view:clear');
    echo "View cleared<br>";

    $clearconfig = Artisan::call('config:cache');
    echo "Config cleared<br>";

});
    Login or Signup to reply.
  6. 0

    create and grant access to user homeimpr_clranke

    DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=admin_clranke
DB_USERNAME=homeimpr_clranke
DB_PASSWORD=password

    make sure your database name is also correct and take note your cpanel username is attached to the db_database

    Login or Signup to reply.
  7. 0

    change DB_HOST to localhost
    and run php artisan cache:clear
    and php artisan config:cache

    DB_CONNECTION=mysql
DB_HOST=localhost
DB_PORT=3306
DB_DATABASE=admin_clranke
DB_USERNAME=homeimpr_clranke
DB_PASSWORD=password
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search