Blog Archives for category mysql

HAProxy setup for mysql load balancing

Available Servers —————– HAProxy: 10.0.0.100 mysql1 : 10.0.0.1 mysql2 : 10.0.0.2 Before setup, make sure that mysql servers are working… Continue reading »

ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number

I got the following error when giving mysql privilege to my database ERROR 1372 (HY000): Password hash should be a… Continue reading »

PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine ‘InnoDB’

I got the following error in all my drupal sites PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286  Unknown table… Continue reading »

cPHulk Error while connecting to MySQL

cphulk Error while connecting to MySQL, cPHulk Mysql is currently disabled. To enable mysql go to: Service Manager, Error while… Continue reading »

cphulkd rejected registration attempt for webmaild

Webmail was rejecting logins and while checking cpanel error logs, got the following. ========= cphulkd rejected registration attempt for webmaild… Continue reading »

WordPress database error MySQL server has gone away for query SELECT

One of the wordpresss site in the server was not loading, but it loads fine while disabling CSF. Checking the… Continue reading »

DB not Listed in Cpanel after Mysql upgrade

When mysql is upgraded, the DB cache and dbusermap in cpanel may be lost. We need to recreate that /usr/local/cpanel/bin/setupdbmap… Continue reading »

Can’t connect to local MySQL server through socket ‘/var/tmp/mysql.sock’ (2)

When there is a database error “Editing Can’t connect to local MySQL server through socket ‘/var/tmp/mysql.sock’ (2)” for a domain,… Continue reading »

Horde : loops back to login page

mysql mysql> use horde; mysql> drop table horde_sessionhandler; mysql> CREATE TABLE horde_sessionhandler ( session_id VARCHAR(32) NOT NULL, session_lastmodified INT NOT… Continue reading »

Enable slow queries in mysql

log-slow-queries=/var/lib/mysql/slow.log touch /var/lib/mysql/slow.log chmod 660 /var/lib/mysql/slow.log chown mysql:mysql /var/lib/mysql/slow.log