Re: reverting to passwd-less root w/out --skip-grant-tables

Log in as root and run: set password = ''; OR update mysql.user set Password='' where User='root'; this is TOTALLY INSECURE but if that's what you want, then it should do the trick. Regards, Darren Cassar www.mysqlpreacher.com www.securich.com On Wed, Aug 26, 2009 at 2:33 AM, Joe

Re: recovery help needed

I actually get the feeling you are not connecting as root. Try mysql -uroot -p test instead of just mysql test Have a nice day, - Martijn On Wed, Aug 26, 2009 at 03:02, Joemysql@bluepolka.net wrote: OK, thanks, that got me in.  But upon inspection, the user.host values do not look fouled

Re: Hi Query Optimization steps

Hi! bharani kumar wrote: Then which DB engine is better. Which fruit is better, an apple or a banana? And if X is better, why do farmers still grow Y, and why do people buy it? More serious: Different engines offer different features, as described in the manual. The most obvious

Re: recovery help needed

Step # 1 : Stop mysql service # /etc/init.d/mysql stop Step # 2: Start to MySQL server w/o password: # mysqld_safe --skip-grant-tables Step # 3: Connect to mysql server using mysql client: # mysql -u root Step # 4: Setup new MySQL root user password mysql use mysql; mysql update user set

upgrading from 4.1 to 5.0 trick

Hello All, I'm in the process of upgrading my database from 4.1 to 5.0 on CentOS. I've been testing the mysqlcheck --check-upgrade --auto-repair command, and on one of my MYISAM tables, it's taking forever to upgrade the table. It has about 114 million rows, and I'm guessing it needs to be

Re: Fail to change MySQL data directory on ubuntu

Yes, error 13, permission denied. Check selinux setup. I had this same problem last week on a CentOS machine. I had to change the object type of the new data dir to mysqld-something. I'm on a mobile phone and can't remember the exact cmd. On Tuesday, August 25, 2009, Jia Chen chen.1...@gmail.com

RE: Hi Query Optimization steps

-Original Message- From: joerg.bru...@sun.com [mailto:joerg.bru...@sun.com] Sent: Wednesday, August 26, 2009 5:08 AM To: mysql@lists.mysql.com Cc: bharani kumar Subject: Re: Hi Query Optimization steps Hi! bharani kumar wrote: Then which DB engine is better. Which fruit is

Re: Fail to change MySQL data directory on ubuntu

I'm at work now, this is the cmd I used: chcon -R -u system_u -r object_r -t mysql_db_t /data (my data lives in /data/mysqlXX -- were XX is the server version) On Wed, Aug 26, 2009 at 8:02 AM, Johnny Withers joh...@pixelated.netwrote: Yes, error 13, permission denied. Check selinux setup. I

Re: Fail to change MySQL data directory on ubuntu

Hi Johnny, Thanks you so much! Your command fixed the problem beautifully. Now, MySQL can start successfully. I can create and drop databases without problem. Thanks again. Best, Jia Johnny Withers wrote: I'm at work now, this is the cmd I used: chcon -R -u system_u -r object_r -t

Re: Best practice to disable log bin for mysql_upgrade

According to this page in the MySQL 5.0 Manual: http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html - mysql_upgrade executes the following commands to check and repair tables and to upgrade the system tables: mysqlcheck --all-databases --check-upgrade --auto-repair mysql [fix_priv_tables]

Re: reverting to passwd-less root w/out --skip-grant-tables

Thanks for the tips, all. Looks like we've got it restored via --skip-grant-tables and restoring some missing user rows (which caused me not to be able to see DBs in 'show databases'). I was also confused about being able to load an empty string '' into the non-null mysql.user.password

free ETL tool for files using MySQL

Dear all, Benetl, a free ETL tool for files now using MySQL is out in version 3.0. You can freely download it at : www.benetl.net You can learn more about ETL tools at: http://en.wikipedia.org/wiki/Extract,_transform,_load Thanks for your interest. Regards, -- Benoît Carpentier