In the last episode (Apr 29), Lou Olsten said: > I thought I had a handle on this, but now I'm all screwed up. > > MySQL 4.1.1a-alpha-max-debug-log > Windows 2000 Server > > I'm trying to create a user roby with a password of 'foo' with access to everything. > Here's what happens: > > - Sign in as root on the local host. > - GRANT ALL PRIVILEGES ON *.* TO roby@'%' IDENTIFIED BY 'foo' WITH GRANT OPTION; > - On same machine, try to login with: mysql -u roby -pfoo -h localhost > - Receive: ERROR 1045 (28000): Access denied for user: 'roby'@'localhost' (Using > password: YES)
Remember that localhost is a special keyword that refers to the unix-domain socket, and will not be matched with a wildcard '%' hostname. Use -h 127.0.0.1 or -h <publicip> if you are on the same machine as the server and want to test remote privs. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]