Time to install MySQL on my new MacBook .
$ cd /opt $ wget http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.45-osx10.4-i686.tar.gz/from/http://mysql.mirrors.hoobly.com/ $ tar xvfz mysql-5.0.45-osx10.4-i686.tar.gz $ cd mysql-5.0.45-ox10.4-i686 $ scripts/mysql_install_db Installing MySQL system tables... 071129 22:10:48 [Warning] Setting lower_case_table_names=2 because file system for /opt/mysql-5.0.45-osx10.4-i686/data/ is case insensitive OK Filling help tables... 071129 22:10:48 [Warning] Setting lower_case_table_names=2 because file system for /opt/mysql-5.0.45-osx10.4-i686/data/ is case insensitive OK bin/mysqld_safe & [1] 239 macbook:mysql-5.0.45-osx10.4-i686 rbradfor$ chown: /opt/mysql-5.0.45-osx10.4-i686/data/macbook.err: Operation not permitted Starting mysqld daemon with databases from /opt/mysql-5.0.45-osx10.4-i686/data $ bin/mysqladmin -uroot password 'sakila' $ bin/mysql -uroot -psakila -e "SELECT VERSION()" $ bin/mysqladmin -uroot -psakila shutdown
It was interesting that these normal steps under Linux provided two errors not normally seen.
-
Setting lower_case_table_names=2 because file system for /opt/mysql-5.0.45-osx10.4-i686/data/ is case insensitive
-
chown: /opt/mysql-5.0.45-osx10.4-i686/data/macbook.err: Operation not permitted
The first is interesting, is Mac like Windows in that sense? I’ll need to check that out.
The second occurs every time I start MySQL which is also intriguing, but for now doesn’t affect MySQL operation. It’s interesting that the permissions of the error file is the same as the user running it, so go figure.
