Re: MySQL running, but I cannot connect

Hi Jason, Here is what I did to connect: 1) start a client session on server host machine and issue a grant command. /usr/local/mysql$ bin/mysql -u root run a client session as the root, directory your executable resides might be different than what's shown mysql> use mysql

ORDER BY favours full scan over a faster filesort

hi all, it said the bug has been fixed in 5.1.25. See http://bugs.mysql.com/bug.php?id=35844 # Query_time: 1.657438 Lock_time: 0.85 Rows_sent: 40 Rows_examined: 885756 SET timestamp=1261447735; select item0_.id as id163_, item0_.add_time as add2_163_ from item item0_ where item0_.role_id

MySQL running, but I cannot connect

Hi All, MySQL 5.0.77 on CentOS 5.4 MySQL is running, my Wordpress stuff is working, but I cannot connect to the server from my house. I checked the firewall and that is successfully allowing the passage. I checked the firewall on the server and that has 3306:tcp allowed. When I try to connec

RE: PHP Generator for MySQL 9.12 released

Maybe I'm not understanding something, but I tried your online demo (NBA database), I set "Home like Boston%" which shows two records. Now what? Where is the PHP code that was supposedly generated to make this query? Isn't that what your tool does? Makes the actual PHP code and SQL query code for m

RE: Spatial extensions

How did you populate the point column? Should be something like: UPDATE places SET point= =GeomFromText(CONCAT("Point(",longitude," ",latitude,")")); You also should have a spatial index: ALTER TABLE places MODIFY coordinates point NOT NULL, add spatial index (coordinates); You can check the

MySQL Community Server 5.0.89 has been released

Dear MySQL users, MySQL Community Server 5.0.89, a new version of the popular Open Source Database Management System, has been released. This Community release shares the version number with its MySQL Enterprise Server counterpart. Please note this is the last release of 5.0 before it exits ac

ANN: PHP Generator for MySQL 9.12 released

Hi! SQL Maestro Group announces the release of PHP Generator for MySQL 9.12, a GUI frontend that allows you to generate high-quality PHP scripts for the selected MySQL tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/mysql/php

Re: Most data sort

Dear Mr. Wang, I've tried and the results are in accordance with the intended. Your description is very brief and precise Thank you Mr. Wang. With best regard, Haidar Pesebe - Original Message - From: "HaidarPesebe" To: "Yang Wang" ; "MySQL Lists" Sent: Monday, December 21, 2009

Re: Most data sort

Thanks Mr. Wang, I will try and inform you again if have a problem. Best regard, Haidar Pesebe - Original Message - From: "Yang Wang" To: "HaidarPesebe" ; "MySQL Lists" Sent: Monday, December 21, 2009 5:22 PM Subject: Re: Most data sort sample as below with group by and order by

Re: Most data sort

sample as below with group by and order by statment mysql> create table t2(name char(1),qty smallint); Query OK, 0 rows affected (0.01 sec) mysql> insert into t2 values('A',1),('B',2),('A',4),('A',1),('A',1),('B',1),('A',2),('C',2),('D',1),('C',4); Query OK, 10 rows affected (0.00 sec) Records: