RE: MySQL 3.23.41 on RH7.2
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
RE: MySQL 3.23.41 on RH7.2
--- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.45 I tried the blank password by hitting enter instead of entering text with no luck - same rejection. I shall try updating the table. I thought that passwords could only be changed with mysqladmin. The password will be unencrypted in the table won't it? Matt P.S. I have not recieved any mails from this list since joining on the 25th Feb - is it normally this quiet? -- Date: Tue, 12 Mar 2002 15:39:10 - Subject: RE: MySQL 3.23.41 on RH7.2 You could just log on and use update on the user table... Or try entering a blank password? Simon -Original Message- From: BUNTER MATTHEW [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 15:32 To: [EMAIL PROTECTED] Subject: MySQL 3.23.41 on RH7.2 --- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.32 All, Installed MySQL as part of my setup. Server is running, I can connect as root with no password. I attempt : mysqladmin -u root -p password 'newpassword' I get : Enter password : blahblahblah root@localhost rejected I looked at the user table and there are blank spaces for root both on the machine name and for localhost. Why can I not change the password for root? Any ideas? Regards, Matt 12/03/02 16.32 Envoyé à --- 12/03/02 16.45 Envoyé à --- -> mysql(a)lists.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
RE: MySQL 3.23.41 on RH7.2
You could just log on and use update on the user table... Or try entering a blank password? Simon -Original Message- From: BUNTER MATTHEW [mailto:[EMAIL PROTECTED]] Sent: 12 March 2002 15:32 To: [EMAIL PROTECTED] Subject: MySQL 3.23.41 on RH7.2 --- Reçu de RVIDOI.BUNTERMA 04 72 96 57 7712/03/02 16.32 All, Installed MySQL as part of my setup. Server is running, I can connect as root with no password. I attempt : mysqladmin -u root -p password 'newpassword' I get : Enter password : blahblahblah root@localhost rejected I looked at the user table and there are blank spaces for root both on the machine name and for localhost. Why can I not change the password for root? Any ideas? Regards, Matt 12/03/02 16.32 Envoyé à --- - 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