public
Last active

  • Download Gist
/etc/my.cnf
1 2 3 4 5 6 7 8 9
[mysqld]
init_connect='SET collation_connection = utf8_general_ci'
init_connect='SET NAMES utf8'
default-character-set=utf8
character-set-server = utf8
collation-server = utf8_general_ci
 
[mysql]
default-character-set=utf8
gistfile2.txt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
Snow Leopard Setup Sources and Notes
 
MySQL:
http://hivelogic.com/articles/compiling-mysql-on-snow-leopard/
Notes:
- Set root password:
mysqladmin -u root password PASSWORD
- Add /etc/my.cnf
- CREATE DATABASE thinking_sphinx;
- GRANT ALL ON thinking_sphinx.* TO 'thinking_sphinx'@'localhost';
- SET PASSWORD FOR 'thinking_sphinx'@'localhost' = PASSWORD('password');
- FLUSH PRIVILEGES;
- sudo env ARCHFLAGS="-arch x86_64" gem install mysql -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
 
PostgreSQL:
http://devoh.com/posts/2008/10/installing-postgresql-on-mac-os-x-10.5-leopard
http://devoh.com/posts/2009/08/postgresql-snow-leopard
Notes:
- using v8.4.0
- instead of postgres gem:
sudo env ARCHFLAGS="-arch x86_64" gem install pg
 
Sphinx:
http://freelancing-god.github.com/ts/en/installing_sphinx.html
Notes:
- ./configure --with-pgsql
 
Git:
http://hivelogic.com/articles/compiling-git-on-snow-leopard/
~/.gitignore
1
.DS_Store

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.