MySQL Cluster 7.1.33 has been released

2014-10-21 Thread sunanda menon
Dear MySQL users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - Real-time performance based on in-memory storage (with checkpointing to disk) - Read & write scalability through transparent auto-sharding - 99.999%

FOSDEM 2015 MySQL & Firends Devroom CfP is open !

2014-10-14 Thread Frederic Descamps
Hi all, I'm pleased to announce the call for participation for the FOSDEM 2015 MySQL & Friends devroom. Every year we beat the attendees expectation ! Like every year, FOSDEM takes place the first week-end of February in Brussels. MySQL & Friends devroom is scheduled back o

ANN: DAC for MySQL 2.10.1 is out!

2014-10-01 Thread Aleksander Andreev
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll

MySQL Connector/NET 6.9.4 has been released

2014-09-26 Thread karen langford
Dear MySQL users, MySQL Connector/Net 6.9.4 is a maintenance release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments. It is appropriate for use with MySQL server versions 5.5-5.7. It is now available in source and binary form from http

MySQL Utilities 1.5.2 has been released

2014-09-26 Thread Hery Ramilison
Dear MySQL users, This is the GA release for Utilities 1.5. MySQL Utilities version 1.5.2 is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. In addition to server utilities, MySQL Utilities also contains MySQL Fabric: a framework for managing a

MySQL Cluster 7.4.1 has been released

2014-09-26 Thread Hery Ramilison
Dear MySQL users, MySQL Cluster 7.4.1 (Milestone Release) is the first public milestone release for MySQL Cluster 7.4. The MySQL Cluster 7.4.1 DMR can be downloaded from the “Development Releases” tab at http://dev.mysql.com/downloads/cluster/ where you will also find Quick Start guides to

MySQL Community Server 5.7.5 has been released (part 3/3)

2014-09-25 Thread Bjorn Munch
st in detecting invalid certificates. (Bug #18384260) * The HAVE_IB_LINUX_FUTEX CMake check failed due to a missing include file. (Bug #18353271) * After a code reorganization in MySQL 5.7.4, ORDER BY for multiple-table UPDATE statements was ignored. (Bug #18352

MySQL Community Server 5.7.4 has been released (part 3/3)

2014-09-25 Thread Bjorn Munch
st in detecting invalid certificates. (Bug #18384260) * The HAVE_IB_LINUX_FUTEX CMake check failed due to a missing include file. (Bug #18353271) * After a code reorganization in MySQL 5.7.4, ORDER BY for multiple-table UPDATE statements was ignored. (Bug #18352

MySQL Community Server 5.7.5 has been released (part 2/3)

2014-09-25 Thread Bjorn Munch
ingle DROP TABLE statement causes the MySQL server to divide the original statement into three separate DROP TABLE statements in the binary log. If GTIDs are enabled but the value of gtid_next is not AUTOMATIC, issuing a DROP TABLE statement that mixes any of the t

MySQL Community Server 5.7.5 has been released (part 1/3)

2014-09-25 Thread Bjorn Munch
Dear MySQL users, MySQL Server 5.7.5 (Milestone Release) is a new version of the world's most popular open source database. This is the fifth public milestone release of MySQL 5.7. [Due to length restrictions, this announcement is split into three parts. This is part 1.]

MySQL Connector/Python 2.0.1 GA has been released

2014-09-25 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/Python 2.0.1 GA is the first GA version of 2.0 release series of the pure Python database driver for MySQL. It can be used for production environments. MySQL Connector/Python version 2.0.1 is compatible with MySQL Server versions 5.5 and greater. Python 2.6 and

MySQL for Excel 1.3.2 GA has been released

2014-09-23 Thread Hery Ramilison
Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.2. This is a GA release for 1.3.x. It can be used for production environments. MySQL for Excel is an application plug-in enabling data analysts to very easily access and

MySQL Notifier 1.1.6 has been released

2014-09-22 Thread karen langford
Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.6, the latest addition to the MySQL Installer for Windows. MySQL Notifier enables developers and DBAs to easily monitor, start and stop all their MySQL database instances. It

DAC for MySQL 2.10.0 with support RAD Studio XE7 is out!

2014-09-22 Thread Aleksander Andreev
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll

Re: When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread shawn l.green
Hello ccleve, On 9/19/2014 3:06 PM, ccleve wrote: I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? You appear to be looking for one of these com

When will MySQL support the ANSI SQL MERGE command?

2014-09-19 Thread ccleve
I need to do upserts and I need cross-database compatibility. I'd hate to drop support for MySQL in my product. Does MySQL plan to support the ANSI-standard MERGE command for upserts? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: MySQL 5.5.33 History list not purging?

2014-09-11 Thread Brad Heller
So I've done some more digging on this. 1. Upgraded to MySQL 5.5.37 2. Made sure we didn't have any old/long running transactions--nothing more than a few seconds. 3. Did a dump/reload in to a new DB and started with an empty history list. A few days later, we're ba

MySQL Workbench 6.2.2 RC has been released

2014-09-08 Thread karen langford
Dear MySQL Users, The MySQL developer tools team announces 6.2.2 RC - the final release candidate for MySQL Workbench 6.2. MySQL Workbench 6.2 is the upcoming major update for the official MySQL graphical development tool . MySQL Workbench 6.2 focuses on support for innovations released in

RE: Query on some MySQL-internals

2014-09-07 Thread Martin Gainty
__ > Date: Sun, 7 Sep 2014 23:06:09 +0530 > Subject: Re: Query on some MySQL-internals > From: ajaygargn...@gmail.com > To: mgai...@hotmail.com > CC: mysql@lists.mysql.com > > Hi Martin. > > Thanks for the reply. > &

Re: Query on some MySQL-internals

2014-09-07 Thread Ajay Garg
sh_ci Checksum: NULL Create_options: partitioned Comment: 1 row in set (0.24 sec) Thanks and Regards, Ajay On Sat, Sep 6, 2014 at 8:06 PM, Martin Gainty wrote: > > > > >> Date: Sat, 6 Sep 2014 14:26:22 +0530 >> Subject: Query on some MySQL-int

RE: MySQL 5.5.33 History list not purging?

2014-09-07 Thread Jesper Wisborg Krogh
Hi Brad, > -Original Message- > From: Brad Heller [mailto:b...@cloudability.com] > Sent: Sunday, 7 September 2014 03:07 > To: MySQL General List > Subject: MySQL 5.5.33 History list not purging? > > For some reason, the history list isn't purging on one of my

Re: MySQL 5.5.33 History list not purging?

2014-09-06 Thread Brad Heller
Good point. We'll try that out. I noticed our ibdata file is gigantic now, likely due to the alter table migration we ran. What's the relationship here, do you think? *Brad Heller *| Director of Engineering | Cloudability.com | 541-231-1514 | Skype: brad.heller | @bradhe

Re: MySQL 5.5.33 History list not purging?

2014-09-06 Thread Reindl Harald
Am 06.09.2014 um 19:07 schrieb Brad Heller: > For some reason, the history list isn't purging on one of my masters. This > is causing all kinds of weird issues/behavior with reads so why do you not just try to update first? 5.5.39 is recent and contains *a lot* of bufixes look at the changelogs

MySQL 5.5.33 History list not purging?

2014-09-06 Thread Brad Heller
For some reason, the history list isn't purging on one of my masters. This is causing all kinds of weird issues/behavior with reads. Here's the last 8 or so hours of history list length: http://i.imgur.com/Q4DEeVi.png Here are my innodb%purge% settings. mysql> show variables where

RE: Query on some MySQL-internals

2014-09-06 Thread Martin Gainty
> Date: Sat, 6 Sep 2014 14:26:22 +0530 > Subject: Query on some MySQL-internals > From: ajaygargn...@gmail.com > To: mysql@lists.mysql.com > > Hi all. > > > We are facing a very strange scenario. > > We have two mysql-instances running on the same mac

Query on some MySQL-internals

2014-09-06 Thread Ajay Garg
Hi all. We are facing a very strange scenario. We have two mysql-instances running on the same machine, and they had been running functionally fine since about 6 years or so (catering to millions of records per day). However, since last few days, we were experiencing some elongated slowness on

MySQL Proxy 0.8.5 alpha has been released

2014-09-05 Thread Hery Ramilison
Dear MySQL Users, We are pleased to announce MySQL Proxy 0.8.5, an alpha release. All users of MySQL Proxy 0.8.x are recommend to upgrade. Download: http://dev.mysql.com/downloads/mysql-proxy/ Changes in MySQL Proxy 0.8.5 (2014-09-05) Bugs Fixed * A stored function that used cursors

Re: 1045 Error accessing mysql db

2014-09-05 Thread wagnerbianchi.com
FYI WB 2014-09-04 21:27 GMT-03:00 정천기 : > Hi~~ > I think this trouble because change OS and MySQL grant Initialization.. > > Could you please follow my step... > > First.. check your (foo) grant > > root#] mysql -u root -p > mysql > select * from mysql.user where &

Re: 1045 Error accessing mysql db

2014-09-04 Thread wagnerbianchi.com
currently must be checked as well...could you let us now if you can log to MySQL using the mysql client? Something like: $ mysql -u foo -p Let us know, cheers!! -- *Wagner Bianchi, MySQL Database Specialist* Mobile: +55.31.8654.9510 E-mail: m...@wagnerbianchi.com Twitter: @wagnerbianchijr 2014

Re: 1045 Error accessing mysql db

2014-09-04 Thread Divesh Kamra
y Python script > could no longer connect with mysql database. I get the following error... > > mysql_exceptions.OperationalError: (1045, "Access denied for user 'foo'@ > 'localhost > ' (using password: YES)") > > I have granted all on all databases

MySQL Connector/NET 6.9.3 GA has been released

2014-09-03 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/Net 6.9.3 is the first GA release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments. It is appropriate for use with MySQL server versions 5.5-5.7. It is now available in source and binary form from http

ANN: DAC for MySQL 2.9.8 is out!

2014-08-28 Thread Aleksander Andreev
MicroOLAP Direct Access Components for MySQL and Delphi/C++ Builder (also known as MySQLDAC) is a Borland Delphi/C++Builder component set for direct connect to MySQL database server. DAC for MySQL allows you to create Delphi/C++Builder applications without BDE, ODBC, ADO and without libmysql.dll

MySQL Connector/Python v1.2.3 GA has been released

2014-08-22 Thread Sowmya Dass
Dear MySQL users, MySQL Connector/Python v1.2.3 is the new version of the 1.2 release series of the pure Python database driver for MySQL. This is the first GA (General Availability) version of Connector/Python 1.2. MySQL Connector/Python version 1.2.3 is compatible with MySQL Server versions

1045 Error accessing mysql db

2014-08-20 Thread Augori
After an operating system change (CentOS 5 to CentOS 6), my Python script could no longer connect with mysql database. I get the following error... mysql_exceptions.OperationalError: (1045, "Access denied for user 'foo'@ 'localhost ' (using password: YES)") I hav

Re: how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread Wybo
o that via phpMysqlAdmin? Yes, you will need to use your phpMysqlAdmin session to issue an appropriate GRANT command so that the 'wybo' user can login from 'wybo.fritz.box'. Example - GRANT on *.* to 'wybo'@'wybo.fritz.box' IDENTIFIED BY 'passwor

Re: how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread shawn l.green
er account management commands) to see what else you can do while creating an account or adjusting permissions. http://dev.mysql.com/doc/refman/5.6/en/account-management-sql.html Examples of the types of host patterns you can use are also in the manual, here: http://dev.mysql.com/doc/refman/5

Re: how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread shawn l.green
Hi Wybo, On 8/20/2014 3:47 PM, Wybo wrote: My Synology station is on 192.168.178.27, the database listens to port 3306, on my FritzBox I forwarded port 3306 to 192.168.178.27, I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/ But when I try: mysql --host=192.168.178.27

how to access Synology's mysql (mariadb) on the command line

2014-08-20 Thread Wybo
My Synology station is on 192.168.178.27, the database listens to port 3306, on my FritzBox I forwarded port 3306 to 192.168.178.27, I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/ But when I try: mysql --host=192.168.178.27 --password=* --user=wybo I get: ERROR 1045

Re: mysql Digest 15 Aug 2014 12:32:06 -0000 Issue 5209

2014-08-18 Thread Bob Eby
pgrade -u root -p mysql > > > More details I'm sure, but just my initial thought. Thanks, Bob On Fri, Aug 15, 2014 at 8:32 AM, wrote: > > mysql Digest 15 Aug 2014 12:32:06 - Issue 5209 > > Topics (messages 230517 through 230517) > > Incorrect Infomatio

MySQL Cluster Manager 1.3.2 has been released

2014-08-15 Thread Hery Ramilison
Dear MySQL users, MySQL Cluster Manager 1.3.2, has been released and can be downloaded from the My Oracle Support (MOS) website. It will also be available on Oracle Software Delivery Cloud at http://edelivery.oracle.com with the September update in a few weeks. MySQL Cluster Manager is an

MySQL Connector/Java 5.1.32 has been released

2014-08-11 Thread Sowmya Dass
Hello all, MySQL Connector/J 5.1.32, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.32 is suitable for use with many MySQL server versions 5.5 and 5.6. MySQL Connector Java is available in source and

MySQL for Visual Studio 1.2.3 GA has been released

2014-08-06 Thread karen langford
Dear MySQL users, MySQL for Visual Studio is a product that includes all of the Visual Studio integration functionality to create and manage MySQL databases when developing .NET applications. The 1.2.3 version is a General Availability release of this product which is feature complete and is

MySQL Community Server 5.6.20 has been released

2014-08-01 Thread karen langford
Dear MySQL users, MySQL Server 5.6.20, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.20 is recommended for use on production systems. For an overview of what's new in MySQL 5.6, please see http://dev.mysql.com/doc/refman/5.6/en/

MySQL Connector/C++ 1.1.4 has been released

2014-07-31 Thread Sowmya Dass
Dear MySQL Users, A new GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.1.4 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server 5.5 or newer. You can download the production release at

MySQL Utilities 1.4.4 GA has been released

2014-07-31 Thread Santosh Pagare
Dear MySQL users, MySQL Utilities version 1.4.4 is compatible with MySQL Server versions 5.5 and greater. Python v2.6 and v2.7 are supported. In addition to server utilities, MySQL Utilities also contains MySQL Fabric: a framework for managing a collection of MySQL servers. MySQL Fabric is

MySQL InnoDB table row access

2014-07-30 Thread Tobias Krüger
Hi, I want to access data from an InnoDB table. I know that I can do this using the corresponding handler and ha_rnd_next() or ha_index_next(). My problem is that the original MySQL code is outperforming my implementation even on simple projection queries, even though I use the same functions

MySQL Connector/Python 2.0.0 Alpha has been released

2014-07-24 Thread Sowmya Dass
Dear MySQL users, MySQL Connector/Python 2.0.0-alpha is the first alpha version of 2.0 release series of the pure Python database driver for MySQL. It is intended to introduce users to the new features. This release is not feature complete but it should be stable enough for users to understand

MySQL Connector/NET 6.9.2 RC has been released

2014-07-18 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/Net 6.9.2 a new version of the all-managed .NET driver for MySQL has been released. This is a RC release for 6.9.x and is not recommended for production environments. It is appropriate for use with MySQL server versions 5.5-5.7. It is now available in source

MySQL Connector/ODBC 5.3.4 has been released

2014-07-18 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.4, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select the driver type you need based on

MySQL Cluster 7.1.32 has been released

2014-07-15 Thread Hery Ramilison
Dear MySQL users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - Real-time performance based on in-memory storage (with checkpointing to disk) - Read & write scalability through transparent auto-sharding - 99.999%

MySQL for Visual Studio 1.2.2 RC has been released

2014-07-15 Thread Hery Ramilison
Dear MySQL users, MySQL for Visual Studio is a product including all of the Visual Studio integration. The 1.2.2 version is a release candidate release of this product which is feature complete but still can contain minor bugs and is not suitable for production environments. This version is

MySQL Cluster 7.3.6 has been released

2014-07-12 Thread Sowmya Dass
Dear MySQL users, MySQL Cluster is the distributed, shared-nothing variant of MySQL. This storage engine provides: - Real-time performance based on in-memory storage (with checkpointing to disk) - Read & write scalability through transparent auto-sharding - 99.999%

Cannot build static mysql server

2014-07-12 Thread Mimiko
I try to cpmpile mysql-with no shared, but have an error when configuring: mkdir -p ~/src/mysql/bld && \ cd ~/src/mysql/bld && \ (make clean; rm ~/src/mysql/bld/CMakeCache.txt; echo 1) && \ cmake .. -DCMAKE_INSTALL_PREFIX=/opt/mysql -DBUILD_CONFIG=mysql_rele

Question about my build of MySQL 5.6.10

2014-07-10 Thread Damien Kick
I build from source but find that libmysqlclient_r is merely a symlink to libmysqlclient. Is that expected? $ uname -a Darwin Damien-Kicks-MacBook-Pro.local 12.5.0 Darwin Kernel Version 12.5.0: Sun Sep 29 13:33:47 PDT 2013; root:xnu-2050.48.12~1/RELEASE_X86_64 x86_64 $ echo $CXX /Users/dkick/bi

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread shawn l.green
Hello, On 7/6/2014 7:42 PM, 娄帅 wrote: Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any inp

Re: Doubts tuning MySQL Percona Server 5.5

2014-07-07 Thread Johan De Meersman
- Original Message - > From: "Antonio Fernández Pérez" > Subject: Re: Doubts tuning MySQL Percona Server 5.5 > ​I was checking MySQL performance ... Sometimes my database could be working > slow. I have some queries that spend 9-10 seconds updating some columns by

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread Reindl Harald
gt;> >> >> 2014-07-07 7:42 GMT+08:00 娄帅 : >> >>> Hi, all, >>> >>> I want to use MySQL 5.6.18 in production, so i want to get all known bugs >>> on this version. Now i check the "bugfix" section in MySQL 5.6.19 and >> abov

Re: How to get all known bugs on specified mysql version?

2014-07-07 Thread wagnerbianchi.com
Why do not use GTID? Just curious...WB 2014-07-07 3:18 GMT-03:00 louis liu : > don't use GTID is my suggestion :) > > > > 2014-07-07 7:42 GMT+08:00 娄帅 : > > > Hi, all, > > > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs >

Re: Doubts tuning MySQL Percona Server 5.5

2014-07-06 Thread Antonio Fernández Pérez
​Hi, I was checking MySQL performance ... Sometimes my database could be working slow. I have some queries that spend 9-10 seconds updating some columns by primary key. I'm not sure if is a data base problem ... Moreover, I have checked tuning scripts and appear these variables. Good sen

Re: How to get all known bugs on specified mysql version?

2014-07-06 Thread louis liu
don't use GTID is my suggestion :) 2014-07-07 7:42 GMT+08:00 娄帅 : > Hi, all, > > I want to use MySQL 5.6.18 in production, so i want to get all known bugs > on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above > version. Am i doing the

How to get all known bugs on specified mysql version?

2014-07-06 Thread 娄帅
Hi, all, I want to use MySQL 5.6.18 in production, so i want to get all known bugs on this version. Now i check the "bugfix" section in MySQL 5.6.19 and above version. Am i doing the right thing? Or Do you have a better method? Any input will be appreciated!

Re: Doubts tuning MySQL Percona Server 5.5

2014-07-05 Thread Johan De Meersman
2014 8:00:31 PM CEST, "Antonio Fernández Pérez" wrote: >Hi list, > >I have some doubts adjusting some MySQL variables. >​ I have checked MySQL status and maybe I should to increase some >variables >... > >For example: >InnoDB log waits is 103; innodb_log_buffe

Doubts tuning MySQL Percona Server 5.5

2014-07-04 Thread Antonio Fernández Pérez
Hi list, I have some doubts adjusting some MySQL variables. ​ I have checked MySQL status and maybe I should to increase some variables ... For example: InnoDB log waits is 103; innodb_log_buffer_size is 8M --> Maybe the next best value could be 16M? Table cache hit rate is 12%; Open_tables

MySQL for Visual Studio 1.2.1 beta has been released

2014-07-01 Thread Hery Ramilison
Dear MySQL users, MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.1 version is a beta release of this product which is feature complete but still can contain minor bugs and is not suitable for production

MySQL for Excel 1.3.1 RC has been released

2014-07-01 Thread Hery Ramilison
Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.1. This is a RC release for 1.3.x. MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It

MySQL Enterprise Backup 3.10.2 has been released

2014-06-30 Thread karen langford
Dear MySQL users, MySQL Enterprise Backup 3.10.2, a new version of the online MySQL backup tool, is now available for download from the My Oracle Support (MOS) website as our latest GA release. This release will be available on eDelivery (OSDC) after the next upload cycle. MySQL Enterprise

Re: MySQL UUID_SHORT() gives error Out of range value for column

2014-06-21 Thread Roberta Jaskolski
>>>> 2014/06/20 11:31 +0100, Neil Tompkins >>>> I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For example the number I get is 12057145185130250250 <<&

MySQL UUID_SHORT() gives error Out of range value for column

2014-06-20 Thread Neil Tompkins
Hi, I'm using MySQL 5.6.17 on Amazon Web Services RDS and when calling SELECT UUID_SHORT() I'm getting a number bigger than 9223372036854775807. For example the number I get is 12057145185130250250 The problem is in my table I have a column as BIGINT(20) unsigned, but when storin

MySQL Connector/C 6.1.5 has been released

2014-06-17 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/C 6.1.5, a new version of the C API for client/server communication for the MySQL database management system, has been released. This version of Connector/C provides full support for MySQL 5.6 protocol. Connector/C is compatible with the client libraries

MySQL Connector/J 5.1.31 has been released

2014-06-06 Thread Hery Ramilison
Hello all, MySQL Connector/J 5.1.31, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.31 is suitable for use with many MySQL server versions, including 4.1, 5.0, 5.1, 5.4, 5.5 and 5.6. MySQL Connector

MySQL for Excel 1.3.0 Beta has been released

2014-06-06 Thread karen langford
Dear MySQL users, The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.0. This is a beta release for 1.3.x. MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It

MySQL Connector/NET 6.9.1 Beta has been released

2014-05-29 Thread karen langford
Dear MySQL users, MySQL Connector/Net 6.9.1 a new version of the all-managed .NET driver for MySQL has been released. This is a beta release for 6.9.x and is not recommended for production environments. It is appropriate for use with MySQL server versions 5.5-5.7. It is now available in

MySQL Utilities 1.4.3 GA (including MySQL Fabric) has been released

2014-05-27 Thread Hery Ramilison
Dear MySQL users, This is the GA release for Utilities 1.4 and the first GA release for MySQL Fabric. MySQL Utilities version 1.4.3 is compatible with MySQL Server versions 5.1 and greater, but should work with earlier versions (greater than v4.1). Python v2.6 and v2.7 are supported. In

ANN: MySQL Performance Monitoring

2014-05-21 Thread Mick Emmett
Greetings MySQL users -- If MySQL monitoring is something you are doing with one specific tool -- or not at all -- then you might find this blog post on MySQL Performance Monitoring in SPM worth a read: http://wp.me/pwdA7-Xo We frequently hear from organizations across industries who tackle

Re: multilple mysql engines, one set of shared table spaces? (addendum)

2014-05-14 Thread shawn l.green
in your situation. http://dev.mysql.com/doc/refman/5.6/en/multiple-servers.html Really. I mean it. Don't do it. However, if what you want to do is have two MySQL instances setup to point to the same files from the same machine or different host machines (such as in a shared SAN disk), you can

Re: multilple mysql engines, one set of shared table spaces?

2014-05-14 Thread shawn l.green
oc/refman/5.6/en/multiple-servers.html Really. I mean it. Don't do it. -- Shawn Green MySQL Senior Principal Technical Support Engineer Oracle USA, Inc. - Hardware and Software, Engineered to Work Together. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.

Re: multilple mysql engines, one set of shared table spaces?

2014-05-14 Thread Michael Dykman
As far as I know, the only way this is possible is if your entire database is formatted as MyISAM. In that case, multiple MySQL processes, each started with external-locking enabled, may safely share a data folder. The contention will almost certainly kill you as far as performance goes.. and

multilple mysql engines, one set of shared table spaces?

2014-05-14 Thread Bruce Ferrell
he answers? Inquiring minds want to know Thanks in advance Bruce Ferrell -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

MySQL Connector/ODBC 5.2.7 has been released

2014-05-13 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.2.7, a new version of the ODBC driver for the MySQL database management system, has been released. The available downloads include both a Unicode driver and an ANSI driver based on the same modern codebase. Please select driver type you need based on the

MySQL Connector/Python 1.1.7 has been released

2014-05-13 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/Python 1.1.7 is a new version of the pure Python database driver for MySQL. MySQL Connector/Python version 1.1 is compatible with MySQL Server versions 5.5 and greater, but should work with earlier versions greater than 4.1. Python 2.6 and greater as well as

ANN: DAC for MySQL 2.9.7 is out!

2014-05-13 Thread Aleksander Andreev
DAC for MySQL is direct access components for MySQL, EnterpriseDB. It allows you to create Delphi/C++Builder applications with direct access to DAC for MySQL/EnterpriseDB without BDE and ODBC. What’s new in v2.9.7: Support for RAD Studio XE6 added, several minor improvements and bug fixes. Full

Re: mysql Access denied error

2014-05-09 Thread Divesh Kamra
Edward , use following way mysql -uroot -p -h{host ip } else give grant privileges to localhost On Mon, May 5, 2014 at 7:47 AM, EdwardKing wrote: > I use mysql to create a database and grant rights to a user > hadooptest,then I use hadooptest to login mysql and use the database,

Re: mysql Access denied error

2014-05-05 Thread Peter Brawley
On 2014-05-04 9:17 PM, EdwardKing wrote: I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. The command sequence ... mysql> cre

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
Am 05.05.2014 15:26, schrieb Johan De Meersman: > - Original Message - >> From: "Reindl Harald" >> >> i know that, but it does not change the fact that here > > Either you didn't know that but have trouble admitting it; or you did but > conciously chose to be rude and condescending in

Re: mysql Access denied error

2014-05-05 Thread Johan De Meersman
- Original Message - > From: "Reindl Harald" > > i know that, but it does not change the fact that here Either you didn't know that but have trouble admitting it; or you did but conciously chose to be rude and condescending instead of helpful. Your choice. In the second scenario, I

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
l the time, just do the >>> grant >>> > with "@localhost" instead of "@%" >>> >>> nonsense >>> >>> % matches *any host* >>> >>> Do the test yourself >> >> i don't need

Re: mysql Access denied error

2014-05-05 Thread Jigal van Hemert
#x27;t specify it you will be > attempting to connect via Unix Socket. > If you don't want to specify -hlocalhost all the time, just do the grant > with "@localhost" instead of "@%" nonsense % matches *any host* Do the test yourself

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui
uot; > > > > nonsense > > > > % matches *any host* > > > > Do the test yourself > > i don't need to test such basics since i am working > as mysql administrator the last 11 years and curently > responsible for some hundret databases heavily

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
ll be > > attempting to connect via Unix Socket. > > If you don't want to specify -hlocalhost all the time, just do the grant > > with "@localhost" instead of "@%" > > nonsense > > % matches *any host* > > Do the te

Re: mysql Access denied error

2014-05-05 Thread Manuel Arostegui
2014-05-05 10:00 GMT+02:00 Reindl Harald : > > > Am 05.05.2014 08:34, schrieb Manuel Arostegui: > > "%" doesn't match localhost so if you don't specify it you will be > > attempting to connect via Unix Socket. > > If you don't want to specify -hlocalhost all the time, just do the grant > > with "@

Re: mysql Access denied error

2014-05-05 Thread Reindl Harald
Am 05.05.2014 08:34, schrieb Manuel Arostegui: > "%" doesn't match localhost so if you don't specify it you will be > attempting to connect via Unix Socket. > If you don't want to specify -hlocalhost all the time, just do the grant > with "@localhost" instead of "@%" nonsense % matches *any hos

Re: mysql Access denied error

2014-05-04 Thread Manuel Arostegui
2014-05-05 4:17 GMT+02:00 EdwardKing : > I use mysql to create a database and grant rights to a user > hadooptest,then I use hadooptest to login mysql and use the database,but it > failed. Why raise error after I grant rights? How to solve it? Thanks. > > My operation is follo

mysql Access denied error

2014-05-04 Thread EdwardKing
I use mysql to create a database and grant rights to a user hadooptest,then I use hadooptest to login mysql and use the database,but it failed. Why raise error after I grant rights? How to solve it? Thanks. My operation is follows: [hadoop@master ~]$ mysql -h localhost -u root -p Enter

Re: Why MySQL-server-5.5.37 install fail?

2014-05-04 Thread yoku ts.
Hello, mysqladmin and mysql command-line client is included in MySQL-client package. mysql_secure_installation is included in MySQL-server but it's a perl script which calls mysql command-line client internally. Thus, you should install MySQL-client-*.rpm and try again. Regards, 2014-

Re: Why MySQL-server-5.5.37 install fail?

2014-05-04 Thread Reindl Harald
Am 04.05.2014 08:29, schrieb EdwardKing: > I'm newbie to mysql and I want to install mysql under Centos 5.8 using > MySQL-server-5.5.37-1.linux2.6.i386.rpm, I use following command to intall > mysql > > #[root@master software]# rpm -ivh MySQL-server-5.5.37-1.linux2.6.i

Why MySQL-server-5.5.37 install fail?

2014-05-03 Thread EdwardKing
I'm newbie to mysql and I want to install mysql under Centos 5.8 using MySQL-server-5.5.37-1.linux2.6.i386.rpm, I use following command to intall mysql #[root@master software]# rpm -ivh MySQL-server-5.5.37-1.linux2.6.i386.rpm Prep

MySQL Connector/NET 6.9.0 alpha has been released

2014-04-30 Thread karen langford
Dear MySQL users, MySQL Connector/Net 6.9.0 a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release for 6.9.x and is not recommended for production environments. It is appropriate for use with MySQL server versions 5.0-5.7. It is now available in

MySQL Cluster Manager 1.3.1 has been released

2014-04-30 Thread Sowmya Dass
Dear MySQL users, MySQL Cluster Manager 1.3.1, has been released and can be downloaded from Oracle Software Delivery Cloud at http://edelivery.oracle.com. It is also available for download from the My Oracle Support (MOS) website. MySQL Cluster Manager is an optional component of MySQL

MySQL for Visual Studio 1.2.0 alpha has been released

2014-04-21 Thread karen langford
Dear MySQL users, MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.0 version is an alpha release of this product that intends to introduce users to the new features in this version. This release is not

Re: Data masking for mysql

2014-04-17 Thread misiaq
ck! m Od: reena.kam...@jktech.com Do: mysql@lists.mysql.com; Wysłane: 8:57 Wtorek 2014-04-15 Temat: Data masking for mysql > Hi, > > I need to do data masking to sensitive data exists in mysql db. is there any > data masking tool available for mysql with linux platform. > if yes...

<    2   3   4   5   6   7   8   9   10   11   >