On 1/24/08, Chris <[EMAIL PROTECTED]> wrote:
>
> mysql mysql wrote:
> > Thanks for the response Chris, although I can't seem to reproduce the
> > problem now, but I'm sure you're right.
> >
> > There's something else strange that I've e
Thanks for the response Chris, although I can't seem to reproduce the
problem now, but I'm sure you're right.
There's something else strange that I've encountered while trying to
optimize this query. I've got two machines, dev and production. After
adding the index to the title attribute on the d
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4) drop index
5) execute same
Hi All,
I have newly installed mysql 3.23.54 in Red Hat 9 (The one which was bundled with the
OS). And default the data storage file location went to /var/lib/mysql, how do I
change the location to /mysql, I have also tried modifying my.cnf it didn't help.
Any suggestion.
-mysql
-
Hi,
I am new to mysql. I have installed, created a database and also some created tables.
Now any one who can login to the host are able to drop the table or also the database.
How do I protect it?
-mysql
-
Do you Yahoo!?
New Yahoo! Photos - easier uploading
Hi,
I have a file which has Creation of tables and views.
How can I run the file in mysql prompt.
-mysql
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
--
MySQL General Mailing List
For list archives: http://lists.my
Just installed mssql and in the end of the installation I receive the
message taht now is the time to change root password for the db using
mysqladmin using the following synthax:
/usr/bin/mysqladmin -u root -p password 'new password'
So issued the following command:
/usr/bin/mysqladmin -u root -p