#freeze
**設定 [#k53a9751]

#contents
 
----
**パスワード設定 [#ne7e7769]
 mysql mysql
 mysql> select user,host,password from user;
 +------+-----------+----------+
 | user | host      | password | 
 +------+-----------+----------+
 | root | locahost  |          |
 | root | hostname  |          |
 | root | 127.0.0.1 |          |
 |      | locahost  |          |
 |      | hostname  |          |
 +------+-----------+----------+
 
 と、初期状態ではパスワード無し、ユーザー無しなので
 空欄ユーザーは削除、rootにはパスワードを設定する。
 
 DELETE FROM user where user='';
 DELETE FROM user where user='root' and host='hostname';
 GRANT ALL on *.* to root@"%" identified by 'hogehoge' with grant option;
 SET PASSWORD FOR root@127.0.0.1 = PASSWORD('hogehoge');
 FLUSH PRIVILEGES;
 
 など。
 
 mysql_secure_installation
 
 が、動くならそれでもよし。


**my.cnf [#q43e9221]
5.5の設定のままでは怒られた部分のみ書く( ´ω`)

 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated.
           Please use --explicit_defaults_for_timestamp server option
           (see documentation for more details).
 ↓
 [mysqld]
    explicit_defaults_for_timestamp = 1

 [ERROR] Can't find messagefile '/usr/share/errmsg.sys'
 ↓
 [mysqld]
    lc-message-dir = ${installdir}/share/
    lc-message     = 'ja_JP'
    lc-time-names  = 'ja_JP'
 ※lc-time-namesはおまけ
 ※en_USが無難かも

 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. 
         This option may be removed in future releases,
         together with the option innodb_use_sys_malloc and
         with the InnoDB's internal memory allocator.
 ↓
 [mysqld]
     #innodb_additional_mem_pool_size = xxM
 ※innodb_use_sys_mallocも書いてるなら消す

トップ   編集 差分 履歴 添付 複製 名前変更 リロード   新規 一覧 検索 最終更新   ヘルプ   最終更新のRSS