MYSQL will not start after upgrading to version 2.15


(Dawn ) #1

I was able to successfully upgrade to 2.15, but after running overnight MySQL quit running and will not restart. I am getting the following error when checking the status of MySQL in Linux. 'Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ Check that mysqld is running and that the socket: ‘/tmp/mysql.sock’ exists!. I also see the following error in the browser SQLSTATE[HY000] [2002] Connection refused.

This is my second attempt to upgrade to this version with the same results.

Note: I am doing an incremental upgrade from version 1.12.


#2

Which version of mysql? Did you by chance upgrade that software as well? Also, /tmp/mysql.sock is an unusual (and not terribly secure) place for the socket to exist. Is that how it is configured in /etc/my.cnf? Are you able to connect to mysql via the root user or mysql user on the server mysqld is (supposedly) running?


(Dawn ) #3

MySQL Version 5.6.12

No I did not upgrade mysql and I am able to login to mysql.

I’m not finding my.cnf in /etc, Iif that makes a difference) it is located in the /mysql directory see copy of below:

[mysqld]

Remove leading # and set to the amount of RAM for the most important data

cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.

innodb_buffer_pool_size = 128M

Remove leading # to turn on a very important data integrity option: logging

changes to the binary log between backups.

log_bin

These are commonly set, remove the # and set as required.

basedir = /analytics/mysql
datadir = /analytics/mysql/data

port = …

server_id = …

socket = …

Remove leading # to set options mainly useful for reporting servers.

The server defaults are faster for transactions and fast SELECTs.

Adjust sizes as needed, experiment to find the optimal values.

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES