Hello everyone. I've got a MySQL server that behaves
wonderfully...most of the time. It has crashed three times this week
and I'm at a loss for why.
Below I've included all the following:
error.log
os info
memory check
results from resolve_stack_dump
my.cnf
Does the information point to
On Fri, 10 Sep 2004 05:54:42 +1000, Matthew Boulter <[EMAIL PROTECTED]> wrote:
> Any help with the values I should be using or any guidance on
> estimating a Queries Performance would be unimaginably appreciated.
This is an area in which I felt better armed when I used Oracle. I'm
curious to see
On Tue, 7 Sep 2004 15:13:25 -0700, Allen Weeks <[EMAIL PROTECTED]> wrote:
> Is this a valid query
>Update Atable set Afield = concat(Afield, "\n", "Some Text") where KeyField
> = 'keydata'
Hi Allen,
I notice that you're using both single- and double-quotes. I'm in the
habit of using on
On Mon, 6 Sep 2004 19:53:17 -0400, Rhino <[EMAIL PROTECTED]> wrote:
> I just assumed it might work the
> same in MySQL.
That's where I started as well, Rhino. Here is a simplified version
what I did, line for line:
mysql> /* never heard of him, right? */
-> SHOW GRANTS FOR 'jdoe'@'192.168.%';
> Sure, simply write two grants:
>
> GRANT SELECT, INSERT, UPDATE
> ON test.* TO 'jdoe'@'192.168.%' WITH GRANT OPTION;
>
> GRANT DELETE
> ON test.* TO 'jdoe'@'192.168.%';
>
> Rhino
Thanks, Rhino...but the only difference between what you suggest and
what I did seems to be where the linefeed app
I would prefer that 'jdoe'@'192.168.%' not be able to grant DELETE to
other users...but I do want him to be able to grant SELECT. Is that
possible?
- - - - - - - - - - - - - - - - - - - -
GRANT SHOW DATABASES ON *.* TO 'jdoe'@'192.168.%' IDENTIFIED BY 'uhoh';
GRANT SELECT, INSERT, UPDATE
ON test.
Thank you both.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Should I care that USAGE still shows up after all rights have been
revoked? It feels like a potential security hole...
-- working around the system to ensure a clean environment
-- i feel like i shouldn't have to do this...but want to start with a
clean slate
DELETE FROM mysql.user WHERE user =
Try specifying the source tables more explicitly in your SELECT statement.
SELECT table_a.VendorJobs opt_a
, table_b.VendorJobs opt_b
...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]