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.
The best solution I've found is to include the line "flush privileges" into Mysql sessions that manipulate users or permissions. -ms -----Original Message----- From: Helge Moulding [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 01, 2003 3:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: password not working from command line Andy Eastham wrote: > Make sure you don't enter a space between -u and the username > and -p and the password ie mysql -uuser -ppassword Actually, that works for me, i.e. C:\Program Files\mysql40\bin>mysql -u root -p Enter password: ********* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 4.0.12-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> But now it gets weird. I should have said: that *used* to work for me. Earlier today I was working with that password issue from the other password thread, and I had finally got it all working the way I expected it to. Now I'm trying to answer Andy, and I find that it *no longer works*! Not even if I leave out the space between -u and root. Arrgh! The only thing that has changed since then is that I did shut down the server for a while. I can still make it work when I enter C:\Program Files\mysql40\bin>mysql -u root -pxxxxxxxxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 12 to server version: 4.0.12-max-debug Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Note the space between -u and root, and no space between -p and the password. (If I put a space in there, it doesn't see the password.) As was pointed out, it's not a good idea to put the password on the command line, since that puts it in plain text. OK, so what the heck is going on here???? Does MySQL have gremlins? Is this the same problem that Weldon was complaining about? -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]