Environment Operating System : Ubuntu Server 16.10 Yakkety Yak 64-bit Server Edition MySQL Server Version : Ver 14.14 Distrib 5.7.16, for Linux (x86_64) Slove MySQL Server Keeps Stopping Unexpectedly Today I upgrade my server to Ubuntu 16.10, but MySQL server…
Troubleshooting Homebrew MySQL on OS X
I get MySQL upgrade to 5.7.9 from Homebrew on OS X El Capitan (10.11.1), and got ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when start the service. $ brew upgrade mysql ==> Downloading https://homebrew.bintray.com/bottles/mysql-5.7.9.el_capitan.bott…
Enable Remote Access to MySQL Server on Windows
On Linux, we can easily enable remote access to MySQL server, here is an article talking about that. On Windows, the approach is different. Here's the steps: Open a DOS command prompt on the server. Run the following command from…
Fix ERROR InnoDB: The InnoDB memory heap is disabled
Wiki InnoDB is a storage engine for MySQL. MySQL 5.5 and later use it by default. It provides the standard ACID-compliant transaction features, along with foreign key support (Declarative Referential Integrity). It is included as standard in most binaries distributed…