2017年3月22日水曜日

dyld: lazy symbol binding failed: Symbol not found: _mysql_get_client_info





$ 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 Archive5.6.10155.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

0 件のコメント:

コメントを投稿