代碼: 選擇全部
CREATE USER 'user1'@'localhost' IDENTIFIED BY 'user1pwd';
GRANT USAGE ON * . * TO 'user1'@'localhost' IDENTIFIED BY 'user1pwd' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
CREATE DATABASE IF NOT EXISTS `user1db` ;
GRANT ALL PRIVILEGES ON `user1db` . * TO 'user1'@'localhost';