CREATE USER 'user'@'localhost' IDENTIFIED BY 'password'; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER,INDEX,LOCK TABLES ON database_name.* TO 'user'@'localhost' IDENTIFIED BY 'password'; FLUSH PRIVILEGES; SHOW GRANTS FOR 'user'@'localhost';