修改表字段

1# 新增一个字段
2alert table rules add effect_time

mysql sql 8.0 认证问题

connect to 10.227.4.115:3306 err: this authentication plugin is not supported

image-20210417132924881 

1alter user root@% identified with mysql_native_password by "123456"

1CREATE DATABASE IF NOT EXISTS echo_bio DEFAULT CHARSET utf8 COLLATE utf8_general_ci;
2CREATE DATABASE IF NOT EXISTS echo_bio_jira DEFAULT CHARSET utf8 COLLATE utf8_general_ci;