Last active
August 29, 2015 14:22
-
-
Save jamesmehorter/3800832574f405938a43 to your computer and use it in GitHub Desktop.
VVV MySQL Won't start
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# | |
# 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/ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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