Re: Deleted all users from MYSQL. What to do now?

2003-12-22 Thread Johannes Franken
* Mike S [EMAIL PROTECTED] [2003-12-21 23:13 +0100]: By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Restart mysqld with the --skip-grant-tables option. Then you can log in again and fix your user table. For details,

Deleted all users from MYSQL. What to do now?

2003-12-21 Thread Mike S
By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Thanks _ Grab our best dial-up Internet access offer: 6 months @$9.95/month.

Re: Deleted all users from MYSQL. What to do now?

2003-12-21 Thread daniel
If it includes root, you will need to run the mysql_install_db script again then set a pass with mysqladmin By mistake I deleted all users in MYSQL. So, how can I login to the mysql? Is it possible to add a user to my.cnf file? Thanks