Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Tim Thorburn
Hello, I just downloaded MySQL 5.5.8 (Win64 version) today and installed it on my dev machine. Previously I had MySQL 5.1.51 installed - as I've always felt it was better to uninstall the old before installing the new with Windows, I uninstalled 5.1.51 by doing the following: - As

Re: Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Tim Thorburn
On 12/16/2010 3:42 AM, Tim Thorburn wrote: I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of Workbench (5.2.31a). When I run

Re: Bulk Insertion Performance

2010-12-16 Thread Johan De Meersman
Hmm, interesting. What does this do, exactly ? Can something similar be applied to non-jdbc connections, too ? On Thu, Dec 16, 2010 at 8:34 AM, Feris Thia milis.datab...@phi-integration.com wrote: Hi Mark, On Thu, Dec 16, 2010 at 4:50 AM, Mark Matthews mark.matth...@oracle.com wrote:

Re: Autostart not working for me in 5.5.8 version

2010-12-16 Thread Alejandro Bednarik
You are right. In previous version init script have a default value, now is empty. mysql 5.1..53 - basedir=/usr/local/mysql mysql-5.5.8 - basedir=. Cheers. On Thu, Dec 16, 2010 at 12:42 AM, Yangontha Maung yangontha5...@yahoo.comwrote: Hi, I will answer my own question. I have to

Re: Unable to add users with MySQL 5.5.8 under Windows

2010-12-16 Thread Shawn Green (MySQL)
On 12/16/2010 03:53, Tim Thorburn wrote: On 12/16/2010 3:42 AM, Tim Thorburn wrote: I should mention this is Windows 7 Ultimate 64-bit. After rebooting I installed MySQL 5.5.8 for Win64 using the downloaded MSI file. Once MySQL was installed, I downloaded and installed the current version of

Password Reset

2010-12-16 Thread Gary
database 5708 (20101216) __ The message was checked by ESET Smart Security. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Password Reset

2010-12-16 Thread Alejandro Bednarik
on this would be appriciated. -- Gary __ Information from ESET Smart Security, version of virus signature database 5708 (20101216) __ The message was checked by ESET Smart Security. http://www.eset.com -- MySQL General Mailing List For list archives: http

Re: MySQL Parallel Inserts

2010-12-16 Thread Andy
Shawn/Krishna, Thank you. I will try this. -Andy On Tue, Dec 14, 2010 at 8:13 AM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: Hi Andy, I agree, prefer LOAD DATA INFILE... command for bulk loading. It is 30% faster than normal inserts. Krishna On Tue, Dec 14, 2010 at 8:02

Re: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

2010-12-16 Thread Yves Goergen
On 14.12.2010 20:36 CE(S)T, Alejandro Bednarik wrote: Are you using ubuntu deb's or mysql bin? Do you get that message when the service start? Look init script to see what it does. I get the message when MySQL is started. I've installed the Ubuntu standard package mysql-server-5.1. It has

Access to MySQL

2010-12-16 Thread Jerry Schwartz
I have to move the back-end of an Access application to MySQL, and I’ve run into one issue that I haven’t been able to solve yet. The Access database stores dates as text in a “/mm/dd” format. The problem is that the default value is a formula that generates the current date, formatted

Kill DELETE Query

2010-12-16 Thread Willy Mularto
Hi List, I run a delete query to delete around 1 million rows in innodb table, It's been hours and still unfinish. Is it safe to kill that delete query process while the table is also inserting and updating other rows? Thanks. sangprabv sangpr...@gmail.com

Re: Kill DELETE Query

2010-12-16 Thread Ananda Kumar
If u have used a stored proc to delete the rows, and commting freqently, then the kill will happen faster. If you have just used delete from table_name where condition, then it would take toot much time to rollback all the deleted but not commited rows. Regards anandkl On Fri, Dec 17, 2010 at

Re: Kill DELETE Query

2010-12-16 Thread Willy Mularto
Thanks for the reply. I used non stored procedure approach. Another question is if I kill the process will it crash the table? Thanks. sangprabv sangpr...@gmail.com http://www.petitiononline.com/froyo/ On Dec 17, 2010, at 12:06 PM, Ananda Kumar wrote: If u have used a stored proc to delete

Re: Kill DELETE Query

2010-12-16 Thread Ananda Kumar
No...it will not. On Fri, Dec 17, 2010 at 11:26 AM, Willy Mularto sangpr...@gmail.com wrote: Thanks for the reply. I used non stored procedure approach. Another question is if I kill the process will it crash the table? Thanks. sangprabv sangpr...@gmail.com