I recently tried to run a basic MySQL command. Then I got the following response:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I then figured out that MySQL wasn't running. So I tried to start it and I got the following response: start: Job failed to start
I then I tried the following command: sudo -u mysql mysqld
Then got the following output:
160331 21:09:35 [Note] mysqld (mysqld 5.5.47-0ubuntu0.14.04.1-log) starting as process 6929 ...
160331 21:09:35 [Warning] Using unique option prefix myisam_recover instead of myisam-recover-options is deprecated and will be removed in a future release. Please use the full name instead.
160331 21:09:35 [Note] Plugin 'FEDERATED' is disabled.
160331 21:09:35 [ERROR] Function 'innodb' already exists
160331 21:09:35 [Warning] Couldn't load plugin named 'innodb' with soname 'ha_innodb.so'.
160331 21:09:35 [ERROR] Function 'federated' already exists
160331 21:09:35 [Warning] Couldn't load plugin named 'federated' with soname 'ha_federated.so'.
160331 21:09:35 [ERROR] Function 'blackhole' already exists
160331 21:09:35 [Warning] Couldn't load plugin named 'blackhole' with soname 'ha_blackhole.so'.
160331 21:09:35 [ERROR] Function 'archive' already exists
160331 21:09:35 [Warning] Couldn't load plugin named 'archive' with soname 'ha_archive.so'.
160331 21:09:35 InnoDB: The InnoDB memory heap is disabled
160331 21:09:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160331 21:09:35 InnoDB: Compressed tables use zlib 1.2.8
160331 21:09:35 InnoDB: Using Linux native AIO
160331 21:09:35 InnoDB: Initializing buffer pool, size = 256.0M
160331 21:09:35 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!
160331 21:09:35 [ERROR] Plugin 'InnoDB' init function returned error.
160331 21:09:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160331 21:09:35 [ERROR] mysqld: unknown variable 'log_slow_verbosity=query_plan'
160331 21:09:35 [ERROR] Aborting
160331 21:09:35 [Note] mysqld: Shutdown complete
Does anybody have any ideas what's causing it? I see that a bunch of plugins already exist. But I'm a newbie to SQL.
/etc/my.cnf
. What do you see there? Have you been able to successfully use MySQL previously?my.cnf
configuration file from another system as opposed to the file being one you got when you installed MySQL? I added information to my post below about thelog_slow_verbosity
error, but its presence makes me wonder where the configuration file you are using orginated.