GRANT SELECT ON db_name.* TO 'username'@'localhost' IDENTIFIED BY 'password';
GRANT SELECT ON db_name.* TO 'username'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'username'@'localhost'
GRANT SELECT ON db_name.* TO 'username'@'%' IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
SHOW GRANTS FOR 'username'@'localhost'
Комментариев нет:
Отправить комментарий