HanaLucky / kpter-web

Landing Page for KPTer iOS application
https://www.kpter.net/
0 stars 0 forks source link

Google Cloud SQLへの接続が可能なように修正&寿司ビール問題解消の前段 #298

Closed luckyriverr closed 6 years ago

luckyriverr commented 6 years ago

/etc/my.cnfを以下のように書き換える

[mysqld]
# changes the default charcter set to utf-8.
# uses the below post as a reference.
# https://mariadb.com/kb/en/mariadb/setting-character-sets-and-collations/
character-set-server = utf8mb4
skip-character-set-client-handshake
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
init-connect = SET NAMES utf8mb4
innodb_file_format = Barracuda
innodb_file_per_table = 1
innodb_large_prefix

[mysql]
default-character-set=utf8mb4

[client]
default-character-set=utf8mb4

[mysqld_safe]
log-error=/var/log/mysqld.log
# MySQL再起動
$ sudo service mysqld restart

# データベースから作成し直す(開発環境)
$ bundle exec rails db:migrate:reset
$ bundle exec rails db:seed RAILS_ENV=development

寿司ビール問題が解決しているはず。