安裝apach, mysql, php及phpmyadmin，設定mysql root密碼失敗

今天在Ubuntu安裝系統，依照這四個網頁的教學分別設定apach, mysql, php, phpmyadmin

1. apach：https://ui-code.com/archives/179

2. mysql：https://ui-code.com/archives/293

3. php：https://ui-code.com/archives/286

4. phpmyadmin：https://ui-code.com/archives/297

在2.安裝Mysql後，要啟動密碼設定結果失敗，錯誤訊息是：

“MySQL Failed! Error: SET PASSWORD has no significance for user ‘root’@’localhost’ as the authentication method used doesn’t store authentication data in the MySQL server. Please consider using ALTER USER”

搜尋一下文章後，這樣做即可

1. 再開啟另外的terminal視窗，因為現在的視窗被輸入密碼卡死了，跳不出來
2. 關閉上一次密碼設定執行緒：sudo killall -9 mysql_secure_installation
3. 進入Mysql：sudo mysql
4. 在Mysql命令中輸入：
   ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘你的新密碼’;
5. 退出Mysql命令：exit
6. 重新進入密碼設定：sudo mysql_secure_installation

最後要記得把phpmyadmin的對外功能關閉，修改/etc/phpmyadmin/apache.conf

在</IfModule>下方輸入以下文字即可

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
    Options FollowSymLinks
    DirectoryIndex index.php

    <IfModule mod_php5.c>
           ......
    </IfModule>
    Order Deny,Allow
    Deny from all
    Allow from 127.0.0.1
</Directory>

phpmyadmin如果錯誤，可能是沒有指定

Not Found The requested URL was not found on this server.

這時候輸入 sudo nano /etc/apache2/conf-available/phpmyadmin.conf

Alias /phpmyadmin /usr/share/phpmyadmin

<Directory /usr/share/phpmyadmin>
    Options SymLinksIfOwnerMatch
    DirectoryIndex index.php
    Require all granted
</Directory>

phpmyadmin對mysql的密碼可利用以下指令建立

sudo mysql
CREATE USER '帳號'@'localhost' IDENTIFIED BY '一組你自己設定的強密碼';
GRANT ALL PRIVILEGES ON *.* TO '帳號'@'localhost' WITH GRANT OPTION;
FLUSH PRIVILEGES;