RE: HELLLLP! Databases No Longer Accessible

2003-12-15 Thread Bob Cohen 
I don't really know exactly what happened.  As luck would have it, I had
a username with all privileges that WOULD connect.  Using that, in
combination with shutting down and restarting MySQL, I reorganized the
user database and now things work.  Thanks.

Bob Cohen
b.p.e.Creative
http://www.bpecreative.com
Design and production services for the web
Put creative minds to work for you


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: HELLLLP! Databases No Longer Accessible

2003-12-15 Thread Victor Medina 
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]

HELLLLP! Databases No Longer Accessible

2003-12-15 Thread Bob Cohen 
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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]