this is how mysqladmin creates a database and username/password:
CREATE USER ‘tempp’@‘localhost’ IDENTIFIED BY ‘***’;
GRANT USAGE ON * . * TO ‘tempp’@‘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 `tempp` ;
GRANT ALL PRIVILEGES ON `tempp` . * TO ‘tempp’@‘localhost’;
dns:
primary domain has to have two subdomains, ns1 and ns2. both have “A” records pointing to the new IP number
primary mu-wordpress site has to point to this new name-server.
example from mysql website:
mysql> CREATE USER ‘monty’@‘localhost’ IDENTIFIED BY ‘some_pass’;
mysql> GRANT ALL PRIVILEGES ON . TO ‘monty’@‘localhost’ -> WITH GRANT OPTION;
mysql> CREATE USER ‘monty’@’%’ IDENTIFIED BY ‘some_pass’;
mysql> GRANT ALL PRIVILEGES ON . TO ‘monty’@’%’ -> WITH GRANT OPTION;
mysql> CREATE USER ‘admin’@‘localhost’;
mysql> GRANT RELOAD,PROCESS ON . TO ‘admin’@‘localhost’;
mysql> CREATE USER ‘dummy’@‘localhost’;
