I woke up this morning to check on our server and make some changes and after restarting, MYSQL will not start and now I'm getting a 500 internal error. I also checked all permissions and everything in that folder is 777. This is driving me crazy. I booted from a backup, which also had this error, so I don't know what to do. Any help would GREATLY be appreciated.
Here's the error from the log:
111021 14:02:08 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/leopard.local.pid ended
111021 14:51:28 mysqld_safe Starting mysqld daemon with databases from /Applications/XAMPP/xamppfiles/var/mysql
Warning: World-writable config file '/Applications/XAMPP/xamppfiles/etc/my.cnf' is ignored
111021 14:51:30 [Warning] The syntax '--skip-locking' is deprecated and will be removed in a future release. Please use --skip-external-locking instead.
111021 14:51:30 [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.
111021 14:51:32 [Warning] Setting lower_case_table_names=2 because file system for /Applications/XAMPP/xamppfiles/var/mysql/ is case insensitive
111021 14:51:33 [Note] Plugin 'FEDERATED' is disabled.
/Applications/XAMPP/xamppfiles/sbin/mysqld: Can't create/write to file '/var/folders/nu/nub8iLTEG08-vMj28lafL++++TI/-Tmp-/ibUMyRlX' (Errcode: 13)
111021 14:51:34 InnoDB: Error: unable to create temporary file; errno: 13
111021 14:51:34 [ERROR] Plugin 'InnoDB' init function returned error.
111021 14:51:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111021 14:51:35 [ERROR] Can't start server : Bind on unix socket: Permission denied
111021 14:51:35 [ERROR] Do you already have another mysqld server running on socket: /var/mysql/mysql.sock ?
111021 14:51:35 [ERROR] Aborting
111021 14:51:35 [Note] /Applications/XAMPP/xamppfiles/sbin/mysqld: Shutdown complete
111021 14:51:35 mysqld_safe mysqld from pid file /Applications/XAMPP/xamppfiles/var/mysql/leopard.local.pid ended