Skip to content

Instantly share code, notes, and snippets.

Created July 15, 2014 01:48
Show Gist options
  • Save anonymous/186a8cab44a0a86f96e8 to your computer and use it in GitHub Desktop.
Save anonymous/186a8cab44a0a86f96e8 to your computer and use it in GitHub Desktop.
Error message when installing MySQL Server on Ubuntu 14.04 (/var/log/syslog)
Jul 15 01:41:29 hostname mysqld_safe[12809]:
Jul 15 01:41:29 hostname mysqld_safe[12809]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Jul 15 01:41:29 hostname mysqld_safe[12809]: To do so, start the server, then issue the following commands:
Jul 15 01:41:29 hostname mysqld_safe[12809]:
Jul 15 01:41:29 hostname mysqld_safe[12809]: /usr/bin/mysqladmin -u root password 'new-password'
Jul 15 01:41:29 hostname mysqld_safe[12809]: /usr/bin/mysqladmin -u root -h hostname password 'new-password'
Jul 15 01:41:29 hostname mysqld_safe[12809]:
Jul 15 01:41:29 hostname mysqld_safe[12809]: Alternatively you can run:
Jul 15 01:41:29 hostname mysqld_safe[12809]: /usr/bin/mysql_secure_installation
Jul 15 01:41:29 hostname mysqld_safe[12809]:
Jul 15 01:41:29 hostname mysqld_safe[12809]: which will also give you the option of removing the test
Jul 15 01:41:29 hostname mysqld_safe[12809]: databases and anonymous user created by default. This is
Jul 15 01:41:29 hostname mysqld_safe[12809]: strongly recommended for production servers.
Jul 15 01:41:29 hostname mysqld_safe[12809]:
Jul 15 01:41:29 hostname mysqld_safe[12809]: See the manual for more instructions.
Jul 15 01:41:29 hostname mysqld_safe[12809]:
Jul 15 01:41:29 hostname mysqld_safe[12809]: Please report any problems at http://bugs.mysql.com/
Jul 15 01:41:29 hostname mysqld_safe[12809]:
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 [Note] Plugin 'FEDERATED' is disabled.
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: The InnoDB memory heap is disabled
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: Compressed tables use zlib 1.2.8
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: Using Linux native AIO
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: Initializing buffer pool, size = 128.0M
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: Completed initialization of buffer pool
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: highest supported file format is Barracuda.
Jul 15 01:41:29 hostname mysqld_safe[12840]: 140715 1:41:29 InnoDB: Waiting for the background threads to start
Jul 15 01:41:30 hostname mysqld_safe[12840]: 140715 1:41:30 InnoDB: 5.5.37 started; log sequence number 1595675
Jul 15 01:41:30 hostname mysqld_safe[12840]: 140715 1:41:30 InnoDB: Starting shutdown...
Jul 15 01:41:31 hostname mysqld_safe[12840]: 140715 1:41:31 InnoDB: Shutdown completed; log sequence number 1595675
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 [Note] Plugin 'FEDERATED' is disabled.
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: The InnoDB memory heap is disabled
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: Compressed tables use zlib 1.2.8
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: Using Linux native AIO
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: Initializing buffer pool, size = 128.0M
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: Completed initialization of buffer pool
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: highest supported file format is Barracuda.
Jul 15 01:41:31 hostname mysqld_safe[12865]: 140715 1:41:31 InnoDB: Waiting for the background threads to start
Jul 15 01:41:32 hostname mysqld_safe[12865]: 140715 1:41:32 InnoDB: 5.5.37 started; log sequence number 1595675
Jul 15 01:41:32 hostname mysqld_safe[12865]: ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
Jul 15 01:41:32 hostname mysqld_safe[12865]: 140715 1:41:32 [ERROR] Aborting
Jul 15 01:41:32 hostname mysqld_safe[12865]:
Jul 15 01:41:32 hostname mysqld_safe[12865]: 140715 1:41:32 InnoDB: Starting shutdown...
Jul 15 01:41:33 hostname mysqld_safe[12865]: 140715 1:41:33 InnoDB: Shutdown completed; log sequence number 1595675
Jul 15 01:41:33 hostname mysqld_safe[12865]: 140715 1:41:33 [Note] /usr/sbin/mysqld: Shutdown complete
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment