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/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org

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/myodbc?unsub=jbalint [at] mysql.com

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.ht ml

Hope this helps.
Jess


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org