Mac OS X 10.4 /var/mysql/mysql.sock Missing
Date: August 26, 2009 04:02PM
I'm somewhat green at the command line. My new MySQL installation isn't starting and I think that I have a permissions issue. I would greatly appreciate any pointers towards how I can correct this!
I just installed MySQL 5.1.37 on an Xserve running Tiger Server, 10.4.11. The PKG installer failed so I used the Apple command line utility "installer" to run the installer. Before installing, I used ps -ax to look to see if any mysql processes were running, there weren't any. I also deleted any previous mysql receipt files from within /Library/Receipts
There had been a previous installation of MySQL 5.0.67 running on this server, but it wouldn't start after I did an Apple Software Update, so I monkeyed around and probably deleted some files that I shouldn't have, so then I decided to try to delete as many MySQL files as possible and do a fresh installation from the PKG installer from Sun/MySQL's website.
So I became su and tried to start via /usr/local/mysql/bin/mysqld_safe --u=mysql &
This failed, with Terminal output being:
Starting mysqld daemon with databases from /var/mysql
STOPPING server from pid file /var/mysql/xserve.pid
Doing some digging, I found an error file at /usr/local/mysql/data/xserve.err
I did a cat on this and found:
090826 13:40:24 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data
090826 13:40:24 [Warning] The --skip-thread-priority startup option is deprecated and will be removed in MySQL 7.0. MySQL 6.0 and up do not give threads different priorities.
090826 13:40:24 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive
090826 13:40:24 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=xserve-bin' to avoid this problem.
090826 13:40:25 [Note] Plugin 'FEDERATED' is disabled.
090826 13:40:27 InnoDB: Started; log sequence number 0 44233
090826 13:40:28 [ERROR] Can't start server : Bind on unix socket: Permission denied
090826 13:40:28 [ERROR] Do you already have another mysqld server running on socket: /var/mysql/mysql.sock ?
090826 13:40:28 [ERROR] Aborting
090826 13:40:28 InnoDB: Starting shutdown...
090826 13:40:29 InnoDB: Shutdown completed; log sequence number 0 44233
090826 13:40:29 [Warning] Forcing shutdown of 1 plugins
090826 13:40:29 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
090826 13:40:29 mysqld_safe mysqld from pid file /usr/local/mysql/data/xserve.pid ended
After installation, I looked for /var/mysql/mysql.sock and it's missing, just not there. I'm aware of the PHP 5 + MySQL 5 socket file issue and I'm prepared to configure my server to correct for this. However, the socket file is simply not there.
Files at /var/mysql are owned by root and wheel group. Same permissions for files at /usr/local/mysql-5.1.37-osx10.4-powerpc
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.