How to start/stop MySQL server on Linux

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.

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 7th, 2006 Finally my (unmanaged dedicated) server has been deployed (under 48 hours). Now my actual work begins.

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.

November 16th, 2007 When you try MySQL master-master replication with two (or more) servers you may often find that in the process of configuring the original master to also act as a slave server (start slave), it fails with the following error: mysql> start slave; ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO To rectify it locate and delete the master.info file and restart the mysql server. Now try to start slave and it should work.

November 18th, 2007 Replicating on two or more MySQL master database servers 1. MySQL Master-Master Replication Fails With ERROR 1200 (HY000) on Master 2.

April 20th, 2008 Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server: mysqlcheck -u root -p --auto-repair --check --optimize --all-databases mysqlcheck is available in MySQL 3.23.38 and later. mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user.

August 26th, 2006 Suddenly my Hard-disk & MySQL Server had gone read-only, thereby making this blog (because it is cached) and other sites inaccessible, including ssh access. Do you have any idea why this could have happened? A hard reboot rectified the error for now.

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.

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.

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.

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.

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".

October 23rd, 2006 First of all I want to make it clear that having a MySQL database without a password set (on your root account) is a very very bad idea. However I wanted to set it up on my home machine which has XAMPP installed.

October 23rd, 2006 .htaccess is a web server directive file populalrly used in Apache Web Server in Linux / Unix environment. In windows environment there is a simple way to enable and use .htaccess.