skip to Main Content

I am trying to connect my Laravel” (Locally setup) project with cPanel Mysql remotely. But I faced issues. Please help me how to solve this

Manage SSH already permitted and also I connect SSH tunnels.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=rashgsen_bdskills
DB_USERNAME=rashgsen_skills
DB_PASSWORD=B*****1desh@2020

When I try to run php artisan migrate its doesn’t work. Error show.

SQLSTATE[HY000] [1045] Access denied for user 'rashgsen_skills'
@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = ra
shgsen_bdskills and table_name = migrations and table_type = 'BASE TABLE')

  at F:xamppnewhtdocslaravelskillsbdvendorlaravelframeworksrcIlluminateDatabaseConnection.php
:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668|

  Exception trace:

  1   PDOException::("SQLSTATE[HY000] [1045] Access denied for user 'rashgsen_skills'@'localhost' (using
 password: YES)")
      F:xamppnewhtdocslaravelskillsbdvendorlaravelframeworksrcIlluminateDatabaseConnectorsCo
nnector.php:70

  2   PDO::__construct("mysql:host=127.0.0.1;port=3306;dbname=rashgsen_bdskills", "rashgsen_skills", "Ba*****esh@2020", [])
      F:xamppnewhtdocslaravelskillsbdvendorlaravelframeworksrcIlluminateDatabaseConnectorsCo
nnector.php:70

2

Answers


  1. You need to change your DB_HOST to be the remote host’s IP.

    Currently its pointing to your local host 127.0.0.1 and is being rejected because the username / password is not correct for this host. I assume you have changed these to match your remote’s username and password, but you have not changed your host ip

    Example:

    DB_HOST=198.4.5.1
    
    Login or Signup to reply.
  2. your env should be like this

    DB_CONNECTION=mysql
    DB_HOST=     // your cpanel domain ip address which u can see in statistics 
    DB_PORT=3306
    DB_DATABASE= // cpanel mysql db name
    DB_USERNAME= // cpanel mysql user
    DB_PASSWORD= // cpanel mysql pssword
    

    finel step find ur pc ip address and and add it in cpanel Romote Mysql

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search