Hi Van,
If you don't give drop privileges how can the user drop tables? Is
there a way to give just drop table privileges, because 'drop' will
let you drop tables and the database? If so I missed it and would be
very happy to know how to do this, as I would feel a little better
about that as w
In the last episode (Aug 29), Gary Huntress said:
> I've grepped my log for clues. It only goes back a few days as I
> truncate it at about a GB.
Have your mysql logs rotated by your favorite logfile rotater, and make
sure your nightly backup routine grabs them. That way you have logs as
f
On Wed, Aug 29, 2001 at 11:39:22PM -0400, Gary Huntress wrote:
>
> I run a mysql host that currently has about 5500 seperate mysql
> databases. Yesterday one of my users reported to me that he couldn't
> connect. I suspected many of the usual culprits (grants, network, wrong
> [snip]
> rul
Gary Huntress wrote:
>
> Hi,
>
> I run a mysql host that currently has about 5500 seperate mysql
> databases. Yesterday one of my users reported to me that he couldn't
> connect. I suspected many of the usual culprits (grants, network, wrong
> password etc) but I eventually came to find t
