Re: [cobalt-users] 'root' account permissions in MySQL

[Bruce Timberlake <bruce@xxxxxxxxxx>]

> while attemting to get an ODBC connection happening, i changed root to
> be able to connect from any host [not just localhost]
> i think that i may have f**ked something up as root cannot connect to
> the 'users' table it appears.

> is there a hack to reset the users table?

Restart mysql with the --skip-grant-tables option and you'll go right in as 
the root user.  Reset the password, then restart MySQL "normally" again to 
re-enable password checking.

Read docs at www.mysql.com for more info and syntax of the command.