[Docker] mysql 8.0

docker run -it -p {{인포트}}:3306 -e MYSQL_ROOT_PASSWORD={{비번}} -v {{볼륨이름}}:/var/lib/mysql_8.0/data --name mysql_80 mysql:8.0.36 --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --lower_case_table_names=1

docker exec -it 98710cd36f7e bash

mysql -u root -p

use mysql;

-- 비밀번호 변경
ALTER user 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '{{비번}}';
flush privileges;


create user 'root'@'%' identified by '{{비번}}';


grant all privileges on *.* to 'root'@'%';
flush privileges;


-- 위에서 오류 나오면 먼저 삭제 후 다시 실행
delete from mysql.user where User ='root';
delete from mysql.db where User ='root';
flush privileges;

 

정보 확인 

docker inspect mysql_80

 

볼륨도 미리 만들어쓰자~