Planet of NCCUCS

裝了Snow Leopard之後一切開發都不順了 XD
最後還是回過頭去看 xdite 當初怎麼從 OSX 10.5 升到 10.6
記錄一下，如果要用 OSX 10.6
那麼就是在裝 mysql 的時候直接下載 mysql official website 提...

Try this
sudo env ARCHFLAGS=”-arch x86_64″ gem install mysql — –with-mysql-config=/usr/local/mysql/bin/mysql_config
I don’t know why I can not use below command instead upper magic one.
sudo env ARCHFLAG...

step 1 : Edit /etc/mysql/my.cnf to comment bind-address = 127.0.0.1# bind-address - 127.0.0.1
step 2 : Create a new user for remote accessingmysql> CREATE USER ‘your_account’@’%’ IDENTIFIED BY ‘your_password̵...

[原文轉載] http://foundationphp.com/tutorials/php_leopard.php

1. 複製 /private/etc/php.ini.default
cd /private/etc
sudo cp php.ini.default php.ini

2. 修改 default socket
line 761
mysql.default_socket = /op...

Error Mesg :
The server is not responding (or the local MySQL server’s socket is not correctly configured
Solution :

http://forums.mysql.com/read.php?35,64808,75300#msg-75300

想不透呀..除了一開始就把mysqld.so...

參考文章1. http://stackoverflow.com/questions/991708/rails-mysql-and-snow-leopard2. http://blog.xdite.net/?p=1419基本上就是鬼打牆了好險只要兩個步驟sudo gem update –systemsudo env ARCHFLAGS=”-arch x86_64″ gem inst...

1. install macport
2. sudo port install mysql5 +server
3. sudo port install mysql5-server

# A startup item has been generated that will aid in
# starting mysql5-server with launchd. It is disabled
# by default. Execute t...

原理是先把wordpress database 從mysql dump出來，
然後將之轉成utf8之後，再塞回去database。
1.把wordpress database dump出來
mysqldump -u [database user] -p [wordpress database] > wp.sql
(不知道為...