Re: mysqldump and the dreaded lost root password dilemma

2004-09-18 Thread Mitch Pirtle
Thanks Brent, your solution is the one that worked for me. In 4.0.20 there was no 'Super_priv' column however. ? On Fri, 17 Sep 2004 15:20:43 -0400, Brent Baisley <[EMAIL PROTECTED]> wrote: > There probably is a "root" user, but it's not called root. You can name > the "root" user whatever you

mysqldump and the dreaded lost root password dilemma

2004-09-17 Thread Mitch Pirtle
Hi list, First question - I have a machine that was being managed by Plesk, and an update to mod_python left Plesk in a nonrunning state (actually causes apache to segfault). So I am attempting to manually manage MySQL (the way it should be done!) - but there is apparently no root user in MySQL's

Re: Secure Database Systems

2004-07-09 Thread Mitch Pirtle
Rory McKinley wrote: Hi Sarah This is more of a PHP question than a MySQL question as to my mind while it is all possible, the bulk of the work would need to be done on the PHP side. Assuming that you don't have the time to write all the necessary code from scratch, you might want to look for a

More semaphore mystery

2004-07-06 Thread Mitch Pirtle
Hi gang, Back in the throes of semaphores that refuse to play nice with all the other kids on the playground ;-) I'm getting the following in my error file: -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation count 79461482, signal count 75199550 --Thread 23744585 has waited at btr0c

Re: InnoDB and long semaphore waits

2004-07-05 Thread Mitch Pirtle
Heikki Tuuri wrote: Not sure you want that, the file is 44MB uncompressed, and only talks about the errors reading communication packets. Makes for some really boring reading ;) The InnoDB error I managed to figure out - I once upped max_connections without doing the math, and the machine was ex

Re: InnoDB and long semaphore waits

2004-07-05 Thread Mitch Pirtle
seconds... The machines are connected with gigabit ethernet, and have been running without trouble for at least three months - and now are filling up the error logs. Any ideas, anybody? Bueller? -- Mitch Best regards, Heikki - Original Message - From: "Mitch Pirtle" <[EM

InnoDB and long semaphore waits

2004-07-03 Thread Mitch Pirtle
Hi listers, I just got here, so please let me know if this is not the appropriate list! :) Running MySQL 4.0.20 on Fedora Core 1, with InnoDB tables. Installed from RPMs provided at MySQL.com. Last night the beastie came down hard, and requred a physical reboot in order to free/kill some mys