mrjcfreak Posted August 10, 2007 Share Posted August 10, 2007 I can't reset the root password for my sql... I'm following the instructions in the manual, so I've restarted the mysql daemon with -init-file=/tmp/yadah ( where yada contains SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass') ) and yet I can't log in to the mysql CLI as root using that new password. Any ideas? I'm running fedora 4, and I've tried both as root and 'mysql' (our user for mysql) Quote Link to comment Share on other sites More sharing options...
effigy Posted August 10, 2007 Share Posted August 10, 2007 Perhaps the user name for root was changed for added security? You could try the alternative method, which is to start MySQL with --skip-grant-tables. Quote Link to comment Share on other sites More sharing options...
mrjcfreak Posted August 10, 2007 Author Share Posted August 10, 2007 Can't do that- I can restart the service with skipped grant tables, but when i try to get in as root, I get "access denied for user root@localhost Quote Link to comment Share on other sites More sharing options...
fenway Posted August 20, 2007 Share Posted August 20, 2007 Can't do that- I can restart the service with skipped grant tables, but when i try to get in as root, I get "access denied for user root@localhost Then you didn't skip the grant tables... it defaults to a blank password. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.