25
Jan
2018

Fast create MySQL user and db with prevs

25 Jan 2018
CREATE USER 'fast'@'%' IDENTIFIED WITH mysql_native_password AS '***'; GRANT USAGE ON *.* TO 'fast'@'%' REQUIRE NONE 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 `fast`; GRANT ALL PRIVILEGES ON `fast`.* TO 'fast'@'%'; GRANT ALL PRIVILEGES ON `fast\_%`.* TO 'fast'@'%';