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