View Single Post
Old 05-14-2004, 11:05 AM   #2 (permalink)
Fallon
Junkie
 
Location: RI
If you accidentally just deleted the user (how'd you accomplish that? Did you delete the user, or the whole user table?) regrant them the permissions.

PHP Code:
grant all <put all the permissions hereon <databasename>.<tablenameTO <user you deleted>@<host where they should be connecting fromIDENTIFIED BY "password"
For myself on my MySQL server, I'd do
PHP Code:
GRANT ALL ON mud.* TO fallon@localhost IDENTIFIED BY "temp123"
Fallon is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37