Hi there, 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 [EMAIL PROTECTED] The problem is that when connecting I must supply a -h option to match the grant e.g. [EMAIL PROTECTED] mm1]$ mysql -u backup ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) [EMAIL PROTECTED] 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 :( Many Thanks, Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]