Mysql common questions and answers

CREATE USER CREATE USER ‘jeffrey’@’localhost’ IDENTIFIED BY ‘mypass’; Create user without password. CREATE USER ‘jeffrey’@’localhost’; DROP User DROP USER ‘jeffrey’@’localhost’; GRANT Steps: CREATE USER ‘jeffrey’@’localhost’ IDENTIFIED BY ‘mypass’; GRANT ALL ON db1.* TO ‘jeffrey’@’localhost’; GRANT SELECT ON db2.invoice TO ‘jeffrey’@’localhost’; GRANT USAGE ON *.* TO ‘jeffrey’@’localhost’ WITH MAX_QUERIES_PER_HOUR 90; RENAME USER RENAME USER ‘jeffrey’@’localhost’ TO […]