Add User

mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'localhost'
mysql> IDENTIFIED BY 'userpassword' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'user'@'%'
mysql> IDENTIFIED BY 'userpassword' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;