Re: Deleted Root Account

2007-05-05 Thread B. Keith Murphy
I have had exactly the kind of trouble you are talking about. Sorry I didn't see the messages until just now. Had to manually remove crap too even though I purged (rpms - centos I think). Hopefully this will help others down the road. Keith John Kebbel wrote: Even though I complet

Re: Deleted Root Account

2007-05-05 Thread John Kebbel
Even though I completely removed everything I could find related to MySQL in Synaptic Package Manager, a folder still remained at /var/lib/mysql/ containing all my old table information. If that info hung around, it seemes logical to assume the Grants table were still somewhere interfering

Re: Deleted Root Account

2007-05-05 Thread John Kebbel
The Synaptic checkbox menu has a Mark for Removal and Mark for Complete Removal. Complete Removal seems to be same as Purge; when I look at details, it says the configuration files are being removed. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Deleted Root Account

2007-05-05 Thread Peter Teunissen
On 6-mei-2007, at 0:37, John Kebbel wrote: Fortunately, I'm learning MySQL on my home machine, so this MEGA-Mistake doesn't sink a Fortune 500 corporation. I was experimenting with a batch file that ... (1) Created a set of user accounts with tiered privileges, (2) Set password

Deleted Root Account

2007-05-05 Thread John Kebbel
Fortunately, I'm learning MySQL on my home machine, so this MEGA-Mistake doesn't sink a Fortune 500 corporation. I was experimenting with a batch file that ... (1) Created a set of user accounts with tiered privileges, (2) Set passwords for the new accounts, and then (3) Displaye

Fw: Error message on trying to start service

2007-05-05 Thread J Trahair
Thanks Baron, that hit the spot. Thanks again. Jonathan - Original Message - From: J Trahair To: MySQL General Sent: Saturday, May 05, 2007 9:00 PM Subject: Error message on trying to start service Hi Everyone I had to re-install everything after Norton crashed my hard disk. I re-

Re: Error message on trying to start service

2007-05-05 Thread Baron Schwartz
Hi, J Trahair wrote: Hi Everyone I had to re-install everything after Norton crashed my hard disk. I re-formatted. I am trying to install MySQL using the same installation files and method as before. MySQL installed OK (mysql-5.0.27-win32.zip). The mysql connector ODBC installed OK. Howe

Error message on trying to start service

2007-05-05 Thread J Trahair
Hi Everyone I had to re-install everything after Norton crashed my hard disk. I re-formatted. I am trying to install MySQL using the same installation files and method as before. MySQL installed OK (mysql-5.0.27-win32.zip). The mysql connector ODBC installed OK. However, I cannot complete t

How to limit usage of mysql server's memory/cpu for each databases ?

2007-05-05 Thread Halid Faith
I use mysql4.1.22, php4.4.6 and apache2.0.59. I want to put an quota for each databases and mysql users. How can I do that mysql will limit each database's memory usage? Because some mysql users sometimes use much memory while doing a sql query. Also How can I put an quota for each databases as dat