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 が、動くならそれでもよし。
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も書いてるなら消す