MySQL5.6/設定
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
]
開始行:
**設定 [#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' wi...
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 depre...
Please use --explicit_defaults_for_timestamp s...
(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 i...
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も書いてるなら消す
終了行:
**設定 [#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' wi...
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 depre...
Please use --explicit_defaults_for_timestamp s...
(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 i...
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も書いてるなら消す
ページ名: