Pages
Archives
Categories
Blogroll
Live Traffic Feed.
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
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
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
2 Comments
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