mysqlosx-lion

mysqld_safe command starts then stalls OSX Lion

I am running mysql 5.5.22 on OSX Lion. My problem is mysqld_safe starts up and halts at the starting position like so.

I typed in this command: mysqld_safe

120327 05:33:57 mysqld_safe Logging to '/usr/local/mysql/data/The-BatMobile.local.err'.
120327 05:33:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

The mysqld_safe program has been stalling at this last line of code for the 25 minutes now. Anyone have an idea? The google searches I've done revealed some issues with Lion but nothing on this particular issue.

Edit //

After reading the mysql error log, I discovered mysqldsafe could be already running indicated with this previous line of code:

120327 05:33:57 mysqld_safe Logging to '/usr/local/mysql/data/The-BatMobile.local.err'.
120327 05:33:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

Is my assumption correct?

Here is the error log:

21 120327 11:21:58 mysqld_safe mysqld from pid file /usr/local/mysql/data/the-      batmobile.pid ended
22 120327 11:23:06 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
23 120327 11:23:06 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
24 120327 11:23:06 [Note] Plugin 'FEDERATED' is disabled.
25 120327 11:23:06 InnoDB: The InnoDB memory heap is disabled
26 120327 11:23:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
27 120327 11:23:06 InnoDB: Compressed tables use zlib 1.2.3
28 120327 11:23:06 InnoDB: Initializing buffer pool, size = 128.0M
29 120327 11:23:06 InnoDB: Completed initialization of buffer pool
30 120327 11:23:06 InnoDB: highest supported file format is Barracuda.
31 120327 11:23:06  InnoDB: Waiting for the background threads to start
32 120327 11:23:07 InnoDB: 1.1.8 started; log sequence number 1595675
33 120327 11:23:07 [Note] Event Scheduler: Loaded 0 events
34 120327 11:23:07 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
35 Version: '5.5.22'  socket: '/tmp/mysql.sock'  port: 3306  MySQL Community Server (GPL)
Solution

  • I think I found the answer to my own question!

    When the command mysqld_safe is executed and no other line pops up after 'Starting daemon with dbs from /usr/local/mysql/data' it's working!

    120327 05:33:57 mysqld_safe Logging to '/usr/local/mysql/data/The-BatMobile.local.err'.
120327 05:33:57 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data

    I did two tests to confirm this:

    Test 1: mysqld_safe off

    I killed the mysqld_safe process and tried to log in with "mysql -u root -p" and it gave me this error.

    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2):

    Test 2: mysqld_safe: on

    It works! I used "mysql -u root -p" to login and the mysql terminal popped up!