MariaDB SQL 명령어 (MariaDB SQL Command)

SHOW DATABASES;

CREATE DATABASE database_name;

USE database_name;

USE mysql;

SELECT HOST, USER, PASSWORD FROM USER;

CREATE USER 'user_id'@'%' IDENTIFIED BY 'user_password';

CREATE USER 'user_id' IDENTIFIED BY 'user_password';

GRANT ALL PRIVILEGES ON database_name.* TO 'user_id'@'%';

GRANT ALL PRIVILEGES ON database_name.* TO 'user_id';

FLUSH PRIVILEGES;

DROP USER ["사용자"]@["서버"];