Python Graffiti wall: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

Ubuntu 16.xx or 17.xx 安裝 Mariadb 步驟

sudo apt-get install mariadb-server mariadb-client

sudo systemctl start mariadb

sudo systemctl enable mariadb

sudo systemctl status mariadb

sudo mysql_secure_installation

安裝完成連線sql，輸入root密碼後出現錯誤：

問題原因請參考原文出處

https://superuser.com/questions/957708/mysql-mariadb-error-1698-28000-access-denied-for-user-rootlocalhost

解決方式：

sudo mysql -u root (以sudo不需要密碼直接按ENTER)
use mysql;
update user set plugin='' where User='root';
flush privileges;
exit;

重新連線成功：

新增外部連結，記得修改bind-address

nano /etc/mysql/mariadb.conf.d/50-server.cnf
將此處設定以"#"標註

Mariadb完全移除

sudo apt-get purge --auto-remove mysql-common mysql-server \ mariadb-server

sudo apt-get autoremove

sudo apt-get autoclean

sudo rm -rf /etc/mysql

Python Graffiti wall