How many times have you hit your head and though .. ‘how do i add a user on mysql again?’

Heres how:

mysql> GRANT ALL ON demo.* TO user1@localhost IDENTIFIED BY 'mypassword';