How to Fix 'An error occurred while installing mysql2 (0.5.3), and Bundler cannot continue.' in bundle install

How to fix mysql2 gem's native extension build error by pointing bundler to openssl's ldflags.

Procedure to Install MySQL5.5 from Source Code on CentOS6.3

Installing MySQL 5.5 from source on CentOS 6.3 with cmake, from build to initial setup and startup troubleshooting.

MySQL Setup Procedure for Specific Version [Docker Edition]

How to run a specific MySQL version on Docker, including the GRANT tweaks Docker for Mac needs.

[Doctrine] How to Use Subqueries [Symfony1.4]

A short memo on using Doctrine's createSubquery() for subqueries in Symfony 1.4.

[Mac] Installing MySQL with Homebrew

Installing MySQL via Homebrew on macOS, setting up auto-start, and logging in as root.

[MySQL] Startup Fails with default-character-set

Fixing a MySQL 5.5 startup failure by switching my.cnf to character-set-server=utf8.

[MySQL] File './mysql-bin.index' not found (Errcode: 13)

Fixing the MySQL Errcode: 13 error on mysql-bin.index by giving the mysql user ownership via chown.

Change MySQL character encoding to UTF8

Steps to switch MySQL 5.7's character encoding to UTF8 via my.cnf.

[MySQL] Check the size of database and tables

SQL to check MySQL database and table sizes, and how to wrap it as a stored procedure.

Resolve Japanese character corruption in MySQL CLI with SET character_set_results=utf8mb4;

Fixing Japanese mojibake in the MySQL CLI with SET character_set_results=utf8mb4;.

[MySQL] Execute Queries from Command Line and Output to CSV File

Piping mysql -e output through sed to save query results as a CSV file.

[MySQL] CMake Error: Internal CMake error, TryCompile configure of cmake failed

Fixing MySQL source build errors on CentOS 6.3 by installing gcc-c++ and bison.

[MySQL] User Deletion Should Be Done with DROP USER, Not DELETE Statement

Why user deletion in MySQL must use DROP USER, not a DELETE statement.

[MySQL] SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

The MySQL 'Got error 28 from storage engine' error is caused by a full disk.

[MySQL] How to Solve ERROR 1045 (28000): Access denied for user

Granting the FILE privilege to fix MySQL's Access denied error on SELECT INTO OUTFILE.

[MySQL] How to configure my.cnf (Mac + Homebrew Edition)

How to configure my.cnf for MySQL installed with Homebrew on Mac.

MySQL Query to Check Data Size of DB and Tables

SQL queries to check MySQL DB and table sizes for Aurora storage cost estimation.

[MySQL] Query Log File Cannot Be Specified Error / [ERROR] Could not use /var/log/myquery.log for logging (error 13)

Resolving MySQL's 'Could not use ... for logging (error 13)' startup failure via my.cnf.

[MySQL] Getting stuck with reserved words - ERROR 1064 (42000): 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 'xxx' at line 1

MySQL threw ERROR 1064 on a query because the column name primary is a reserved word.

[Oracle] DESCRIBE Command to Check Table Definition

Oracle DESCRIBE plus the equivalent table-definition commands for MySQL and PostgreSQL.

[Oracle] Displaying Table List

Listing user tables in Oracle, MySQL, and PostgreSQL, side by side.

[PHP][PEAR] Solution for 'Column count of mysql.proc is wrong.' Error

Digging up the real cause behind a PEAR::DB "unknown error" via getDebugInfo().

Shopify Uses MySQL as Their Database

Shopify uses MySQL, but you can't connect externally — migration means CSV export or the API.

[Error] Invalid row key specified: ~ , referred to in ~

Fixing Symfony 1.4 `Invalid row key specified` fixture errors tied to foreign key relations.

[WordPress] Couldn't Edit Category from Admin Panel, So Resolved by Updating Database

Working around a WordPress category permission error by updating wp_terms directly in MySQL.

Migrated WordPress from CORESERVER to Sakura VPS

A rough memo of migrating WordPress from CORESERVER to Sakura VPS, centered on the DB dump and import.

WordPress files and database automatic backup and upload to Google Drive

Automating WordPress file and MySQL backups to Google Drive with the gdrive CLI and cron.

Steps to Build WordPress Environment with Nginx + php-fpm + MySQL on CentOS 6.3 (Sakura VPS)

Building a WordPress environment with Nginx + php-fpm + MySQL on Sakura VPS running CentOS 6.3.

WordPress Server Migration Procedure

A memo on migrating a WordPress site between servers via mysqldump and tar.