Re: deleted user...lost access to appointment data

2008-10-28 Thread Dr Michael Daly
Hi Thanks for your help everyone I was overwriting the files into the existing database dir. Maybe there was some additional files there that were causing a problem. I just extracted the backed up files into a new database dir within the /var/lib/mysql dir, pointed my database program towards the

Re: deleted user...lost access to appointment data

2008-10-28 Thread Fish Kungfu
Great. Glad to hear you sorted it out. On Tue, Oct 28, 2008 at 9:02 PM, Dr Michael Daly [EMAIL PROTECTED]wrote: Hi Thanks for your help everyone I was overwriting the files into the existing database dir. Maybe there was some additional files there that were causing a problem. I just

deleted user...lost access to appointment data

2008-10-27 Thread Dr Michael Daly
It all started when I deleted one of the users, 'michael', from within a database program -- lo and behold 'michael' disappeared from all groups along with the data. 'michael' was an admin user as was another admin user, but the data belonged to 'michael' I recreated this user but could not see

Re: deleted user...lost access to appointment data

2008-10-27 Thread Fish Kungfu
For some reason when I started reading this, I heard Humphrey Bogart's voice speaking it like the beginning of one of his dark and rainy black white detective movies. ;-) On Mon, Oct 27, 2008 at 10:25 PM, Dr Michael Daly [EMAIL PROTECTED]wrote: It all started when I deleted one of the users,

Re: deleted user...lost access to appointment data

2008-10-27 Thread Rob Wultsch
I sooo hear that now. That is the funniest thing I have heard this month. On Mon, Oct 27, 2008 at 8:36 PM, Fish Kungfu [EMAIL PROTECTED] wrote: For some reason when I started reading this, I heard Humphrey Bogart's voice speaking it like the beginning of one of his dark and rainy black white

Re: deleted user...lost access to appointment data

2008-10-27 Thread Fish Kungfu
I'm not really sure why that might have happened. I was going to suggest looking on the PCBS Forum for assistance too, but I see you've asked them as well. How did you actually delete the user, 'michael'... through MySQL or through a PCBS admin tool? I am not a guru btw, and encourage anyone to

Deleted user

2001-04-23 Thread jessica
I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert

Re: Deleted user

2001-04-23 Thread Ken Menzel
] To: [EMAIL PROTECTED] Sent: Monday, April 23, 2001 10:09 AM Subject: Deleted user I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late

Re: Deleted user

2001-04-23 Thread Samuel
[EMAIL PROTECTED] To: jessica [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, April 23, 2001 4:24 PM Subject: Re: Deleted user From the very fine manual: http://www.mysql.com/documentation/mysql/bychapter/manual_Problems.htm l#Resetting_permissions

Deleted user

2001-04-09 Thread Bob Dushok
I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert

RE: Deleted user

2001-04-09 Thread Mate Visky
I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I immediately used an insert

Re: Deleted user

2001-04-09 Thread René Tegel
01 1:09 PM Subject: Deleted user I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was entering a command and I didn't realize what I entered until it was too late. I entered: delete from user where user='root'; I i

Re: Deleted user

2001-04-09 Thread Gerald Clark
THe manual recommends restarting the server with --skip-grants. Fix your user table, and flush privileges to reload the grant tables. Bob Dushok wrote: I've made a stupid error. While logged in as root I was deleting records from the user table. Someone was talking to me while I was