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) Link to comment https://forums.phpfreaks.com/topic/64271-cant-reset-root-password-no-root-user/ 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. Link to comment https://forums.phpfreaks.com/topic/64271-cant-reset-root-password-no-root-user/#findComment-320465 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 Link to comment https://forums.phpfreaks.com/topic/64271-cant-reset-root-password-no-root-user/#findComment-320679 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. Link to comment https://forums.phpfreaks.com/topic/64271-cant-reset-root-password-no-root-user/#findComment-329179 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.