NYCPHP Meetup

[Jerry Kapron]

Peter,
The 'Host' column in the 'user' table contains the *client* hosts from which corresponding users are allowed to connect to your MySQL server.
The '%' character is a SQL wildcard.  It matches any string, including empty string.
Go to http://www.mysql.com/doc/en/Connection_access.html
and http://www.mysql.com/doc/en/String_syntax.html#IDX968 for more info.

Jerry

--
42.7% of all statistics are made up on the spot. 


-----Original Message-----
From: Peter Lehrer <pl at eskimo.com>
To: NYPHP Talk <talk at nyphp.org>
Date: Friday, June 06, 2003 6:24 PM
Subject: [nycphp-talk] windows version of mysql user question


>I noticed in the table 'users' on mysql windows version '3.23.49-max-debug'
>that besides 'localhost' there is also a '%' host.
>
>mysql> select Host, User,Password from user;
>+-----------+------+------------------+
>| Host      | User | Password         |
>+-----------+------+------------------+
>| localhost | root | 7a29160226fc5443 |
>| %         | root |                  |
>| %         |      |                  |
>+-----------+------+------------------+
>3 rows in set (0.04 sec)
>
>
>  What is Host '%'? When I try logging on I get:
>
>C:\\>mysqlc -h %
>ERROR 2005: Unknown MySQL Server Host (%) (1)
>
>Do you know why the mysql windows version creates host '%' in the user
>table?
>
>
>Peter Lehrer
>
>
>
>--- Unsubscribe at http://nyphp.org/list/ ---
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20030606/dc34175f/attachment.html>