php artisan migrate 시 Access denied 발생

안녕하세요

laravel 초보입니다.

laravel-angular 프로젝트를 위해 공부하고 있습니다.
laravel-angular 임시 code를 받고
DB 연동을 위해 "php artisan migrate"를 진행했으나 아래와 같은 에러가 발생했습니다.

hsyoo@hsyoo-VC66-C:~/work/nginx_root/laravel/laravel5-angular-material-starter$ php artisan migrate

[Illuminate\Database\QueryException]
SQLSTATE[HY000] [1044] Access denied for user 'hsyoo'@'%' to database 'mysql' (SQL: select * from informationschema.tables where tableschema =
mysql and table_name = migrations)

[PDOException]
SQLSTATE[HY000] [1044] Access denied for user 'hsyoo'@'%' to database 'mysql'

또는
hsyoo@hsyoo-VC66-C:~/work/nginxroot/laravel/laravel5-angular-material-starter$ php artisan config:clear Configuration cache cleared! hsyoo@hsyoo-VC66-C:~/work/nginxroot/laravel/laravel5-angular-material-starter$ php artisan cache:clear Cache cleared successfully. hsyoo@hsyoo-VC66-C:~/work/nginx_root/laravel/laravel5-angular-material-starter$ php artisan migrate

[Illuminate\Database\QueryException]
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from informationschema.tables where tableschema = mysql and ta
ble_name = migrations)

[PDOException]
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'

환경:
DB : mariaDB 접속가능
hsyoo@hsyoo-VC66-C:~$ mysql -uhsyoo -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 38 <생략> MariaDB [(none)]> q!

.env
DBCONNECTION=mysql DBHOST=127.0.0.1 #DBHOST=localhost DBPORT=3306 #DBDATABASE=laravelangular #DBDATABASE=MariaDB DBDATABASE="mysql" #DBUSERNAME="root" DBUSERNAME="hsyoo" DB_PASSWORD="newpp0327"

database.php
'mysql' => [ 'driver' => 'mysql', // 'host' => env('DBHOST', 'localhost'), 'host' => 'localhost', 'port' => env('DBPORT', '3306'), 'database' => env('DBDATABASE', 'forge'), 'username' => env('DBUSERNAME', 'forge'), 'password' => env('DBPASSWORD', ''), 'charset' => 'utf8', 'collation' => 'utf8unicode_ci', 'prefix' => '', 'strict' => true, 'engine' => null,

comments powered by Disqus