Re: Lost password
Jess Balint <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
On Tue, Oct 31, 2006 at 03:28:15PM -0500, Souza Simbota wrote: > while working on giving MYSQL access for remote users i have messed up my > MYSQL root password. How can i resset it back? > > ________________________________________________ > Message sent using UebiMiau 2.7.9 > > > > -- > MySQL ODBC Mailing List > For list archives: http://lists.mysql.com/myodbc > To unsubscribe: http://lists.mysql.com/[email protected] Souza - You can start your MySQL server with the --skip-grant-tables option. Then you have free root access and can update your password. Don't forget to restart the server without the --skip-grant-tables option when you have fix it. Details about --skip-grant-tables can be found here: http://dev.mysql.com/doc/refman/5.0/en/privileges-options.html Hope this helps. Jess -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]