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.
Oh?
More likely the symptoms are due to not having deleted the anonymous-user accounts. One of those accounts has a hostname of 'localhost', which is more specific than '%', and hostname matching happens before username matching.
http://dev.mysql.com/doc/mysql/en/Connection_access.html
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.
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
