Install and Config MySQL 8 on Ubuntu

Remove Completely and Install

sudo apt-get remove --purge "mysql*"
sudo apt-get purge "mysql*"
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get remove dbconfig-mysql
sudo apt-get dist-upgrade
sudo rm -rf /etc/mysql /var/lib/mysql
sudo apt-get update && sudo apt-get install mysql-server

Enable Remote Access

su root
mysql -uroot -e " \
    ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'yourpasswd'; \
    CREATE USER 'root'@'%' IDENTIFIED BY 'yourpasswd'; \
    GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'; \
    FLUSH PRIVILEGES;"

In /etc/mysql/mysql.conf.d/mysqld.cnf:

  • replace bind-address = 127.0.0.1 with bind-address = 0.0.0.0

Then restart mysql by sudo service mysql restart.

posted @ 2020-06-10 12:11  ToRapture  阅读(133)  评论(0编辑  收藏  举报