Category Archives: MySQL

InnoDB Corruption and Recovery

Databases get corrupted for many reasons. In my case, our  hard drive went down during writes to the database from a power failure. InnoDB corruption can cause all of the databases running on that server to become inaccessible. My server is … Continue reading

Posted in Linux, MySQL | Tagged , | Leave a comment

Set Password Policy in Mysql 5.6

——————————————————————————————- 1) INSTALL PLUGIN loads the plugin, and also registers it in the mysql. plugins table to cause the plugin to be loaded for each subsequent normal server startup. ——————————————————————————————- mysql> INSTALL PLUGIN validate_password SONAME ‘validate_password.so’; ——————————————————————————————- 2) Edit my.cnf … Continue reading

Posted in Linux, MySQL | Tagged , | Leave a comment

Resolving “Access denied; you need (at least one of) the PROCESS privilege(s) for this operation”

I do have logged in with a mysql user easypay who has all privileges on a DB easypay and was executing the command show engine innodb status Mysql gave error as [Error Code: 1227, SQL State: 42000] Access denied; you … Continue reading

Posted in Linux, MySQL | Leave a comment

Fix for InnoDB: ERROR: the age of the last checkpoint is …

I recently have to restore production DB to local environment and I saw mysql log giving with bunch of errors like this InnoDB: largest such row. 150817 23:22:56  InnoDB: ERROR: the age of the last checkpoint is 9440934, InnoDB: which … Continue reading

Posted in Linux, MySQL | Leave a comment

Setup mysql master slave replication over ssl

Master Server : 10.10.1.1 Slave Server : 10.10.1.2 Confirm your mysql server is compiled/enabled to support ssl connections using the following command # mysql -u root -p mysql > show variables like ‘%ssl%’ ; If you are getting an output … Continue reading

Posted in Linux, MySQL | Leave a comment

HOWTO Virtual Mail Hosting on CentOS 6.x – Postfix MySQL Dovecot PostfixAdmin Amavisd-new Spamassassin Clamav DKIM SPF

Introduction This is an advanced email server configuration. This configuration will allow you to serve multiple domains on one server. This howto will allow you to setup a server that is one of four mail server types: Mail server with … Continue reading

Posted in Apache, DNS, Linux, Mail server, MySQL, PHP, Postfix | Leave a comment

Reset Mysql Root Password

 Login to root prompt Stop the mysql Server # /etc/init.d/mysql stop   start the Mysql server in safe mode # /usr/local/mysql/bin/safe_mysqld –user=mysql –skip-grant-tables –skip-networking &  Reset password # /usr/local/mysql/bin/mysqladmin -u root flush-privileges password “newpassword” sometime the above command would not … Continue reading

Posted in MySQL | Leave a comment

Setup Master-Master Replication in MySQL Server

MySQL Master-Slave replication is to set up slave server to update immediately as soon as changes done in Master server. But it will not update Master if there are any changes done on slave server. This article will help you … Continue reading

Posted in MySQL | Leave a comment

Setup Master-Slave Replication in MySQL Server

MySQL replication allows you to have multiple copies of data on many systems and data is automatically copied from one database (Master) to another database (Slave). If one server goes down, the clients still can access the data from another … Continue reading

Posted in MySQL | Leave a comment