Aug 17, 2011 #1 busster Technical User Dec 13, 2004 959 US Someone else did the original mysql installation. I have access to phpmyadmin and can see the encrypted root password. Is there a way to resolve / change / recover this password?
Someone else did the original mysql installation. I have access to phpmyadmin and can see the encrypted root password. Is there a way to resolve / change / recover this password?
Aug 17, 2011 Thread starter #2 busster Technical User Dec 13, 2004 959 US When I look at phpmyadmin, the password says: Collation = latin1_bin On another mysql database, the password Collation = utf8_bin Upvote 0 Downvote
When I look at phpmyadmin, the password says: Collation = latin1_bin On another mysql database, the password Collation = utf8_bin
Aug 17, 2011 #3 lgarner IS-IT--Management Jan 26, 2002 2,348 US Restart the server with --skip-grant-tables, then you can change the password and restart the server normally. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-generic Upvote 0 Downvote
Restart the server with --skip-grant-tables, then you can change the password and restart the server normally. http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-generic
Aug 18, 2011 #4 rzs0502 IS-IT--Management Nov 18, 2002 708 http://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html "If you always do what you've always done, you will always be where you've always been." Upvote 0 Downvote
http://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html "If you always do what you've always done, you will always be where you've always been."