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 77 12/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