mirror of
https://github.com/veops/oneterm.git
synced 2025-09-26 19:31:14 +08:00
12 lines
345 B
SQL
12 lines
345 B
SQL
-- create database
|
|
CREATE DATABASE IF NOT EXISTS acl;
|
|
CREATE DATABASE IF NOT EXISTS oneterm;
|
|
|
|
-- create user
|
|
CREATE USER 'oneterm'@'%' IDENTIFIED BY '123456';
|
|
CREATE USER 'acl'@'%' IDENTIFIED BY '123456';
|
|
|
|
-- grant privileges
|
|
GRANT ALL PRIVILEGES ON `oneterm`.* TO 'oneterm'@'%' WITH GRANT OPTION;
|
|
GRANT ALL PRIVILEGES ON `acl`.* TO 'acl'@'%';
|