MySQL High End Features Should be Closed Source & for Paid Customers Only

July 20th, 2007 What is auto reconnect in MySQL? The MySQL client library can perform an automatic reconnect to the server if it finds that the connection is down when you attempt to send a statement to the server to be executed. In this case, the library tries once to reconnect to the server and send the statement again.

November 25th, 2008 The MySQL Query Analyzer tool monitors query performance and quickly pinpoints and corrects problems in SQL code. It promises to "turbo-boost" the speed and uptime of MySQL database applications.

January 17th, 2009 MySQL stores usernames and passwords in the user table inside the MySQL database. You can directly update a password using the following method to update or change passwords: 1) Login to the MySQL server, type the following command at the shell prompt: $ mysql -u root -p 2) Use the mysql database (type commands at the mysql> prompt): mysql> use mysql; 3) Change password for a user: mysql> update user set password=PASSWORD("newpass") where User='YOUR-USER-NAME'; 4) Reload privileges: mysql> flush privileges; mysql> quit [P.S.

May 12th, 2007 Mantis is popular php based defect tracking application which works on top of RDBMS like MySQL and PostgreSQL. Recently I ported our Windows based Mantis installation to Linux.

May 13th, 2005 Note: My WordPress database name is wordpress. I will use it in the example below.

January 17th, 2009 Do you want to recover the MySQL root password. its by no means, easy.

September 3rd, 2009 EU probes Oracle's bid to buy SunBRUSSELS — European Union regulators on Thursday launched an antitrust probe into U.S. software maker Oracle Corp.'s takeover of Sun Microsystems Inc., saying they wanted to make sure Oracle was committed to developing Sun's rival open-source database software MySQL.

August 26th, 2009 Open Source Server based database management systems have become a common choice for organizations over the stand alone desktop databases. The server based databases or RDBMS such as MySQL, PostgreSQL, Microsoft SQL Server are designed to be used on servers and it can be easily shared by multiple users.

September 1st, 2007 Working with replication systems is not easy. Learning and testing different kind of MySQL replications and fine-tuning it to your specific needs is a time-consuming endeavor.

April 27th, 2009 Suppose you want to change and enable the remote access to MySQL DB on your linux server (Debian). By default, you don't get such privileges so you will have to work your way through this.

July 24th, 2007 A much dreaded MySQL error message during queries is "MySQL server has gone away". An alternative message is "Lost connection to server during query".

July 2nd, 2005 Sun Microsystems is looking at providing its Java Enterprise System (J2EE) customers with a database management solution that will either take advantage of existing open-source database management technologies or developed in-house. I think they should leverage from some high quality open source database management solutions rather than re-inventing the wheel.

July 13th, 2007 This is a very interesting presentation (see below) on the technologies used to make Digg, the challenges faced along the way and how they overcame it. I would recommend it to any Web 2.0 startup architects.

September 1st, 2007 Try: mysql -e status|grep 'Server version' If that doesn't work then use: mysql -u root -p -e status|grep 'Server version' Provide root password when prompted. Default root password for MySQL is empty string, so just pressing enter when prompted for password will suffice by default.

August 9th, 2005 As an architect I have often been asked this question by my clients, friends and at work. I would like to answer it briefly once and for all.