MARK-create mysql user and db

2026-01-06

background: docker install mysql

execut docker

docker exec -it mysql-docker-container-name mysql -u root -p

create db

CREATE DATABASE IF NOT EXISTS db_name;

create user

CREATE USER 'db_user'@'%' IDENTIFIED BY 'db_user';

grant

GRANT ALL PRIVILEGES ON db_name.* TO 'db_user'@'%';

fresh

FLUSH PRIVILEGES;

check user

SELECT host, user FROM mysql.user WHERE user = 'db_user';

login test

docker exec -it mysql-docker-container-name mysql -u db_user -p'db_user' -D db_name