grant all privileges on *.* to ‘user’@'localhost’ identified by ‘password’;
flush privileges;
Latest Updates: mysql RSS
-
AgentVladimir
-
AgentVladimir
CREATE USER ‘mttestdb’@'localhost’ IDENTIFIED BY ‘****’;
GRANT USAGE ON * . * TO ‘mttestdb’@'localhost’ IDENTIFIED BY ‘****’ 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 `mttestdb` ;
GRANT ALL PRIVILEGES ON `mttestdb` . * TO ‘mttestdb’@'localhost’;