mysql 隨手記

新增使用者並且設定ip限制

CREATE USER ‘user’@’192.168.%’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON *.* TO ‘user’@’192.168.%’ WITH GRANT OPTION; FLUSH PRIVILEGES;