3C健忘人 - 疑難排除不求人 - no more ask for IT help

 1.  $ sudo systemctl stop mysql $ sudo mkdir  /var/run/mysqld; sudo chown mysql /var/run/mysqld 2. $ mysqld_safe --skip-grant-tables & $ mysql --user=root mysql 3. -> update mysql.user set authentication_string=null where user='root';

利用yum 安裝 MySQL 8 後(https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html，https://dev.mysql.com/downloads/repo/yum/)， 或 wget https://dev.mysql.com/get/mysql80-community-release-el7-2.noarch.rpm yum localinstall  mysql80-community-release-el7-2.noarch.rpm yum install mysql-community-server 安裝後 mysql 之管理帳號 root已經不再是空密碼，需先找尋預設密碼，才能繼續使用mysql_secure_installation 接著搜尋預設密碼，利用指令grep $ su - $ grep 'temporary password' /var/log/mysqld.log 若要搭配phpMyAdmin使用會發生cache_sha2_password問題 (圖一) 請記得修改如以下 msyql -u root -p >alter user 'root'@'localhost' identified with mysql_native_password by 'password'; 參考如下 https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html#upgrade-caching-sha2-password