NYCPHP Meetup

[Jerry Kapron]

I just realized that I did not really answer your questions.

>  What is Host '%'?
It means "from any host".

> Do you know why the mysql windows version creates host '%' in the user
> table?

All versions do that.


> When I try logging on I get:
> C:\\>mysqlc -h %
> ERROR 2005: Unknown MySQL Server Host (%) (1)

'%' does not identify any specific host. Use 'localhost' if you are connecting from the same machine.

Jerry


>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/dd33150a/attachment.html>