ubuntu18.04安装配置mysql

cooolr 于 2022-10-07 发布
CREATE DATABASE IF NOT EXISTS data_collect DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
use mysql;
update user set host = '%' where user = 'root';
select host, user from user;
FLUSH PRIVILEGES;
$ sudo vim /etc/mysql/my.cnf

[mysqld]
default-time_zone = '+8:00'

sudo systemctl restart mysql