MySQL様のGrantをよく忘れる

mysql> grant all privileges on eccube_db.* to eccube@'192.168.1.*' identified by 'PASSWORD';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

$ mysql -u eccube -pPASSWORD eccube_db -h 192.168.1.10
ERROR 1045 (28000): Access denied for user 'eccube'@'192.168.1.10' (using password: YES)

ポッポー！（#・∀・）=3

mysql> grant all privileges on eccube_db.* to eccube@'192.168.1.%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye

$ mysql -u eccube -pPASSWORD eccube_db -h 192.168.1.10
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1435
Server version: 5.0.45 Source distribution

まあよく忘れるんですが、 grant の時は全指定するなら「*」じゃなくて「%」よね…。

mysql> set password for root@localhost=password('PASSWORD');

とりあえずインストールしたらこれよね。