Hi,
Check for the user in the 'User' Table of 'mysql' database. If there exists
'gamito' User in the User table, then set password will surely do.
Verify:
mysql>use mysql;
mysql>select * from user;
Thanks
ViSolve DB Team.
- Original Message -
From: "Deckard" <[EMAIL PROTECTED]>
T
>
>
>Thanks for the advice.
>
>We've got 12GB of RAM, I'll increase the key_buffer_size.
Unfortunately
>I can't turn off indexes, then index after. At these rates, I'd never
>catch up.
I don't agree. It takes longer to build the index than to load the data
if
you have indexes active when loadi
Is there a detailed source for when innodb creates row or table locks?
I have a situation where one thread is performing this in one
transaction:
UPDATE SomeTable SET WHERE SomeTable.id = N;
This is invoked after another thread has kicked off this long running
query in another tran
I have the following piece of a schema that includes nested table
relationships where a child has relationships with both parents and
grand-parents where it CASCADES on one side and RESTRICT on the other:
CREATE TABLE `r180_topic_cd` (
`topic_cd_id` mediumint(9) NOT NULL,
`cd_name` varcha
Asif, there's some information here:
http://dev.mysql.com/doc/refman/5.0/en/join.html
It can be a handy tool when you just can't MySQL to make the right
decision (rare) - but it will also result in an error if the index is
later dropped or the name changed.
Dan
On 10/2/06, Asif Lodhi <[EMAIL P
Hi,
I remember USE_INDEX optimization hint in Oracle and I have seen
something like this on this list as well but I can't seem to look it
up in the online documentation or the mysql manual sitting on my hard
disk. Can anybody give me pointers as to where I can get
documentation on this function/
