mariadb, basic 101
# 登入Mariadb
# mariadb -u username -p
# 建立資料庫給網站使用
CREATE DATABASE `dbName`;
CREATE USER ‘usrName’@localhost IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON `dbName`.* TO ‘usrName’@localhost;
FLUSH PRIVILEGES;
# 登入Mariadb
# mariadb -u username -p
# 建立資料庫給網站使用
CREATE DATABASE `dbName`;
CREATE USER ‘usrName’@localhost IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON `dbName`.* TO ‘usrName’@localhost;
FLUSH PRIVILEGES;