I tried to create a password for the root user in a new installation of MySQL by typing % mysql -u root mysql Then typing and update statement like > Update user set password = "somepassword" where user="root"; After doing this I typed because I could still get into mysql without a password % mysqladmin -u root status % mysqladmin -u root reload
I think what I should have done is typed - update user SET password = PASSWORD("somepassword") where user ="root". Now I can't get into mysql at all as root, with the password I set. I get the error message "Access denied for user 'root@localhost' (using password =YES)" I have tried to restart mysql with the --skip-grant-tables option but I still can't get in as root? How do I fix this? Can anyone help? Anya Miretsky Computer Technology Dept. Brooklyn Botanic Garden 1000 Washington Avenue Brooklyn, NY 11225 (718)623-7265 [EMAIL PROTECTED] --------------------------------------------------------------------- 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