Bug #99 % does not match the mysql host in mysql.user table
Submitted: 26 Feb 2003 4:06 Modified: 14 Jul 2003 6:49
Reporter: Lenz Grimmer Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:3.23.54 OS:Mac OS X (Mac OS X 10.2.4)
Assigned to: CPU Architecture:Any

[26 Feb 2003 4:06] Lenz Grimmer
Description:
Date: Tue, 18 Feb 2003 11:34:12 -0800 (PST) 
From: ewestbrook@apple.com 
To: mysql@lists.mysql.com 
Subject: % does not match the mysql host in mysql.user table 
 
>Description: 
        The % character in the Host field of the mysql.user table does not seem to match the host on 
which mysqld is running. 
>How-To-Repeat: 
>Fix: 
        GRANT USAGE ON *.* TO user@machine.apple.com 
 
>Submitter-Id:  <submitter ID> 
>Originator: 
>Organization: 
        Apple 
>MySQL support: none 
>Synopsis:      % does not match the mysql host in mysql.user table 
>Severity:      non-critical 
>Priority:      low 
>Category:      mysql 
>Class:         sw-bug 
>Release:       mysql-3.23.54 (Source distribution) 
 
>Environment: 
 
System: Darwin dzone200.apple.com 6.4 Darwin Kernel Version 6.4: Wed Jan 29 
18:50:42 PST 2003; root:xnu/xnu-344.26.obj~1/RELEASE_PPC  Power Macintosh 
powerpc 
 
 
Some paths:  /usr/bin/perl 
 
Compilation info: CC='gcc'  CFLAGS=''  CXX='g++'  CXXFLAGS=''  LDFLAGS='' 
LIBC: 
 
 
lrwxr-xr-x  1 root  wheel  15 Feb 14 16:49 /usr/lib/libc.dylib -> 
libSystem.dylib 
Configure command: ./configure '--prefix=/usr/local/simonSaysMySQL/' 
'--with-innodb' '--enable-thread-safe-client' 
 

How to repeat:
GRANT USAGE ON *.* TO user@'%' 
mysql -u user -h machine.apple.com (from machine.apple.com)
[19 Mar 2003 12:00] Michael Widenius
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.

There can be many reason why % doesn't match the hostname in the mysql.user table. The most common one is:

- There is another entry with higher priority that takes   precedence over the entry with host=%.

Without a full test case, including the information for all privilege tables and error codes one gets when trying to login it's impossible to say what's wrong.