This may sound crazy, and maybe paul would kill me but try this :) 1.- backup your data base files, just for moment, while we recover the users data base 2.- erase your data base file completly 3.- run mysql_install_db 4.- restore your data bases, only _YOUR_ data bases, do not restore mysql internal data bases 5.- recreate your users using the normal procedure
it seems you delete ALL mysql users, this will give you a fresh restart, lossing users, but not data Hope this works! On Mon, 2003-12-15 at 15:06, Bob Cohen wrote: > I seem to be locked out. The trouble started when I deleted the "Any" > user while in phpMyAdmin. After doing that, I reloaded MySQL. > > MySQL seems to load from the command line using the command mysqld_safe, > except the command prompt doesn't return unless I hit control Z. Once I > ^Z myself back to the command line, I can access MySQL via only one > username. And when I exit as root, the stopped jobs message appears. > When I exit all the way, MySQL unloads and the Web sites become > inaccessible. I tried following the procedures Paul DuBois' book MYSQL, > including bypassing the GRANT tables. I know I must be missing > something basic. Help would be appreciated! > > Bob Cohen > b.p.e.Creative > http://www.bpecreative.com > Design and production services for the web > Put creative minds to work for you -- ...................................................................... * _ _ ______ _____ _ .. * \ \ \ | ____| __ \ /\ | | || Victor E Medina M * \ \ \ | |__ | |__) / \ | | || Linux - Java - MySQL * > > > | __| | ___/ /\ \ | | || Dpto. Sistemas - Ferreteria EPA * / / / | |____| | / ____ \|_| || www.superferreteria.com.ve * /_/_/ |______|_| /_/ \_(_) || [EMAIL PROTECTED] * || geek by nature - linux by choice ...................................................................... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
