I run a grant command like this:
mysql> grant all on db_name.* to user;
As is said in mysql manual that simple form like 'user' is the same with
'user''%', and % means anywhere but localhost, so the above command
means user can access db_name from anywhere but localhost. So on, so well.
But I found in a occident that I CAN access db_name from localhost, in
bash# mysql -u user -p -h 192.168.0.9
where 192.168.0.9 is the ip of localhost. And I run this command on the
same host as mysql server.
Is this a bug or ...