Check whether a symlink of /var/tmp/mysql.sock is present in /tmp/. If not create it. Fix ln -s /var/tmp/mysql.sock /tmp/mysql.sock
Category: MySQL
Joomla! 3 installation freezes at creating database table using quickstart installation
This problem occurring most usually at Joomla 3.x. To solve this go to wamp\www\Your joomla folder\installation\sql\mysql and open Joomla.sql file find the term "ENGINE=InnoDB" and replace ALL with "ENGINE=MyIsam" MyIsam is more supported and compatible with Joomla. Do also the same with (sample_data.sql) file, if it's quickstart setup.
Got error -1 from storage engine SQL=INSERT INTO `ek9pi_session`
Fix On checking I could see that innodb_force_recovery was enabled in the mysql configuration file. Disabled it and then restarted the mysql service. Note: Mysql innodb force recovery may be enabled due to any innodb crashes in the server. You need to have a detailed check before disabling this.
Changing wordpress Dashboard login credentials via mysql commandline
You can change wordpress Dashboard login credentials via mysql commandline: Consider following details: Database name : test_data wp_ : As database perfix wp_users : WordPress user table User Id: 1 1. mysql >> to enter in to mysql command line; 2. use test_data; >> to use our database; 3. show tables; >> Show all tables … Continue reading Changing wordpress Dashboard login credentials via mysql commandline
Warning: mysql_connect() [function.mysql-connect]: Headers and client library minor version mismatch.
Received the following error after Mariadb installation. Warning: mysql_connect() [function.mysql-connect]: Headers and client library minor version mismatch. Headers:50318 Library:50096 in /home/bunny/public_html/books/includes/functions/database.php on line 19 Fix Added the following line to /var/cpanel/easy/apache/rawopts/all_php5 : --with-mysqli=mysqlnd
MySQL password length checker
script to check MySQL password length of users. mysql -e "SELECT user, Length(Password) FROM mysql.user;" | grep -E "16" | head
MySQL upgrade issue : /etc/init.d/mysql was gone
Tried to upgrade mysql 5.0 to 5.5 and then to 5.6 after 5.5 upgrade tried 5.6 all were gone /etc/init.d/mysql was gone Fix moved the file /var/lib/mysql/RPM_UPGRADE_MARKER and then /scripts/check_cpanel_rpms --fix
To enable slow query log in MySQL
Create the file mysql-slow.log in /var/log/ directory. Add the following entries in /etc/my.cnf log-slow-queries = /var/log/mysql-slow.log long_query_time = 1 restart mysql service.
How to disable STRICT_TRANS_TABLES in mysql
Fix Add below line in /usr/my.cnf and restart mysql sql_mode=NO_ENGINE_SUBSTITUTION
MySQL getting restarted continuously
MySQL was getting restarted every 5 min. No cron was there. Also no particular errors in error log. Fix Fixed the issue by running cPanel rpm fix. # /scripts/check_cpanel_rpms I had that command repair the RPMs which resolved the issue.
BunnyTech Blog 