I have been trying to use the commandline mysql program, but I can't log in from the same machine:
[root@linux01 rcv]# mysql -u jwgas -p Enter password: ERROR 1045: Access denied for user: 'jwgas@localhost' (Using password: YES) But if I specify an ip address, I can !? [root@linux01 rcv]# mysql -h 127.0.0.1 -u jwgas -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 3.23.49 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Aborted And I can log in from another machine! here is my user table: mysql> select user, host from user; +-------------+----------------+ | user | host | +-------------+----------------+ | ace | % | | jwgas | % | | phpws | % | | root | linux01.jw_d11 | | | localhost | | ace | localhost | | phpws | localhost | | pma | localhost | | pnuke | localhost | | root | localhost | | widgetAdmin | localhost | +-------------+----------------+ 11 rows in set (0.01 sec) mysql> user jwgas should be allowed from any host!? is there any restriction on localhost? Thanks, John __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
