DBへの接続エラー SQLSTATE[HY000] [1045] Access denied for user 'hoge'@'iphoge' (using password: YES) (SQL: select ... from hogetable ) mysql
<p>DB mysql への接続エラー
ちなみにlaravelつかってる</p><p>
SQLSTATE[HY000] [1045] Access denied for user 'hoge'@'iphoge' (using password: YES) (SQL: select ... from hogetable )</p><p>
一応こんな感じでユーザつくったらアクセスできた</p><p>CREATE USER 'hoge'@'%';
UPDATE mysql.user SET authentication_string=PASSWORD('hogehoge') WHERE User='hoge' AND Host='%';
GRANT ALL PRIVILEGES ON *.* TO 'hoge'@'%' IDENTIFIED by 'hogehoge' WITH GRANT OPTION;</p>