At 8:19 AM -0700 12/10/01, Chris Bolt wrote: > > Our brand new, fresh install of 3.23.46 won't let us set the >> password for the root user because one seems to already be set. >> Even after wiping the ...mysql/data/mysql directory clean and >> rerunning mysql_install_db, we still get an "Enter password:" >> prompt when attempting to set the root user password for the first time. > >mysqladmin does not prompt for a password if it needs it, you must give it >the -p option to make it prompt for a password. If it really needed a >password: > >$ mysqladmin -u root variables > >would show an access denied error
It was showing such an error. I think the daemon had gotten "stuck". Rebooting the server fixed the problem (I've yet to be able to find the daemon's PID so I can't kill it.) Once I did that, I left off the '-p' when initially setting the password and am now in business. Many thanks, -Kurt -- I haven't failed, I've found 10,000 ways that don't work. -- Benjamin Franklin --------------------------------------------------------------------- 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
