help~ newb learns mysql

2004-02-26 Thread Vincent
all my mistake I deleted mysql.user this tablewhat can I do to recover this ? Plz help~ Best regards, Vincent fung -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help~ newb learns mysql

2004-02-26 Thread Jochem van Dieten
Vincent wrote: all my mistake I deleted mysql.user this tablewhat can I do to recover this ? Restore from backup. Jochem -- I don't get it immigrants don't work and steal our jobs - Loesje -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:ht

RE: help~ newb learns mysql

2004-02-26 Thread J.R. Bullington
You can also rerun the scripts/mysql_install_db This will reinstall the mysql.hosts form and allow you to reconnect to your server. J.R. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help~ newb learns mysql

2004-02-26 Thread Sasha Pachev
Jochem van Dieten wrote: Vincent wrote: all my mistake I deleted mysql.user this tablewhat can I do to recover this ? Restore from backup. If there is no backup, mysql_install_db will re-recreate the default install version - just make sure to remove all mysql/user.* files from the datadir