Thank you Sheeri for answering,
I guess this syntax works for you, but
for me NO, this DO NOT work ( I run MySQL 4.21 , on Linux Debian sarge )
mysql GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
ERROR 1221 (HY000): Incorrect usage of DB GRANT and GLOBAL PRIVILEGES
the
Well this is exactly the problem. The OR statement. Do you think there
is
another way around the tmp table. I did not make the best experiances
with tmp tables.
regards,
merlin
On Sat, 27 May 2006 00:26:09 -0500, mos [EMAIL PROTECTED] said:
Merlin,
Lose the OR part of the Where clause
Hello,
I've posted this on Gentoo forums, but I'll try here too. :)
I've made upgrade of MySQL to latest 5.0.x version. Now, when I access my
site MySQL CPU usage is about 100%, and site is unaccessible. :( I've
checked SHOW PROCESSLIST and this query take lng time to execute:
SELECT
Hi all,
I have to create a database for Chinese, Japanese and Korean Language
support and a vb.net application for same.
Well I did couple of thing for this
1. created new database with Unicode CharacterSet
2. tables are also created with Unicode
Hi,
thank you for this hint. That worked excellent! Now the overall query
time is about 0.1 s on average.
Best regards,
Merlin
On Sat, 27 May 2006 02:14:34 -0700, Merlin [EMAIL PROTECTED] said:
Well this is exactly the problem. The OR statement. Do you think there
is
another way around the
Hello again,
SELECT shout_avatar, shout_own, timestamp, tekst, imie, pseudo, wiek,
City, Country, plec, wlosy_kol, gra_gwiazdy.id, gra_gm.gid AS gm FROM
gra_shoutbox INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id =
gra_shoutbox.gid) INNER JOIN (swiat_miasta) ON (swiat_miasta.CityId =
Hi,
You can try this option by
grant file on *.* to [EMAIL PROTECTED] identified by 'db123';
Query OK, 0 rows affected (0.03 sec)
For all the Databases.
Gilles MISSONNIER wrote:
Thank you Sheeri for answering,
I guess this syntax works for you, but
for me NO, this DO NOT work ( I run
Gilles MISSONNIER wrote:
Hello
How to set FILE privilege enable to an already defined user ?
It seems that I have to read the all manual for that.
I cannot find an example in the on line manual.
snip
sheeri kritzer wrote:
GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
Dude listen,
You can given file privileges to existing users for all the Db's as
if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED] identified by 'passwd';
Dilipkumar wrote:
Dude listen,
You can given file privileges to existing users for all the Db's as
if you specify as
grant file on database.* to [EMAIL PROTECTED] identified by 'passwd'; [
*Error* ]
If you mention to all the DB for a user as:
grant file on *.* to [EMAIL PROTECTED]
This is a bit embarrassing because I think this should be a simple WHERE
clause, but it escapes me at the moment.
I have a table with data:
module_id
email
score
date_time
1
[EMAIL PROTECTED]
8
5/27/2006 12:07 AM
1
[EMAIL PROTECTED]
9
5/27/2006 12:11 AM
1
[EMAIL PROTECTED]
Sorry about the last post, I hope this one comes over better.
This is a bit embarrassing because I think this should be a simple WHERE
clause, but it escapes me at the moment.
I have a table with data:
module_id email score date_time
1
Hi,
i've noticed similar behaviour as we upgraded to mysql 5.0.
The query optimizer seems to been optimized a little too much :-\
-Original Message-
From: Szymon Kosok [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 27, 2006 5:42 PM
Cc: mysql@lists.mysql.com
Subject: Re: MySQL 5
Brian Menke wrote:
Sorry about the last post, I hope this one comes over better.
This is a bit embarrassing because I think this should be a simple WHERE
clause, but it escapes me at the moment.
I have a table with data:
module_id emailscore date_time
1 [EMAIL PROTECTED] 8
14 matches
Mail list logo