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
Merlin,
Lose the "OR" part of the Where clause and it should speed up. If so,
that's what you have to work on. You could execute 2 queries, where each
one writes the results to a temporary memory table and display that table
instead.
Mike
--
MySQL General Mailing List
For list archives: ht
Hi there,
I am using mysql 4.0.18 and do want to do the following:
There is one table with classifieds that contains the title and the
text. Another one contains tags associated with the classifieds. Each
classified row can have multiple tags inside the tag table. The tag
table contains the ad_id
GRANT FILE ON dr4.* to 'wr'@'localhost' IDENTIFIED BY 'the_passwd';
It won't set up a new account, just add the privilege for you.
-Sheeri
On 5/26/06, Gilles MISSONNIER <[EMAIL PROTECTED]> wrote:
Hello
How to set "FILE privilege enable" to an already defined user ?
It seems that I have to re
Brian,
The scenario you list, that a person on the east coast and a person on
the west coast will submit tests in 3 hours apart yet show up in the
db as having been done at the same time, will not happen.
No matter what timestamp you use on the server, UTC or otherwise, it's
going to insert the
The source build of 5.0.18, on linux, when using --without-server,
leaves out the following 3 headers that are installed when
--without-server is not given:
> include/mysql/mysqld_ername.h
> include/mysql/mysqld_error.h
> include/mysql/sql_state.h
Is this intentional? This breaks the python MySQ
Never mind. This actually posted to the wrong list. I don't know
how that happened. Must have been cause I was tired. Sorry about that.
On May 24, 2006, at 9:19 PM, sheeri kritzer wrote:
Rich
for what? is
SELECT host,user,password FROM mysql.user;
showing you cleartext passwords?
On Wednesday 24 May 2006 15:18, Brian Menke scribble on about:
> Peter, thanks for the detailed info. I will figure out how to get rid of
> the UNIQUE key. Somehow that got added. Thanks for the catch. As far as INT
> for student id goes, I'm using email because it will be unique, and offers
> an e
On Wednesday 24 May 2006 15:18, Brian Menke scribble on about:
> Peter, thanks for the detailed info. I will figure out how to get rid of
> the UNIQUE key. Somehow that got added. Thanks for the catch. As far as INT
> for student id goes, I'm using email because it will be unique, and offers
> an e
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.
thanks.
- Gilles -
-
I will end up running mysql as root.
1-I
Hi all
I have a table with following structure
CREATE TABLE `dsc` (
`ch_code` varchar(255) default NULL,
`name` varchar(255) default NULL,
`inof` blob
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
And I have give a text file with following format
Ü
¢
Ch.Code :02Ü
MEATÜ
Hi all,
I have downloaded and installed the myodbc3 driver for MacOSX onto my
Panther machine (10.3.9). First surprise, the MySQL graphical installer
doesn't seem to appear in the Applications folder, has it been dropped ?
Secondly, although I have manage to configure ODBCAdministrator, the
datas
Hi all. I have some InooDB mysql crush logs, can somebody explain what
they mean?
Quote:
060525 18:09:43 InnoDB: Error: trying to declare trx to enter InnoDB, but
InnoDB: it already is declared.
TRANSACTION 0 550042370, ACTIVE 0 sec, process no 27054, OS thread id 163851,
thread declared insid
Ville Mattila wrote:
I try to get a list of all Invoices with total sum of the invoice and
paid sum of each invoices, as well as a customer name. I try following
query:
SELECT Invoices.*, SUM(InvoiceContents.Amount * InvoiceContents.Price)
AS InvoiceTotal, Customers.Name, SUM(Payments.Amount) Pa
Scott Haneda wrote:
4.0.18-standard-log
I have a very basic one to many relationship, accounts and transactions.
There is only one account per users, but of course, there can be x
transactions. These are once a month charges for billing.
I need to be able to select all accounts where next_cha
Andras Pal wrote:
Hi,
I've a large table with lots of floats (or doubles) that i want to query
using C API. By default, in C, the rows are returned as a type of char **,
therefore floating numbers are returned as ascii strings. Is it possible
to fetch somehow directly these numbers in their ori
Ville,
>SELECT Invoices.*, SUM(InvoiceContents.Amount * InvoiceContents.Price)
>AS InvoiceTotal, Customers.Name, SUM(Payments.Amount) PaidTotal,
>MAX(Payments.Date) LastPayment FROM Invoices LEFT JOIN InvoiceContents
>ON (InvoiceContents.InvoiceID = Invoices.ID) LEFT JOIN Customers ON
>(Customers
Hello all,
I'm sure that this situation is one of the most wondered questions with
JOIN clauses. Anyway, I couldn't find any clear information how to carry
out multiple joins in one query with proper results.
I have four tables:
1. Invoices
2. InvoiceContents
3. Customers
4. Payments
I try to ge
Thanks, but this not work to
(output with --debug)
$VAR1 = [];
No tables to hot-copy at /usr/local/bin/mysqlhotcopy line 390.
/usr/local/bin/mysqlhotcopy Ver 1.22
mysql-4.1.16
perl, v5.8.5 built for i586-linux-thread-multi
Linux camel 2.6.8-24.16-default
> You should just be doing
>
> mysqlhotcop
19 matches
Mail list logo