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
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 ipExample:
your env should be like this
finel step find ur pc ip address and and add it in cpanel Romote Mysql