Skip to content

Instantly share code, notes, and snippets.

@jamesmehorter
Last active August 29, 2015 14:22
Show Gist options
  • Save jamesmehorter/3800832574f405938a43 to your computer and use it in GitHub Desktop.
Save jamesmehorter/3800832574f405938a43 to your computer and use it in GitHub Desktop.
VVV MySQL Won't start
# FILE LOCATION/NAME: /etc/apparmor.d/abstractions/user-tmp
# per-user tmp directories
owner @{HOME}/tmp/** rwkl,
owner @{HOME}/tmp/ rw,
# global tmp directories
owner /var/tmp/** rwkl,
/var/tmp/ rw,
owner /tmp/** rwkl,
/tmp/ rw,
# Allow MySQL to write freely to /home/tmp/
owner /home/tmp/** rwkl,
/home/tmp/ rw,
root@vvv:/# mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
root@vvv:/# sudo /etc/init.d/mysql start
* Starting MySQL database server mysqld [fail]
# FILE LOCATION/NAME: /var/log/mysql/error.log
150603 15:06:11 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
150603 15:08:40 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150603 15:08:40 [Note] /usr/sbin/mysqld (mysqld 5.5.43-0ubuntu0.14.04.1) starting as process 8427 ...
150603 15:08:40 [Note] Plugin 'FEDERATED' is disabled.
150603 15:08:40 InnoDB: The InnoDB memory heap is disabled
150603 15:08:40 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150603 15:08:40 InnoDB: Compressed tables use zlib 1.2.8
150603 15:08:40 InnoDB: Using Linux native AIO
^G/usr/sbin/mysqld: Can't create/write to file '/tmp/ibP2qLRO' (Errcode: 13)
150603 15:08:40 InnoDB: Error: unable to create temporary file; errno: 13
150603 15:08:40 [ERROR] Plugin 'InnoDB' init function returned error.
150603 15:08:40 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
150603 15:08:40 [ERROR] Unknown/unsupported storage engine: InnoDB
150603 15:08:40 [ERROR] Aborting
150603 15:08:40 [Note] /usr/sbin/mysqld: Shutdown complete
150603 15:08:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.
#
# For explanations see
# http://dev.mysql.com/doc/mysql/en/server-system-variables.html
# This will be passed to all mysql clients
# It has been reported that passwords should be enclosed with ticks/quotes
# especially if they contain "#" chars...
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
# Here is entries for some specific programs
# The following values assume you have at least 32M ram
# This was formally known as [safe_mysqld]. Both versions are currently parsed.
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
[mysqld]
#
# * Basic Settings
#
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 0.0.0.0
#
#
# * Fine Tuning
#
max_allowed_packet = 128M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
# As of 5.1 you can enable the log at runtime!
#general_log_file = /var/log/mysql/mysql.log
#general_log = 1
#
# Error log - should be very few entries.
#
log_error = /var/log/mysql/error.log
#
# Here you can see queries with especially long duration
#log_slow_queries = /var/log/mysql/mysql-slow.log
#long_query_time = 2
#log-queries-not-using-indexes
[mysqldump]
quick
quote-names
max_allowed_packet = 128M
[mysql]
#no-auto-rehash # faster start of mysql but no tab completion
[isamchk]
#
# * IMPORTANT: Additional settings that can override those from this file!
# The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/
root@vvv:/# ls -alh
total 88K
drwxr-xr-x 24 root root 4.0K Jun 3 14:32 .
drwxr-xr-x 24 root root 4.0K Jun 3 14:32 ..
drwxr-xr-x 2 root root 4.0K May 22 20:41 bin
drwxr-xr-x 3 root root 4.0K May 22 20:41 boot
drwxr-xr-x 3 root root 4.0K May 27 00:57 build
drwxr-xr-x 13 root root 3.8K Jun 3 15:02 dev
drwxr-xr-x 108 root root 4.0K Jun 3 14:41 etc
drwxr-xr-x 4 root root 4.0K May 27 00:52 home
lrwxrwxrwx 1 root root 33 May 22 20:40 initrd.img -> boot/initrd.img-3.13.0-53-generic
drwxr-xr-x 22 root root 4.0K May 22 21:19 lib
drwxr-xr-x 2 root root 4.0K May 22 20:39 lib64
drwx------ 2 root root 16K May 22 20:41 lost+found
drwxr-xr-x 2 root root 4.0K May 22 20:39 media
drwxr-xr-x 2 root root 4.0K Apr 10 2014 mnt
drwxr-xr-x 2 root root 4.0K May 22 20:39 opt
dr-xr-xr-x 160 root root 0 Jun 3 14:32 proc
drwx------ 7 root root 4.0K Jun 3 15:10 root
drwxr-xr-x 23 root root 900 Jun 3 14:42 run
drwxr-xr-x 2 root root 4.0K May 22 21:19 sbin
drwxr-xr-x 6 root root 4.0K May 27 00:53 srv
dr-xr-xr-x 13 root root 0 Jun 3 14:32 sys
drwxrwxrwt 109 root root 3.7K Jun 3 2015 tmp
drwxr-xr-x 11 root root 4.0K May 27 00:58 usr
drwxr-xrwx 1 vagrant vagrant 612 May 27 00:51 vagrant
drwxr-xr-x 13 root root 4.0K May 27 00:53 var
lrwxrwxrwx 1 root root 30 May 22 20:40 vmlinuz -> boot/vmlinuz-3.13.0-53-generic
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment