Re: How to change root password?

On Sun, 15 Nov 2009 20:13:38 -0800, Michael Wilson wrote: > I am running MySQL 5 on OS X Snow Leopard... > > Have it set up (by installing the pref pane) to always be running as soon > as my MacBook starts. > > For some odd reason, I can't remember the password I issued for "root" > user and wis

Re: mysql Create table in system database

Thanks Shawn for the quick response. But then What I am doing is I am doing copy paste of one database and rename it to another. but I cannot read the tables inside it. Can you tell me what might be the possible reason for that. -- Thanks and Regards, Manasi Save Artificial Machines Pvt Ltd. >

Re: How to change root password?

Michael Wilson írta: I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for "root" user and wish to either change it back to blank or a new spe

How to change root password?

I am running MySQL 5 on OS X Snow Leopard... Have it set up (by installing the pref pane) to always be running as soon as my MacBook starts. For some odd reason, I can't remember the password I issued for "root" user and wish to either change it back to blank or a new specific password. What s

RE: Selecting data from multiple tables

These table names are extraordinarily confusing; especially since your schema is de-normalized. One of these tables should have (user_id int unsigned not null auto increment primary key, username varchar(100) ); All the rest should be using user_id. Anyway, to answer your first question: sel

Re: log sql queries?

Ah! Thanks - I see. 5.1.39 Actually I did look i the manual, but failed to note the differences between < 5.1.29 and > 5.1.29 I was using the syntax for < 5.1.29. Now I am using the correct syntax in /etc/my.cnf $ grep general /etc/my.cnf general_log=1 general_log_file=/var/log/mysql/mysql.l

Selecting data from multiple tables

Hi folks, I'm trying to, possibly do the impossible here. I have to select data from 4 different tables to come up with the right information and I'm having one heck of time trying to figure it out. This is going to be a long email ... Table_1: +---+--+--+---

Re: OPTIMIZE TABLE

Not an expert, but: 2009/11/14 Krishna Chandra Prajapati : > I would like to know how optimize table work internally. A table contains > 200 millions records. Whether query performance will be faster after > deletion of 30 million records from this table or not. Use of OPTIMIZE TABLE varies from