Download the latest mysql and pick the Mac OS X 10.7 (x86, 64-bit), DMG Archive version.
You can check the running My SQL process using following command: ps auxf | grep mysql If you get any My SQL process kill that process ID using kill -9 PID and then try to start My SQL.
120309 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/data 120309 [Warning] Setting lower_case_table_names=2 because file system for /usr/local/mysql/data/ is case insensitive 120309 [Warning] You need to use --log-bin to make --binlog-format work. 120309 Inno DB: The Inno DB memory heap is disabled 120309 Inno DB: Mutexes and rw_locks use GCC atomic builtins 120309 Inno DB: Compressed tables use zlib 1.2.3 120309 Inno DB: Initializing buffer pool, size = 16.0M 120309 Inno DB: Completed initialization of buffer pool 120309 Inno DB: Operating system error number 13 in a file operation.
Make sure the /usr/local/var/mysql folder is owned by the user that will start mysql. However, if you start it as root, it will create a (owned by root) file that jack can't write to, so when you try to restart it as jack it will fail. I got this error, and it ended up being an old invalid setting in the my.cnf, which the mysql error log indicated.
If not a bad config setting, the error log should at least point you in the right direction.
[mysqld] port = 3306 socket = /tmp/skip-external-locking key_buffer_size = 16K pid-file=/var/run/mysqld/[mysqld_safe] log-error=/var/log/pid-file=/var/run/mysqld/The solution that worked for me was here: https://serverfault.com/questions/334284/cant-create-pid-file-on-mysql-server-permission-denied Changing some of my permissions seemed to do the trick.
Mysql manager of pid file quit without updating Horny girls chatroom no sign up
I'm running a Mid-2012 Macbook Air with OS X 10.8.2 and mysql was installed with homebrew. Please take note that you need to run mysql_install_db from the with top level of the mysql directory (IE, usr/local/Cellar/mysql/5.5.25).
Running it directly within the /scripts directory does not give it enough context for it to run.
resulted in the error: "The server quit without updating PID file" I noticed something odd in the installation instructions though.
Inno DB: The error means mysqld does not have the access rights to Inno DB: the directory.
Inno DB: File name /usr/local/mysql/data/ib_logfile0 Inno DB: File operation call: 'open'. 120309 mysqld_safe mysqld from pid file /usr/local/mysql/data/lu1s.ended Then (you can do it command-line too), I applied the permissions (once I gave that ownership to _mysql and mysql users) to all enclosed folders from within the "get info" menu of the folder at /usr/local/mysql-5.5.21-osx10.6-x86_64 .