Corporate systems need monitoring, backups, updates, as well as system and user management.Ubuntu (apt), Cent OS, Fedora and Red Hat (rpm/YUM) Linux server administration and desktop systems adminstration are covered in this tutorial.Seems brew does not stop a service before uninstalling.After checking the file i saw the logged error that another copy of mysql may be running, after terminating the old service. 150818 mysqld_safe Logging to '/opt/boxen/log/mysql/error.log'. 150818 mysqld_safe Starting mysqld daemon with databases from /opt/boxen/data/mysql /opt/boxen/homebrew/bin/mysqld_safe: line 129: /opt/boxen/log/mysql/error.log: Permission denied Simple....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 .
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.
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.
Inno DB: The error means mysqld does not have the access rights to Inno DB: the directory.
In the end, cleaning up and following brew doctors advice made it possible to run through the setup described above. I copied the entire lampp folder from /opt to a new server.
So a note to anyone else passing by; don't try to cheat the brew doctor and think you know better! When I tried to start up mysql I got a message: The server quit without updating PID file.