Category: MySQL

  • Fix a broken mysql

    If your mysql seems broken and giving errors like: # service mysql start start: Job failed to start or ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) Or if you try to recreate databases with mysqlinstalldb: … … ERROR: 1 Can’t create/write to file ‘./mysql/db.frm’ (Errcode: 13) 041226 xx:xx:xx /usr/libexec/mysqld: […]

  • WordPress Database Error: You have an error in your SQL syntax

    When I used a slideshow plugin on AamJanata, I got this error. WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘orderorder` INT(11) NOT NULL DEFAULT ‘0” at line 1] ALTER TABLE wp_gallery_slides CHANGE COLUMN order […]