BUNTER, Tuesday, March 12, 2002, 5:45:00 PM, you wrote: BM> I tried the blank password by hitting enter instead of entering BM> text with no luck - same rejection. I shall try updating the BM> table. I thought that passwords could only be changed with BM> mysqladmin. The password will be unencrypted in the table won't BM> it?
Try to use GRANT statement to change root password. You can read about GRANT syntax, find example of usage at: http://www.mysql.com/doc/G/R/GRANT.html BM> Matt BM> P.S. I have not recieved any mails from this list since BM> joining on the 25th Feb - is it normally this quiet? BM> ------------------------------------------------------------------ BM> Date: Tue, 12 Mar 2002 15:39:10 -0000 BM> Subject: RE: MySQL 3.23.41 on RH7.2 BM> You could just log on and use update on the user table... BM> Or try entering a blank password? BM> Simon BM> All, BM> Installed MySQL as part of my setup. Server is running, I can BM> connect as root with no password. BM> I attempt : BM> mysqladmin -u root -p password 'newpassword' BM> I get : BM> Enter password : blahblahblah BM> root@localhost rejected BM> I looked at the user table and there are blank spaces for root BM> both on the machine name and for localhost. BM> Why can I not change the password for root? Any ideas? BM> Regards, BM> Matt -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php