-- create user
create user user;

-- check user
select user, host, password from mysql.user;

-- set password
use mysql;
update user set password=PASSWORD("secret") where User='user';

-- grand all privileges
GRANT ALL PRIVILEGES ON database.* TO 'user'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;
flush privileges;

-------- other stuff --------
-- to revoke all privileges from a user
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user;

-- to grand some privileges for specific user and databse
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `database`.* TO 'user'@'%' WITH GRANT OPTION