CREATE DATABASE IF NOT EXISTS `mydatabase` ; CREATE USER 'username'@'hostname' IDENTIFIED BY 'password'; GRANT USAGE ON `mydatabase`.* TO 'username'@'hostname' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; CREATE USER 'username'@'Host.IP.X.X' IDENTIFIED BY 'password'; GRANT USAGE ON `mydatabase`. * TO 'username'@'Host.IP.X.X' IDENTIFIED BY 'password' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'username'@'hostname'; GRANT ALL PRIVILEGES ON `mydatabase`.* TO 'username'@'Host.IP.X.X';
Комментариев нет:
Отправить комментарий