Laravel 7.x 無法遠端連線數據庫？

Question

這是我在 .env 的設定

DB_CONNECTION=mysql
DB_HOST=xxx.xxx.xxx.xxx
DB_PORT=3306
DB_DATABASE=abc
DB_USERNAME=root
DB_PASSWORD=abc

xxx.xxx.xxx.xxx 是我server位置

我在我本地local下
mysql -u root -p -h xxx.xxx.xxx.xxx 試著遠端登入
是成功的

public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('email');
            $table->timestamps();
        });
    }

但我下 $ php artisan migrate 出現錯誤

   Illuminate\Database\QueryException 

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

我的phpmyadmin 已經設置帳戶

有人有遇過嗎？

Answer 1

Mysql分配用户权限

grant all privileges on *.* to root@'%' identified by 'root' WITH GRANT OPTION;

flush privileges;