Geek asks and answers

Problems with mysql | ERROR! Server shuts down without updating PID file

Any ideas?

Joshs-MacBook-Pro:cdwhp joshc$ mysql.server start
Starting MySQL
.. ERROR! The server quit without updating PID file (/usr/local/var/mysql/Joshs-MacBook-Pro.local.pid).

Error logs

120927 13:08:35 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
120927 13:08:36 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
120927 13:08:36 InnoDB: The InnoDB memory heap is disabled
120927 13:08:36 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120927 13:08:36 InnoDB: Compressed tables use zlib 1.2.5
120927 13:08:36 InnoDB: Initializing buffer pool, size = 128.0M
120927 13:08:36 InnoDB: Completed initialization of buffer pool
120927 13:08:36 InnoDB: highest supported file format is Barracuda.
120927 13:08:36  InnoDB: Waiting for the background threads to start
120927 13:08:37 InnoDB: 1.1.8 started; log sequence number 9531786
120927 13:08:37 [ERROR] /usr/local/Cellar/mysql/5.5.27/bin/mysqld: unknown variable 'default-character-set=utf8'
120927 13:08:37 [ERROR] Aborting

120927 13:08:37  InnoDB: Starting shutdown...
120927 13:08:37  InnoDB: Shutdown completed; log sequence number 9531786
120927 13:08:37 [Note] /usr/local/Cellar/mysql/5.5.27/bin/mysqld: Shutdown complete

120927 13:08:37 mysqld_safe mysqld from pid file /usr/local/var/mysql/Joshs-MacBook-Pro.local.pid ended
+5
source share
7 answers

A complete reinstall of mysql solved this problem in my case:

brew uninstall mysql
rm -Rf /usr/local/var/mysql
brew install mysql
mysql.server start
+37
source

.

sudo mysql.server start

( su)

mysql.server start

, -.

+5

, , , mysql, . ! PID (/usr/local/mysql/data/[NAS].pid).

,

sudo kill 10191 - mysql

mysql, . , - .

+3

bogon.log

InnoDB: innodb_system 'ibdata1' . ! 2016-03-27T14: 45: 36.200398Z 0 [] InnoDB: redo./ib_logfile0 '. . . `

delete ib* mysql.server restart,

+1

. - YourComputerName.pid "YourComputerName.err" /usr/local/mysql/data _mysql. sql /usr/local/mysql/support-files/mysql.server start

0

/usr/local/var/mysql/*********.local.err mysql.server start

0
source

More articles:


All Articles