$ rails s
dyld: lazy symbol binding failed: Symbol not found: _mysql_get_client_info
Referenced from: /opt/local/lib/ruby/gems/1.8/gems/mysql2-0.3.11/lib/mysql2/mysql2.bundle
Expected in: flat namespace
dyld: Symbol not found: _mysql_get_client_info
Referenced from: /opt/local/lib/ruby/gems/1.8/gems/mysql2-0.3.11/lib/mysql2/mysql2.bundle
Expected in: flat namespace
Trace/BPT trap: 5
http://www-jp.mysql.com/downloads/mysql/
| Mac OS X ver. 10.7 (x86, 64-bit), DMG Archive | 5.6.10 | 155.9M | ||
| (mysql-5.6.10-osx10.7-x86_64.dmg) | MD5: 4b9e8063d8cad6ca83a79a267078cad1 | Signature | |||
cd /usr/local/mysql-5.6.10-osx10.7-x86_64
sudo ./bin/mysqld_safe &
mysql -u root -p
use mysql;
mysql> select user,host,password from user;
+------+-----------------+----------+
| user | host | password |
+------+-----------------+----------+
| root | hogemac.local | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | hogemac.local | |
+------+-----------------+----------+
5 rows in set (0.00 sec)
mysql> select user,host,password from user;
+------+-----------------+-------------------------------------------+
| user | host | password |
+------+-----------------+-------------------------------------------+
| root | localhost | *hogehogeF |
| root | hogemac.local | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | hogemac.local | |
+------+-----------------+-------------------------------------------+
6 rows in set (0.00 sec)
mysql> SET PASSWORD FOR root@localhost=PASSWORD('hogehoge');
mysql> delete from user where password="";
mysql> select user,host,password from user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *hojehoge |
+------+-----------+-------------------------------------------+
1 row in set (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql -u root -p
password:XXXXX
sudo vi /etc/hostconfig
MYSQLCOM=-YES-
sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
rails new rtest
cd rtest
sudo install_name_tool -change libmysqlclient.18.dylib /usr/local/mysql-5.6.10-osx10.7-x86_64/lib/libmysqlclient.18.dylib /opt/local/lib/ruby/gems/1.8/gems/mysql2-0.2.7/lib/mysql2/mysql2.bundle
ln -s /usr/local/mysql-5.6.10-osx10.7-x86_64/lib/libmysqlclient.18.dylib /usr/lib/libmysqlclient.18.dylib
sudo gem uninstall mysql2
sudo gem install mysql2 -- --with-mysql-config=/usr/local/mysql/bin/mysql_config
vi Gemfile
#gem 'sqlite3'
gem 'mysql2'
vi config/database.yml
development:
adapter: mysql2
encoding: utf8
reconnect: false
database: rtest_development
pool: 5
username: root
password: hogehoge
socket: /tmp/mysql.sock
test:
adapter: mysql2
encoding: utf8
reconnect: false
database: rtest_test
pool: 5
username: root
password: hogehoge
socket: /tmp/mysql.sock
production:
adapter: mysql2
encoding: utf8
reconnect: false
database: rtest_production
pool: 5
username: root
password: hogehoge
socket: /tmp/mysql.sock
rails g scaffold user name:string email:string
rake db:create
rake db:migrate
rails s
http://localhost:3000/users
