I'm seeing some problems with the way I've granted access to different users. I've setup the server to allow access only from certain clients. For example, the backup user is only allowed access from some machines:
GRANT SELECT ON testdb.* TO backup@127.0.0.1
The problem is that when connecting I must supply a -h option to match the grant e.g.
[mm1@localhost mm1]$ mysql -u backup ERROR 1045: Access denied for user: 'backup@localhost' (Using password: NO) [mm1@localhost mm1]$ mysql -u backup -h 127.0.0.1 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 32 to server version: 4.0.15-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
Is there an option to get the MySQL server to resolve localhost to 127.0.0.1 automatically? Or do I just have to use the -h option everywhere? It's not a big problem for me, but somewhat of an annoyance
If you would like to report an abuse of our service, such as a spam message, please . Если Вы хотите пожаловаться на содержимое этой страницы, пожалуйста .
