* Warren Burstein <[EMAIL PROTECTED]> [2003-12-22 15:43 +0100]: > I tried to create a user by inserting directly into mysql.user. When > I set user.host to localhost, it works, when I set it to % it doesn't. > I thought % matched anything, and so should match localhost.
mysqld will ignore rows with wildcarded hostnames in the user table, if a row with a more specific (that is: non-wildcard) hostname matches (too). For example, if your user table has a row with (host="localhost", user=""), mysqld will prefer ""@localhost to [EMAIL PROTECTED] . Remember, that blank username values match ANY username. > In case I've missed something in the docs, please direct me to the > correct page. http://www.mysql.com/doc/en/Connection_access.html could be a good page to start reading at... If you still have problems with connection verification, please send me the output of 'select Host,User,Password from mysql.user;' . -- Johannes Franken MySQL Professional mailto:[EMAIL PROTECTED] http://www.jfranken.de/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]