mysql 8

[ksh0165]

docker run -it --privileged -d --name=mysql8 -p 722:22 -p 780:80 -p 7306:3306 --network bridge mysql_centos8 /sbin/init

[ksh0165]

https://yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/x86_64/index.html

[ksh0165]

docker run -it --privileged -d --name=mysql8 -p 722:22 -p 780:80 -p 7306:3306 --network bridge dokken/centos-8:latest /sbin/init

[ksh0165]

https://happycloud-lee.tistory.com/229

[ksh0165]

CREATE DATABASE kto default CHARACTER SET UTF8;

create user 'root'@'%' identified by '123'; GRANT ALL PRIVILEGES ON kto. TO root@localhost; GRANT ALL PRIVILEGES ON kto. TO 'root'@'%'; FLUSH PRIVILEGES;

[ksh0165]

GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;

[ksh0165]

delete from mysql.user where User ='root';

set global validate_password.policy=LOW;

[ksh0165]

set global log_bin_trust_function_creators=1;

[ksh0165]

wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-8.0.26.zip

[ksh0165]

systemctl stop mysqld

mysqld --user=mysql --skip-grant-tables

mysql

FLUSH PRIVILEGES;

SET GLOBAL validate_password.policy=LOW;

ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';

[ksh0165]

docker pull dokken/centos-8:latest