NYCPHP Meetup

NYPHP.org

windows version of mysql user question

Peter Lehrer pl at eskimo.com
Fri Jun 6 18:21:57 EDT 2003


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




More information about the talk mailing list