Hi,
Start the mysqld with --skip-grant-tables. This way the server will not
use the privilege tables... Then alter the data as you want and do a
mysqladmin flush-privileges (or reload) to restart using them.
More info:
http://www.mysql.com/doc/en/Privileges_options.html
On Fri, 2003-01-17 at 03:
I have managed using the phpmyadmin for editing the root user to allow
another host to connect (home ip), what ever it did it messed it up, root no
longer aloud to connect to the mysql database at all. Any way to fix this?
Before I go and delete the user.MDY file and re-run the mysql_install_db to