| 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: | |
| 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 | |
[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.
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)