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@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@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@m.gmane.org