Mysql: creating a new user and assign all permission to it

By:
On:
In: Database

Mysql: creating a new user and assign all permission to it