NYCPHP Meetup

[Analysis & Solutions]

Hi Peter:

On Fri, Jun 06, 2003 at 06:24:06PM -0400, Peter Lehrer wrote:
> 
> mysql> select Host, User,Password from user;
> +-----------+------+------------------+
> | Host      | User | Password         |
> +-----------+------+------------------+
> | localhost | root | 7a29160226fc5443 |
> | %         | root |                  |
> | %         |      |                  |
> +-----------+------+------------------+
> 
>   What is Host '%'? When I try logging on I get:

"%" is a wildcard.  So the second record says root can log in from 
anywhere without a password and the third record means anonymous access is 
granted from anywhere.  Not too secure.

For more info on how to tighten these permissions up, and for 
MySQL/Windows stuff in general, check out my tutorial:

http://www.analysisandsolutions.com/code/mybasic.htm#tighten

Enjoy,

--Dan

-- 
     FREE scripts that make web and database programming easier
           http://www.analysisandsolutions.com/software/
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7th Ave #4AJ, Brooklyn NY    v: 718-854-0335   f: 718-854-0409