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

["Anthony Carmody" <carmoda@xxxxxxxxxx>]

Hi,

i gotta BIG problem with my 'root' account permissions in MySQL.

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.

i can connect to the client ok :

mysql -u root
Welcome to the MySQL monitor.  ...
mysql>

But if i try to connect to the mysql table:

mysql -u root mysql
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

or:

mysqladmin flush-privileges
mysqladmin: reload failed; error: 'Access denied for user: '@localhost'
(Using password: NO)'

is there a hack to reset the users table?

I am not game to shut anything down in case it wont start again!