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:36, CyberCub wrote: > 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 > restore it and re-add the usernames/passes and priv's. Any suggestions are > welcomed. Thanks Bill > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
