Michael Shulman wrote, > Privilege changes (at least on Windows) don't seem to take effect until > either (a) the server is restarted, or (b) the server is instructed to > re-read its permissions tables.
Fair enough. I did FLUSH PRIVILEGES whenever I changed the user table. It seemed to me that the GRANT SQL didn't require a FLUSH, but I didn't use it to change passwords, just to add new users. However, that doesn't explain why logging in to mysql monitor went funny. I mean, the password I enter is the same, when I put it on the command line, or when I wait for mysql to prompt for the password. But it only works when I enter it on the command line. -- Helge Moulding mailto:[EMAIL PROTECTED] Just another guy http://hmoulding.cjb.net/ with a weird name _______________________________________________ Join Excite! - http://www.excite.com The most personalized portal on the Web! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
