安裝好初次用root登入時，會出現#1698 - Access denied for user 'root'@'localhost'

很順利的找到的解法(原來不是只有我遇到呀(汗

只要先用root的權限登入本機mysql

sudo mysql -u root -p

然後打入

CREATE USER 'pmauser'@'%' IDENTIFIED BY '輸入自訂密碼';

GRANT ALL PRIVILEGES ON *.* TO 'pmauser'@'%' WITH GRANT OPTION;

※pmauser 可自訂

這樣無論是本機使用mysql登入還是phpmyadmin就都可以順利使用囉

參考網址

http://it.givemepower.net/%E9%8C%AF%E8%AA%A4%E8%A8%8A%E6%81%AF%EF%BC%9A1698-access-denied-for-user-rootlocalhost/

https://devanswers.co/phpmyadmin-access-denied-for-user-root-localhost/