ubuntu 18.04 mysql 8.023 설치

sudo apt update sudo apt install mysql-server sudo mysql_secure_installation

sudo mysql_secure_installation

Check authentication method for MySQL users

#주석처리 #bind-address=127.0.0.0 vi /etc/mysql/mysql.conf.d/mysqld.cnf

ufw allow 연결 설정 Or IPtable Port open

Mysql WorkBench

[mysql] Data Import ERROR 1067 (42000) at line 431

solution:

mysql Error -> mysql_upgrade

Error Saving Account Error creating account vpopmail@%: Column countof mysql.user is wrong, Expected 42… Please use myslq_upgrade to fix this error. mysql_upgrade -u root -p