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
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
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 - 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