login as root:

>mysql  -u root -p

>*******

mysql>GRANT ALL PRIVILEGES ON *.* TO 'cooluser'@'localhost'

             IDENTIFIED BY 'some_pass' WITH GRANT OPTION;