ubuntu 安装 mysql8

# 安装
sudo apt-get install mysql-client-8.0 mysql-server-8.0

# 修改密码
# 用debian.cnf里面的用户名和密码来登录
use mysql;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';
FLUSH PRIVILEGES;
# 重启服务
sudo systemctl restart mysql.service

# 修改远程访问
mysql -u root -p
use mysql;
update user set host='%' where user='root';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpassword';
FLUSH PRIVILEGES;

# 其他设置
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
# 在[mysqld]的下面添加如下语句，然后重启
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'

# 更新服务端 字符编码为 utf8mb4
sudo vim /etc/mysql/my.cnf

[mysqld]
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci
init_connect='SET NAMES utf8mb4'
skip-character-set-client-handshake

[client]
default-character-set = utf8mb4

[mysql]
default-character-set = utf8mb4

[mysqldump]
default-character-set = utf8mb4

# 重启服务
sudo systemctl restart mysql.service