GRANT USAGE ON *.* TO 'american'@'localhost' IDENTIFIED BY PASSWORD '*968B5A05436AF69AEAF055FEAD1BA61E9F126A6D'; GRANT ALL PRIVILEGES ON `american\_jos2`.* TO 'american'@'localhost'; GRANT USAGE ON *.* TO 'american_jos'@'localhost' IDENTIFIED BY PASSWORD '*968B5A05436AF69AEAF055FEAD1BA61E9F126A6D'; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE ROUTINE, ALTER ROUTINE ON `american\_jos2`.* TO 'american_jos'@'localhost';