MYSQL server no longer connects (Ubuntu 16.04/Drupal)

For some unknown reason (2 days before this posting) my MySql server (pre- 5.7) decided to start playing up, stop working and I couldn't connect to my DBs's I'm running a few Drupal 7.34 projects. I've spent some 2 days trying to resolve it, re-installed Mysql from Synaptic and CLI, upgrading from Ubuntu 15.10 to 16.04 with no resolve. I simply just want to get it fixed today so I can carry on with my project tasks.

I conclude that it's primarily an MySql setup issue but I'm stumped as to what I need to do easily and next to get the damn thing back to how it was before. I presumed all auto 'upgrades' where disabled, but I'm not sure if Mysql has upgraded behind my back or the server has crashed or corrupted. I have Mysql workbench installed also.

Please help! Thanks.

I'm now running mysql Ver 14.14 Distrib 5.7.12, for Linux (i686),

cannot connect to the mysql nor phpmyadmin via the browser and get the message in the CLI:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) and similar error was in Drupal trying to connect.

What do I need to do to simply get the whole thing running again?

systemctl status mysql.service:

mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: activating (start-post) (Result: exit-code) since Wed 2016-06-15 12:38:16 BST; 15s ago Process: 14962 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE) Process: 14958 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 14962 (code=exited, status=1/FAILURE); : 14963 (mysql-systemd-s) CGroup: /system.slice/mysql.service └─control ├─14963 /bin/bash /usr/share/mysql/mysql-systemd-start post └─15027 sleep 1

Jun 15 12:38:16 nexus systemd[1]: Starting MySQL Community Server... Jun 15 12:38:18 nexus systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE

Last mysql log entry prior to this posting:

2016-06-15T11:09:17.754371Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000) 2016-06-15T11:09:17.754456Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000) 2016-06-15T11:09:17.927349Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2016-06-15T11:09:17.928056Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.12-0ubuntu1) starting as process 9026 ... 2016-06-15T11:09:17.933056Z 0 [Note] InnoDB: PUNCH HOLE support available 2016-06-15T11:09:17.933100Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-06-15T11:09:17.933108Z 0 [Note] InnoDB: Uses event mutexes 2016-06-15T11:09:17.933114Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2016-06-15T11:09:17.933120Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2016-06-15T11:09:17.933125Z 0 [Note] InnoDB: Using Linux native AIO 2016-06-15T11:09:17.933424Z 0 [Note] InnoDB: Number of pools: 1 2016-06-15T11:09:17.933523Z 0 [Note] InnoDB: Not using CPU crc32 instructions 2016-06-15T11:09:17.941930Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2016-06-15T11:09:17.951822Z 0 [Note] InnoDB: Completed initialization of buffer pool 2016-06-15T11:09:17.953732Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-06-15T11:09:17.966304Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2016-06-15T11:09:18.059790Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-06-15T11:09:18.059888Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-06-15T11:09:18.352212Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-06-15T11:09:18.356337Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-06-15T11:09:18.356399Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-06-15T11:09:18.357249Z 0 [Note] InnoDB: Waiting for purge to start 2016-06-15T11:09:18.407579Z 0 [Note] InnoDB: 5.7.12 started; log sequence number 198107954204 2016-06-15T11:09:18.407757Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2016-06-15T11:09:18.407841Z 0 [Note] Plugin 'FEDERATED' is disabled. 2016-06-15T11:09:18.408028Z 0 [Note] InnoDB: Buffer pool(s) load completed at 160615 12:09:18 2016-06-15T11:09:18.409283Z 0 [ERROR] Function 'archive' already exists 2016-06-15T11:09:18.409382Z 0 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'. 2016-06-15T11:09:18.409396Z 0 [ERROR] Function 'blackhole' already exists 2016-06-15T11:09:18.409403Z 0 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'. 2016-06-15T11:09:18.409410Z 0 [ERROR] Function 'federated' already exists 2016-06-15T11:09:18.409416Z 0 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'. 2016-06-15T11:09:18.409423Z 0 [ERROR] Function 'innodb' already exists 2016-06-15T11:09:18.409429Z 0 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'. 2016-06-15T11:09:18.409589Z 0 [ERROR] unknown variable 'myisam-recover=BACKUP' 2016-06-15T11:09:18.409598Z 0 [ERROR] Aborting

2016-06-15T11:09:18.409606Z 0 [Note] Binlog end 2016-06-15T11:09:18.409662Z 0 [Note] Shutting down plugin 'ngram' 2016-06-15T11:09:18.409669Z 0 [Note] Shutting down plugin 'ARCHIVE' 2016-06-15T11:09:18.409675Z 0 [Note] Shutting down plugin 'partition' 2016-06-15T11:09:18.409680Z 0 [Note] Shutting down plugin 'BLACKHOLE' 2016-06-15T11:09:18.409686Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL' 2016-06-15T11:09:18.409691Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2016-06-15T11:09:18.409696Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2016-06-15T11:09:18.409712Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2016-06-15T11:09:18.409717Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2016-06-15T11:09:18.409722Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2016-06-15T11:09:18.409727Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2016-06-15T11:09:18.409732Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2016-06-15T11:09:18.409737Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2016-06-15T11:09:18.409742Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2016-06-15T11:09:18.409747Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2016-06-15T11:09:18.409752Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2016-06-15T11:09:18.409756Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2016-06-15T11:09:18.409761Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2016-06-15T11:09:18.409766Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2016-06-15T11:09:18.409771Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2016-06-15T11:09:18.409776Z 0 [Note] Shutting down plugin 'INNODB_METRICS' 2016-06-15T11:09:18.409781Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO' 2016-06-15T11:09:18.409785Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2016-06-15T11:09:18.409790Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2016-06-15T11:09:18.409795Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2016-06-15T11:09:18.409800Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2016-06-15T11:09:18.409805Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2016-06-15T11:09:18.409810Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2016-06-15T11:09:18.409814Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM' 2016-06-15T11:09:18.409819Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2016-06-15T11:09:18.409824Z 0 [Note] Shutting down plugin 'INNODB_CMP' 2016-06-15T11:09:18.409829Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2016-06-15T11:09:18.409833Z 0 [Note] Shutting down plugin 'INNODB_LOCKS' 2016-06-15T11:09:18.409838Z 0 [Note] Shutting down plugin 'INNODB_TRX' 2016-06-15T11:09:18.409843Z 0 [Note] Shutting down plugin 'InnoDB' 2016-06-15T11:09:18.409910Z 0 [Note] InnoDB: FTS optimize thread exiting. 2016-06-15T11:09:18.410102Z 0 [Note] InnoDB: Starting shutdown... 2016-06-15T11:09:18.510621Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2016-06-15T11:09:18.511185Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 160615 12:09:18 2016-06-15T11:09:20.155379Z 0 [Note] InnoDB: Shutdown completed; log sequence number 198107954223 2016-06-15T11:09:20.157187Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2016-06-15T11:09:20.157281Z 0 [Note] Shutting down plugin 'MEMORY' 2016-06-15T11:09:20.157341Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2016-06-15T11:09:20.157397Z 0 [Note] Shutting down plugin 'MRG_MYISAM' 2016-06-15T11:09:20.157403Z 0 [Note] Shutting down plugin 'MyISAM' 2016-06-15T11:09:20.157416Z 0 [Note] Shutting down plugin 'CSV' 2016-06-15T11:09:20.157422Z 0 [Note] Shutting down plugin 'sha256_password' 2016-06-15T11:09:20.157426Z 0 [Note] Shutting down plugin 'mysql_native_password' 2016-06-15T11:09:20.158122Z 0 [Note] Shutting down plugin 'binlog' 2016-06-15T11:09:20.158270Z 0 [Note] /usr/sbin/mysqld: Shutdown complete