ERROR 1045 (28000):Access denied for user 'xxx'@'localhost'

[yehlu]

yehlu@posmr:~$ mysql yyy -u xxx -p
Enter password:
ERROR 1045 (28000): Access denied for user 'xxx'@'localhost' (using password: YES)

原因是原權限表格有一筆
任何 localhost 否 USAGE
砍掉就好了

或是登入時加上 -h 127.0.0.1 應也可以