Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
*your application* is connecting to mysql *your application* is using a hostname *your application* *may* use 127.0.0.1 *your application* should use localhost to *connect to the databse* *your application* can only use TCP *if there is* a *mysql user* with *that host* http://dev.mysql.com/doc

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
WTF - we are talking about *database connections* and *not* http-URL's the webserver is only the *messenger* Am 13.01.2014 18:54, schrieb Érico: > using both urls I get the same error : > > http://localhost/mysql/index.php > http://127.0.0.1/mysql/index.php > > in 127.

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
Hi no connections outside command line are being accepted . I have connected through command line , but not using eclipse for example ... it gets the same error from the web app my apache and pages are in the same computer that mysql I am not getting password issues.. otherwise I would not

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread shawn l.green
emember is that 'localhost' or '127.0.0.1' is where the server believes the connection is coming from. The password you must be using in your client connection attempt must match the one used on the server for the mysql user 'root'@'localhost' or you will n

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
o wrote: > > the granting is not affecting the tables: > > > > mysql> grant all privileges on *.* to root@localhost identified by > 'pwd'; > > Query OK, 0 rows affected (0.00 sec) > > > > mysql> FLUSH PRIVILEGES; > > Query OK, 0 rows aff

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
On 13 January 2014 13:25, Érico wrote: > the granting is not affecting the tables: > > mysql> grant all privileges on *.* to root@localhost identified by 'pwd'; > Query OK, 0 rows affected (0.00 sec) > > mysql> FLUSH PRIVILEGES; > Query OK, 0 rows affected (0

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
the granting is not affecting the tables: mysql> grant all privileges on *.* to root@localhost identified by 'pwd'; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) ... and if I try the granting in 127.0.0.1 : mysql> gran

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
I forgot this. Do it too. On 13 January 2014 13:01, Erick Ocrospoma wrote: > I presume your index.php file uses "127.0.0.1". After login to MySQL try this: > > $> grant all privileges to *.* 'root'@'127.0.0.1' identified by > ; $> flush priv

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
I presume your index.php file uses "127.0.0.1". After login to MySQL try this: $> grant all privileges to *.* 'root'@'127.0.0.1' identified by ; Of course this could not be the best solution, it's just to skip it, you must look at the query/connection on yo

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
using localhost the coonection works ... ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin -h localhost -P 3306 Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
using both urls I get the same error : http://localhost/mysql/index.php http://127.0.0.1/mysql/index.php in 127.0.0.1... after I submit the index.php ... it redirects to localhost too .. 2014/1/13 Reindl Harald > > > Am 13.01.2014 18:28, schrieb Érico: > > ericomtxmacbookp

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Erick Ocrospoma
>From that error I would suspect you are trying to access to a database where has not external access. And yeah, try by doing $> mysql -u root -p -h localhost -P 3306 change localhost by 127.0.0.1 in order to test if both cases work, and see which of them (localhost/127.0.0.1) is defi

Re: Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Reindl Harald
Am 13.01.2014 18:28, schrieb Érico: > ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin > Enter password: > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 31 > Server version: 5.6.15 MySQL Community Server (GPL)> > >

Access denied for user 'root'@'localhost' (using password: YES) on mysql admin

2014-01-13 Thread Érico
Hi I have installed mysql admin on my local environment I am able to connect to mysql through command line : ericomtxmacbookpro:bin ericomtx$ ./mysql -u root -p mysql-admin Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 31 Server version

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-08 Thread Manuel Arostegui
2014/1/7 > 2014/01/06 17:07 +0100, Reindl Harald > what about look in the servers logfiles > most likely "max_allowed_packet" laughable low > > Is this then, too, likly when the server and the client are the same > machine? > > I left this out, that it only then happens when th

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-07 Thread hsv
t, that it only then happens when the client has been idle, and right afterwards the client repeats the request and all goes well. The message is no more than an irritatind break between request and fulfillment. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: loading 0x00A0 into mysql

2014-01-07 Thread Dobromir Velev
the default charset is something else like this mysql --default-character-set=utf8 --user=me test_database < dump_file Dobromir Thanks for the reply, and I apologize because I expect I've broken threading. The list isn't mailing the posts to me, so I've nothing to reply t

Re: MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint

2014-01-07 Thread Reindl Harald
Am 07.01.2014 13:48, schrieb Lukas Lehner: > Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only > interested in developer changes (not admin) > Can I use development books for MySQL 5.0.0 [2003] and use the code an > recent MariaDB and MySQL releases? clearly yes

MySQL 5.0.0 [2003] vs. MySQL 5.6 [2013] from a SQL and SQL/PSM developer viewpoint

2014-01-07 Thread Lukas Lehner
Hi Are there big changes between MySQL 5.0.0 vs. MySQL 5.6? I am only interested in developer changes (not admin) Can I use development books for MySQL 5.0.0 [2003] and use the code an recent MariaDB and MySQL releases?

Re: ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-06 Thread Reindl Harald
Am 06.01.2014 15:36, schrieb h...@tbbs.net: > Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often > see that error-message, which under 5.5.8 I never saw. What is going on? what about look in the servers logfiles most likely "max_allowed_

Re: loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
lt;<< > Well, there are too many aspects to this, but the first is the > character set that "mysql" expects for input. If, say, it is USASCII > (note that between the character set that "mysql" takes for input and > the character set in the table no association

ERROR 2013 (HY000): Lost connection to MySQL server during query

2014-01-06 Thread hsv
Now that I installed 5.6.14 on our Vista machine, when using "mysql" I often see that error-message, which under 5.5.8 I never saw. What is going on? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: loading 0x00A0 into mysql

2014-01-06 Thread hsv
make it into the new database. <<<<<<<< Well, there are too many aspects to this, but the first is the character set that "mysql" expects for input. If, say, it is USASCII (note that between the character set that "mysql" takes for input and the character set

loading 0x00A0 into mysql

2014-01-06 Thread Dave Howorth
Hello, I'm trying to make a copy of a mysql database and having an issue loading fields containing a particular character. I've taken a dump using mysqldump and then try to load it into a new database using mysql --user=me test_database < dump_file Everything appears to work exc

Re: mysql-5.1 64bit and windows 7

2014-01-01 Thread Reindl Harald
Am 01.01.2014 23:30, schrieb Elim Qiu: > I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got > confused on how to relocate the datadir. > > my basedir was F:/MySQL and datadir was F:/MySQL/data > > It works fine and I'm trying to relocate the datad

mysql-5.1 64bit and windows 7

2014-01-01 Thread Elim Qiu
I installed mysql 5.1 to windows 7 using mysql-5.1.73-winx64.msi and got confused on how to relocate the datadir. my basedir was F:/MySQL and datadir was F:/MySQL/data It works fine and I'm trying to relocate the datadir: (0) stop mysql service (1) copy F:/MySQL/data to F:/DBData/MySQL/da

Re: MySQL Descending ORDER issue

2013-12-27 Thread Dan Nelson
In the last episode (Dec 27), Russ Lavoie said: > I am currently upgrading from mysql 5.1.72 -> mysql 5.6 and the migration > and upgrade is sound (In a QA ENV). Queries work etc. However, when I > run a query similar to "SELECT `table`.* FROM `table` WHERE (credential_id &

RE: MySQL Descending ORDER issue

2013-12-27 Thread Russ Lavoie
T `table_foo`.* FROM `table_foo` WHERE (credential_id IN (13528, 14906, 38845)) ORDER BY `date` DESC LIMIT 1; Thanks! > From: myfriendvi...@gmail.com > Date: Fri, 27 Dec 2013 10:27:28 -0800 > Subject: RE: MySQL Descending ORDER issue > To: russ_lav...@hotmail.com; mysql@lists.mysql.com

RE: MySQL Descending ORDER issue

2013-12-27 Thread Vikas Shukla
Hi Russ, Please share with us the exact details of the table data as well as the o/p. Regards, ViXiD Vikas Shukla Mail Sent from my Windows Phone From: Russ Lavoie Sent: 27-12-2013 23:32 To: mysql@lists.mysql.com Subject: MySQL Descending ORDER issue Hello, I am currently upgrading from mysql

MySQL Descending ORDER issue

2013-12-27 Thread Russ Lavoie
Hello, I am currently upgrading from mysql 5.1.72 -> mysql 5.6 and the migration and upgrade is sound (In a QA ENV). Queries work etc. However, when I run a query similar to "SELECT `table`.* FROM `table` WHERE (some_id IN (13528, 14906, 38845)) ORDER BY `date` DESC LIMIT 1;" on

MySQL Connector/C 6.1.3 has been released

2013-12-27 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/C 6.1.3, 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

ANN: Data Wizard for MySQL 13.12 released

2013-12-12 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of Data Wizard for MySQL 13.12, a powerful Windows GUI solution for MySQL data management. The new version is immediately available at http://www.sqlmaestro.com/products/mysql/datawizard/ Data Wizard for MySQL provides you with a number of easy-to-use

MySQL Community Server 5.7.3 has been released (part 2/2)

2013-12-04 Thread Bjorn Munch
[ This is part 2 of the announcement ] Bugs Fixed * Incompatible Change: For logging to the general_log and slow_log tables in the mysql database, log lines containing multiple character sets were not always handled correctly. The general_log.argument and

MySQL Community Server 5.7.3 has been released (part 1/2)

2013-12-04 Thread Bjorn Munch
Dear MySQL users, MySQL Server 5.7.3 (Milestone Release) is a new version of the world's most popular open source database. This is the third public milestone release of MySQL 5.7. [Due to length restrictions, this announcement is split into two parts. This is part 1.] http://dev.mysq

MySQL Community Server 5.1.73 has been released

2013-12-03 Thread Hery Ramilison
Dear MySQL users, MySQL Server 5.1.73, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.73 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/

MySQL Connector/ODBC 5.3.1 beta has been released

2013-11-27 Thread Hery Ramilison
Dear MySQL users, MySQL Connector/ODBC 5.3.1 beta, 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

FW: MySQL Problems

2013-11-14 Thread Hans Scheffers
Hi, We are running on opensuse that defaults to a mariadb instead of mysql install, so we were running icinga 1.9.2 / idoutils 1.9.2 on a opensuse ppc system, with mariadb 5.5.33. This generated a lot of errors in de database (with restarts): InnoDB: Assertion failure in thread

Mysql proxy

2013-11-14 Thread Rafael Valenzuela
Hi all, I have a question, i'm trying to create a high envairoment , i'm searching in google and see the MySQL proxy proyect but i don't know if is a good idea use this proyect ?. I'm try to ask in the irc chanel but i can't, i need a espcial user or privilege? Tha

Re: Mysql 5.1 union with group by for results

2013-11-08 Thread Machiel Richards
Hi Jesper I was just discussing this with the development manager now and the following was noted. - The query was written for mysql 4.0 originally and it seems that in version 5.0 they had enabled some legacy support stuff ( I am not too familiar with this as it is before my

Re: Mysql 5.1 union with group by for results

2013-11-08 Thread Machiel Richards
or in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY t.AccountID, I suspect your query has never been doing what you think at all, and you need to select [fields] from ( select fields1 blahblah UN

Re: Mysql 5.1 union with group by for results

2013-11-08 Thread Johan De Meersman
- Original Message - > From: "Machiel Richards" > > ERROR 1064 (42000): You have an error in your SQL syntax; check the > manual that corresponds to your MySQL server version for the right > syntax to use near 'GROUP BY t.AccountID, I suspect your query

Re: Mysql 5.1 union with group by for results

2013-11-08 Thread Jesper Wisborg Krogh
Hi Machiel, On 8/11/2013 20:04, Machiel Richards wrote: Good day all I am hoping someone can assist me in the following. One of our servers were running mysql 5.0 still and as part of a phased upgrade route we have upgraded to version 5.1. However since the upgrade

Mysql 5.1 union with group by for results

2013-11-08 Thread Machiel Richards
Good day all I am hoping someone can assist me in the following. One of our servers were running mysql 5.0 still and as part of a phased upgrade route we have upgraded to version 5.1. However since the upgrade, the query below gives us an error stating that the syntax

RE: Change to MySQL Community Server 5.7.2?

2013-10-28 Thread hsv
the computer where the database is changed to a newer: good time for installing a newer MySQL, too. In 5.6 there is a feature of interest to me: DATETIME (I wish it were DATE) also allows DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP; and in 5.7 a bug that I reported, relevant to my code

RE: MySQL Community Server 5.7.2 has been released (part 1)

2013-10-24 Thread Rick James
s that will bite you. Fortunately, regressions are rare. You should probably upgrade to 5.6 soon, simply to avoid having to do a double upgrade when you eventually go to 5.7. > -Original Message- > From: h...@tbbs.net [mailto:h...@tbbs.net] > Sent: Thursday, October 24, 2013 7

Re: MySQL Community Server 5.7.2 has been released (part 1)

2013-10-24 Thread hsv
MySQL fans, >>>> 2013/09/21 18:04 +0200, Bjorn Munch >>>> MySQL Server 5.7.2 (Milestone Release) is a new version of the world's most popular open source database. This is the second public milestone release of MySQL 5.7. <<<<<<<< Is t

MySQL Connector/ODBC 5.3.0 alpha has been released

2013-10-24 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.3.0 alpha, 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 within the same package. Server-side prepared statements are enabled by

ANN: MicroOLAP Database Designer for MySQL 2.1.1 is available!

2013-10-23 Thread Aleksander Andreev
This release introduces support for one of the most long-awaited functionality - MySQL Spatial types! A couple of serious bugs were fixed. Everybody should consider upgrading to this version as soon as possible. Full changelog: [!] Spatial types support added! [+] Sample files are copied on the

Oracle Certified Professional, MySQL 5.6 Developer [1Z0-882]

2013-10-14 Thread Lukas Lehner
Hi is the book "Oracle Database 11g and MySQL 5.6 Developer Handbook from Michael McLaughlin" a good preparation for new dev exam 1Z0-882? Will I pass when understand and know everything in this book? Lukas

FOSDEM 2014 MySQL Devroom CfP is open !

2013-10-13 Thread Frederic Descamps
Hi all, We're pleased to announce the call for participation for the MySQL & Friends devroom. Last year was maybe one the most amazing year ! Like every year, FOSDEM takes place the first week-end of February in Brussels. MySQL & Friends devroom is scheduled on Saturday (thi

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Reindl Harald
sounds like a scheduler issue did you try "deadline"? http://en.wikipedia.org/wiki/Deadline_scheduler on Linux systems pass "elevator=deadline" as kernel param Am 12.10.2013 20:58, schrieb Chris McKeever: > We had a similar issue a bit back - and although it sounds similar - based > on your foll

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Chris McKeever
We had a similar issue a bit back - and although it sounds similar - based on your followups it probably isnt, but will just toss this out there anyhows. We were experiencing connection timeouts when load would ramp up. Doing some digging we learned that our firewall between the servers bandwidth

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Reindl Harald
Am 12.10.2013 19:45, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 17:36, Reindl Harald wrote: >> so someone did "optimize table" on a large table >> you do yourself not a favour restarting the server in such a moment > > 7 hours before the server was shut down, we did a alter table t

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Jørn Dahl-Stamnes
s read-only from the web application. -- Jørn Dahl-Stamnes homepage: http://photo.dahl-stamnes.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Reindl Harald
Am 12.10.2013 17:02, schrieb Jørn Dahl-Stamnes: > On Saturday 12 October 2013 13:07, Andrew Moore wrote: >> Could be a crash related to innodb data dictionary being out of sync. Could >> be a bug. > > Seems like a bug yes. However, we had a strange situation yesterday when we > had several proc

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Jørn Dahl-Stamnes
dahl-stamnes.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Andrew Moore
gt; > > > bind-address= 127.0.0.1 > > > > in your my.cnf and restart mysql server. > > It does not explain why it works under low load and not under high load. > > However, I seem to have found something. When I started phpMyAdmin and > selected one of the database,

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread Jørn Dahl-Stamnes
On Saturday 12 October 2013 12:01, nixofortune wrote: > You might want to comment > > bind-address= 127.0.0.1 > > in your my.cnf and restart mysql server. It does not explain why it works under low load and not under high load. However, I seem to have found something.

Re: Lost connection to MySQL server - need help.

2013-10-12 Thread nixofortune
You might want to comment bind-address= 127.0.0.1 in your my.cnf and restart mysql server. On 12/10/13 10:49, Jørn Dahl-Stamnes wrote: Hello, I got a strange problem related to a production server. It has been working OK for months, but yesterday it start to fail. There are

Lost connection to MySQL server - need help.

2013-10-12 Thread Jørn Dahl-Stamnes
(): Lost connection to MySQL server at 'reading initial communication packet', system error: 111 I stopped the server and restarted it and everything seems to work OK for hours but when the load start to increase, the errors begin to appear again. Today I noticed that after I starte phpM

FOSDEM 2014 MySQL Devroom CfP is open !

2013-10-12 Thread Frédéric Descamps
Hi all, We're pleased to announce the call for participation for the MySQL & Friends devroom. Last year was maybe one the most amazing year ! Like every year, FOSDEM takes place the first week-end of February in Brussels. MySQL & Friends devroom is scheduled on Saturday (thi

FOSDEM 2014 MySQL Devroom CfP is open !

2013-10-11 Thread Frédéric Descamps
Hi all, We're pleased to announce the call for participation for the MySQL & Friends devroom. Last year was maybe one the most amazing year ! Like every year, FOSDEM takes place the first week-end of February in Brussels. MySQL & Friends devroom is scheduled on Saturday (thi

Re: MySQL Connector/ODBC 5.2.6 has been released

2013-10-10 Thread Shawn Green
Hello Saquib, On 10/9/2013 7:17 PM, Saqib N Ali wrote: no binaries for AIX? -- saqib http://hivemined.net The last ODBC package built for AIX was 5.1.8 released Oct 2010 http://downloads.mysql.com/archives.php?p=mysql-connector-odbc-5.1&o=aix This is inline with our EOL announcem

Re: MySQL Connector/ODBC 5.2.6 has been released

2013-10-09 Thread Saqib N Ali
no binaries for AIX? -- saqib http://hivemined.net On Wed, Oct 9, 2013 at 3:02 PM, Kent Boortz wrote: > > Dear MySQL users, > > MySQL Connector/ODBC 5.2.6, a new version of the ODBC driver for the > MySQL database management system, has been released. > > The availa

MySQL Connector/ODBC 5.2.6 has been released

2013-10-09 Thread Kent Boortz
Dear MySQL users, MySQL Connector/ODBC 5.2.6, 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

ANN: DAC for MySQL 2.9.5 is out!

2013-10-08 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.5:* Support for RAD Studio XE5 added, several minor improvements and bugfixes

Connecting to MySQL Community Edition from Informatica Powercenter 9.5.1 running on AIX

2013-10-02 Thread Saqib N Ali
Is it possible to MySQL Community Edition (as target) from Informatica Powercenter 9.5.1 running on AIX? If so, what is ODBC driver should we use?

MySQL Connector/C 6.1.2 has been released

2013-10-01 Thread Kent Boortz
Dear MySQL users, MySQL Connector/C 6.1.2, 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

Re: Why is mySQL not respecting foreign characters as different

2013-09-27 Thread Hartmut Holzgraefe
here: http://www.skysql.com/blogs/hartmut/adding-case-insensitive-distinct-unicode-collation -- Hartmut Holzgraefe, Principal Support Engineer (EMEA) SkySQL | http://www.skysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Why is mySQL not respecting foreign characters as different

2013-09-26 Thread Anders Karlsson
son Daevid Vincent skrev 2013-09-26 23:44: How come MySQL is not differentiating between these characters? SELECT text_id, us, de, es, fr FROM texts WHERE us = fr; Results in matching here. Notice the difference in the "scene" vs "scène" text_id

Re: Why is mySQL not respecting foreign characters as different

2013-09-26 Thread Claudio Nanni
>Do I have to add something to my query to tell MySQL to respect other character sets as different? If you want to distinguish between characters in the same utf8 class you have to use some workaround, from the top of my head, you might use binary() to get the utf8 code of the string which is

Why is mySQL not respecting foreign characters as different

2013-09-26 Thread Daevid Vincent
How come MySQL is not differentiating between these characters? SELECT text_id, us, de, es, fr FROM texts WHERE us = fr; Results in matching here. Notice the difference in the "scene" vs "scène" text_id us e

ANN: Code Factory for MySQL 13.9 released

2013-09-23 Thread SQL Maestro Team
Hi! SQL Maestro Group announces the release of Code Factory for MySQL 13.9, a powerful Windows GUI solution for querying MySQL databases and managing the data. http://www.sqlmaestro.com/products/mysql/codefactory/ Please note that before Oct 13 you can purchase all our products and bundles with

MySQL Community Server 5.7.2 has been released (part 4 of 4)

2013-09-21 Thread Bjorn Munch
* The code base was modified to account for new warning checks introduced by gcc 4.8. (Bug #16729109) * Compiling failed with -DMY_ATOMIC_MODE_RWLOCKS=1 or on platforms on which MySQL did not support lockless atomic operations (such as ARM). (Bug #16736461

MySQL Community Server 5.7.2 has been released (part 3 of 4)

2013-09-21 Thread Bjorn Munch
t to 0 (SET foreign_key_checks = 0;). As a result, an appropriate duplicate ID check would not be performed. (Bug #16413976) * InnoDB: This fix removes dated and incomplete code that is protected by the UNIV_LOG_ARCHIVE macro. (Bug #16296837) * InnoDB: RENAME

MySQL Community Server 5.7.2 has been released (part 2 of 4)

2013-09-21 Thread Bjorn Munch
-package.html) can be used and printouts from various InnoDB subsystems can be enabled using the mysqld --debug command line option. See the Debugging a MySQL Server (http://dev.mysql.com/doc/refman/5.7/en/debugging-server.html) section for information about

MySQL Community Server 5.7.2 has been released (part 1)

2013-09-21 Thread Bjorn Munch
Dear MySQL users, MySQL Server 5.7.2 (Milestone Release) is a new version of the world's most popular open source database. This is the second public milestone release of MySQL 5.7. http://dev.mysql.com/doc/mysql-development-cycle/en/development-milestone-releases.html [ Due to a size

MySQL Community Server 5.1.72 has been released

2013-09-20 Thread Hery Ramilison
Dear MySQL users, MySQL Server 5.1.72, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.72 is recommended for use on production systems. For an overview of what's new in MySQL 5.1, please see http://dev.mysql.com/doc/refman/5.1/en/

MySQL Community Server 5.6.14 has been released

2013-09-20 Thread Sunanda Menon
Dear MySQL users, MySQL Server 5.6.14, a new version of the popular Open Source Database Management System, has been released. MySQL 5.6.14 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/

Google swaps out MySQL, moves to MariaDB

2013-09-16 Thread Daevid Vincent
http://www.theregister.co.uk/2013/09/12/google_mariadb_mysql_migration/

Oracle Launches New MySQL 5.6 Certifications

2013-09-12 Thread misiaq
Older MySQL Exams to Retire https://blogs.oracle.com/certification/entry/0875_01 regards, m -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

MySQL Connector/Python 1.1.1-alpha has been released

2013-09-10 Thread Sunanda Menon
Dear MySQL users, MySQL Connector/Python 1.1.1 is the next alpha version of the 1.1 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 the

RE: MySQL version 3.23 to 5.x features

2013-09-05 Thread Rick James
m] > Sent: Thursday, August 22, 2013 12:16 AM > To: shawn green > Cc: mysql@lists.mysql.com > Subject: Re: MySQL version 3.23 to 5.x features > > wow it really helped me a lot. I really thank Shawn,Dale Jesper for there > inputs > > > On Wed, Aug 21, 2013 at 7:13 PM,

Re: How to update MySQL table based on 3 other tables

2013-09-03 Thread shawn green
Hello Neil, On 8/24/2013 5:21 AM, Neil Tompkins wrote: I have the following four MySQL tables Region RegionId City CityId RegionId Hotel HotelId CityId HotelRegion HotelId RegionId I'm struggling to write a UPDATE statement to update the City table's RegionId field from d

MySQL 5.6.13 on our Windows 2003 local access only

2013-08-30 Thread Neil Tompkins
I have installed MySQL 5.6.13 on our Windows 2003 server and need to configure the service so that no external access is possible from a remote IP addresses. On the server it's self, the MySQL service will need to be accessed by IIS hosting a ASP.NET application and web services. I know

Re: mysql 5.5 crashed on Debian 6 after server crash

2013-08-28 Thread Simon Loewenthal
com> wrote: > Hi there, > > I just had my mysql dB crash really badly on a small server I'm running > and wonder if someone could point me in the right direction. I'm pretty > basic with mysql... I set up master/slave replication to another site, so > this could be a

mysql 5.5 crashed on Debian 6 after server crash

2013-08-28 Thread Simon Loewenthal
Hi there, I just had my mysql dB crash really badly on a small server I'm running and wonder if someone could point me in the right direction. I'm pretty basic with mysql... I set up master/slave replication to another site, so this could be a backup, so long as the errors were not

How to update MySQL table based on 3 other tables

2013-08-24 Thread Neil Tompkins
I have the following four MySQL tables Region RegionId City CityId RegionId Hotel HotelId CityId HotelRegion HotelId RegionId I'm struggling to write a UPDATE statement to update the City table's RegionId field from data in the HotelRegion table. Basically how can I update the

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-22 Thread hsv
>>>> 2013/08/22 14:22 -0400, Nick Cameo >>>> SimpleDateFormat sdf = new SimpleDateFormat("-MM-dd'T'HH:mm:ss", new Locale("en", "US")); <<<<<<<< Well, you have your answer (FROM_UNIXTIME( /1000)), but th

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-22 Thread Nick Cameo
Sorry, as was mentioned earlier: select FROM_UNIXTIME(1377196112065/1000); +---+ | FROM_UNIXTIME(1377196112065/1000) | +---+ | 2013-08-22 18:28:32 | +---+ Have a good day everyone :) Ni

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-22 Thread Nick Cameo
On Wed, Aug 21, 2013 at 10:39 PM, wrote: > >>>> 2013/08/21 18:03 -0400, Nick Khamis >>>> > We have the following mysql timetampe field > > startdate | timestamp | NO | | -00-00 00:00:00 > > When trying to insert a long value in th

Re: MySQL version 3.23 to 5.x features

2013-08-22 Thread Nagaraj S
wow it really helped me a lot. I really thank Shawn,Dale Jesper for there inputs On Wed, Aug 21, 2013 at 7:13 PM, shawn green wrote: > Hello Naga, > > > On 8/21/2013 6:45 AM, Nagaraj S wrote: > >> Hello, >> >> Can anyone share the features/comparison from MySQL

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-21 Thread hsv
>>>> 2013/08/21 18:03 -0400, Nick Khamis >>>> We have the following mysql timetampe field startdate | timestamp | NO | | -00-00 00:00:00 When trying to insert a long value in there: Calendar c = Calendar.getInstance(TimeZone.getTimeZone("UTC")); c.ge

Re: Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-21 Thread Michael Dykman
Nick, You should have answered your own question in the text. The MySql TIMESTAMP type is, as all other timestamps in the *nix world, a count of seconds since epoch time. The Java function you are using yields MILLI-seconds. Divide it by 1000 and you should be good to go. On Wed, Aug 21

Java UTC Calendar and Mysql TimeStamp - Gets me every time!!!!!

2013-08-21 Thread Nick Khamis
Hello Everyone, We have the following mysql timetampe field startdate | timestamp | NO | | -00-00 00:00:00 When trying to insert a long value in there: Calendar c = Calendar.getInstance(TimeZone.getTimeZone("UTC")); c.getTimeInMillis(); We are presented with the follo

Re: MySQL version 3.23 to 5.x features

2013-08-21 Thread Jesper Wisborg Krogh
Hi Naga, On 21/08/2013 23:43, shawn green wrote: Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single

Re: MySQL version 3.23 to 5.x features

2013-08-21 Thread shawn green
Hello Naga, On 8/21/2013 6:45 AM, Nagaraj S wrote: Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of

MySQL version 3.23 to 5.x features

2013-08-21 Thread Nagaraj S
Hello, Can anyone share the features/comparison from MySQL version 3.23 to 5.x in single document? I can get from Google, however I have to navigate different pages/sites, if it is in single document that will be useful to see the overview of mysql features -Naga

MySQL Connector/Python v1.0.12 has been released

2013-08-14 Thread Santosh Pagare
Dear MySQL users, MySQL Connector/Python v1.0.12 is a new version of the 1.0 production release of the pure Python database driver for MySQL. MySQL Connector/Python version 1.0 is compatible with MySQL Server versions 5.5 and greater, but should work with earlier versions (greater than v4.1

ANN: Meet the MicroOLAP Database Designer for MySQL 2.1.0!!!

2013-08-12 Thread Aleksander Andreev
fixed [-] "Drag-and-drop multiple selected items causes all to go in top left hand corner" bug fixed You're welcome to download the Database Designer for MySQL 2.1.0 right now at: http://microolap.com/products/database/mysql-designer/download/ Login to your private area on our

<    4   5   6   7   8   9   10   11   12   13   >