I'm really new to databases and SQL in general, previously having installed MySQL only to hand it over completely to some CMS or other. Now, I want to get serious about adding SQL and MySQL or PostgreSQL to my skills.
And so, perhaps bearing this in mind, MySQL no longer installs successfully. I'm using the DMG archive for 5.5.8, and everything seems to install just fine. The installers for both MySQL and the startup item give me big green checkmarks, and the preference pane works just fine, in and of itself.
But the MySQL daemon can't seem to come up. If I try to launch MySQL via the preference pane, this gets logged to the console:
2/6/11 3:01:11 AM 1269 System Preferences about to perform command 2/6/11 3:01:11 AM 1269 [0x0-0x65065].com.apple.systempreferences /usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found 2/6/11 3:01:11 AM 1269 System Preferences status= 0
$ mysqld spits out:
110206 3:04:29 [Warning] Can't create test file /usr/local/mysql-5.5.8-osx10.6-x86/data/Atlas.lower-test 110206 3:04:29 [Warning] Can't create test file /usr/local/mysql-5.5.8-osx10.6-x86/data/Atlas.lower-test 110206 3:04:29 [Note] Plugin 'FEDERATED' is disabled. mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 110206 3:04:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins InnoDB: Compressed tables use zlib 1.2.3 110206 3:04:29 InnoDB: Initializing buffer pool, size = 128.0M 110206 3:04:29 InnoDB: Completed initialization of buffer pool 110206 3:04:29 InnoDB: Operating system error number 13 in a file operation. InnoDB: The error means mysqld does not have the access rights to InnoDB: the directory. InnoDB: File name ./ibdata1 InnoDB: File operation call: 'create'. InnoDB: Cannot continue operation.
Let me know if any other information is needed. And thanks for your help!
MySQL is installed in
lrwxr-xr-x _mysql wheel /usr/local/mysql -> mysql-5.5.8-osx10.6-x86.