centos7.5 安裝mysql (不是mariadb) 之後mysql_secure_installation 無法建立root密碼
mysql_secure_installation 失敗之後. 請先關閉mysqld
systemctl stop mysqld
然後輸入本串
systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
再啟動
systemctl start mysql
密碼就是空的了
PS.mariadb
# systemctl set-environment MYSQLD_OPTS="--skip-grant-tables"
# systemctl start mariadb