I recently had something interesting happen while recovering MySQL admin rights on my server. After forgetting my root mysql password (I use a normal account for all queries) I used my admin book (the newriders mysql book) to down the server and restart mysqld with the --flush-grant-tables option to regain access, this failed several times, I found out that for some reason you only get access while the shell you started mysqld with is running. After opening two telnet windows and running mysqld on one, I was able to access the mysql console without a root password on telnet #2. After resetting the root password and closing the telnet window that mysqld was started from the security runs normally.




