May 2, 2012 21:27
cheers :)
May 2, 2012 21:24
0
Q: Starting MySQL produces "The server quit without updating PID file"

Burning the CodeigniterI've literally looked all over Stack Overflow, Superuser, I cannot find a solution to my problem that I'm experiencing right now, when I want to start MySQL, it produces this error: ERROR! The server quit without updating PID file (/usr/local/var/mysql/My-Username.local.pid). with the sudo ...

May 2, 2012 21:24
Woops, my bad
May 2, 2012 21:24
and i'll accept your answer
May 2, 2012 21:24
you may answer my question here
May 2, 2012 21:24
thank you so much
May 2, 2012 21:23
it's working now
May 2, 2012 21:23
aha :D
May 2, 2012 21:22
or started up anything
May 2, 2012 21:22
i didn't enter any other command
May 2, 2012 21:21
(ps axuww |grep -i sql)
May 2, 2012 21:21
RudeBoiiDevil  10162   0.0  0.0  2439020    864 s000  R+   10:21pm   0:00.00 grep -i sql
RudeBoiiDevil  10150   0.0  1.1  2690484  44052   ??  S    10:20pm   0:00.14 /usr/local/Cellar/mysql/5.5.20/bin/mysqld --basedir=/usr/local/Cellar/mysql/5.5.20 --datadir=/usr/local/var/mysql --plugin-dir=/usr/local/Cellar/mysql/5.5.20/lib/plugin --log-error=/usr/local/var/mysql/Wayne-Purton-Smiths-MacBook.local.err --pid-file=/usr/local/var/mysql/Wayne-Purton-Smiths-MacBook.local.pid
RudeBoiiDevil  10105   0.0  0.0  2439016   1728   ??  S    10:20pm   0:00.02 /bin/sh /usr/local/bin/mysqld_safe
May 2, 2012 21:21
kill: 10095: No such process
May 2, 2012 21:21
it said
May 2, 2012 21:20
when i executed
May 2, 2012 21:16
/usr/local/Cellar/mysql/5.5.20/share/man/man1/mysqlbinlog.1
/usr/local/Cellar/mysql/5.5.20/mysql-test/t/mysqldump-no-binlog.test
/usr/local/Cellar/mysql/5.5.20/mysql-test/t/mysqldump-no-binlog-master.opt
/usr/local/Cellar/mysql/5.5.20/mysql-test/t/mysqlbinlog_row_trans.test
/usr/local/Cellar/mysql/5.5.20/mysql-test/t/mysqlbinlog_row_myisam.test
/usr/local/Cellar/mysql/5.5.20/mysql-test/t/mysqlbinlog_row_innodb.test
/usr/local/Cellar/mysql/5.5.20/mysql-test/t/mysqlbinlog_row_big.test
/usr/local/Cellar/mysql/5.5.20/mysql-test/t/mysqlbinlog_row.test
May 2, 2012 21:16
heh :P
May 2, 2012 21:16
instead of whereis
May 2, 2012 21:16
locate
May 2, 2012 21:15
/usr/local/bin/mysql
May 2, 2012 21:15
how do i terminate it?
May 2, 2012 21:14
lion os x
May 2, 2012 21:14
nope
May 2, 2012 21:14
root           80454   0.0  0.2  2475256   7520 s000  T    12:35pm   0:00.05 sudo ./bin/mysqld_safe
root           80441   0.0  0.2  2475256   7520 s000  T    12:35pm   0:00.05 sudo ./bin/mysqld_safe
root           80422   0.0  0.2  2475256   7520 s000  T    12:34pm   0:00.06 sudo ./bin/mysqld_safe
_mysql         79759   0.0  1.1  2692168  47852   ??  Ss   12:24pm   0:15.41 --user=_mysql
RudeBoiiDevil   8755   0.0  0.0  2438316   1328 s000  S+   10:14pm   0:00.01 grep -i sql
May 2, 2012 21:13
ah yes
May 2, 2012 21:13
tcp4       0      0  *.587                  *.*                    LISTEN
tcp4       0      0  *.25                   *.*                    LISTEN
tcp4       0      0  *.55194                *.*                    LISTEN
tcp4       0      0  *.55191                *.*                    LISTEN
tcp4       0      0  *.55177                *.*                    LISTEN
tcp4       0      0  *.55175                *.*                    LISTEN
tcp4       0      0  *.55174                *.*                    LISTEN
May 2, 2012 21:11
I got nothing returned
May 2, 2012 21:11
:P
May 2, 2012 21:10
ffffff800ded73f0 stream 0 0 ffffff8011bc3d10 0 0 0 /tmp/mysql.sock
May 2, 2012 21:10
I did netstat | grep mysql
May 2, 2012 21:08
but i don't have another mysqld running?
May 2, 2012 21:07
120502 22:06:33 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
> 120502 22:06:33 [ERROR] Do you already have another mysqld server running on port: 3306 ?
> 120502 22:06:33 [ERROR] Aborting
>
> 120502 22:06:33  InnoDB: Starting shutdown...
> 120502 22:06:34  InnoDB: Shutdown completed; log sequence number 1595675
> 120502 22:06:34 [Note] /usr/local/Cellar/mysql/5.5.20/bin/mysqld: Shutdown complete
>
> 120502 22:06:34 mysqld_safe mysqld from pid file /usr/local/var/mysql/Wayne-Purton-Smiths-MacBook.local.pid ended
May 2, 2012 21:04
full of error logs
May 2, 2012 21:03
120502 22:03:39 mysqld_safe Logging to '/usr/local/var/mysql/Wayne-Purton-Smiths-MacBook.local.err'.
120502 22:03:39 mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
120502 22:03:43 mysqld_safe mysqld from pid file /usr/local/var/mysql/Wayne-Purton-Smiths-MacBook.local.pid ended
May 2, 2012 21:02
D:
May 2, 2012 21:02
mysql Ver 14.14 Distrib 5.5.20, for osx10.7 (i386) using readline 5.1
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Usage: mysql [OPTIONS] [database]
-?, --help Display this help and exit.
-I, --help Synonym for -?
--auto-rehash Enable automatic rehashing. One doesn't need to use
'rehash' to get table and field completion, but startup
May 2, 2012 21:02
i didn't scroll up
May 2, 2012 21:02
oh my bad
May 2, 2012 21:01
auto-rehash                       TRUE
auto-vertical-output              FALSE
character-sets-dir                (No default value)
column-type-info                  FALSE
comments                          FALSE
compress                          FALSE
debug-check                       FALSE
debug-info                        FALSE
database                          (No default value)
default-character-set             auto
delimiter                         ;
vertical                          FALSE
May 2, 2012 21:00
okay, my response of mysql --help was:
 
May 2, 2012 20:58
@JasonSalaz I noticed that github issue, chown'ing didn't help, I still get errors about the mysql.sock
May 2, 2012 20:46
nice one, but it's not the solution, thanks :)
May 2, 2012 20:46
such as APC, memcached
May 2, 2012 20:46
it's not useful when you need other extensions
May 2, 2012 20:45
ugh, i hate MAMP
May 2, 2012 20:38
what's the workaround?
May 2, 2012 20:37
okay, i'll go for 5.1 then
May 2, 2012 20:34
what version will yours work at?
May 2, 2012 20:33
yup
May 2, 2012 20:22
5.5.20 to be exact