[mysql] Access denied for user -- (using password: YES)") - 퍼옴

mysql db 접근 에러

"Access denied for user " "(using password: YES)")"

이렇게 나올 경우

-----------------------------------------------------------------------------------------
1. localhost와 %의  비밀번호가 다를 경우

mysql> use mysql

mysql> select * from user;

mysql> update user set Password=Password('password') where User='Username' and Host='%';

mysql> commit;

mysql> flush privileges;



2. 권한이 없을때

mysql> grant select, insert, update, delete, create, drop, alter on dbname.*to 'leo'@'%';

mysql> flush privileges;

-----------------------------------------------------------------------------------------------

출처 : http://shonm.tistory.com/entry/MYSQL-Access-denied-for-user-using-password-YES