SQL-Project_MR/run_with_root.sql at main · laffylaffyla/SQL-Project_MR · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CREATE USER 'admin' @'localhost' IDENTIFIED BY '123456';

--docker
--CREATE USER 'admin' @'172.17.0.1' IDENTIFIED BY '123456';

ALTER USER 'admin' @'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

--docker
--ALTER USER 'admin' @'172.17.0.1' IDENTIFIED WITH mysql_native_password BY '123456';

CREATE DATABASE IF NOT EXISTS supermr_db;

GRANT ALL PRIVILEGES ON supermr_db.* TO 'admin' @'localhost';

--docker
--GRANT ALL PRIVILEGES ON supermr_db.* TO 'admin' @'172.17.0.1';