MySQLクイック・リファレンス 
mysql> GRANT ALL PRIVILEGES ON *.* TO user1@"%"
    ->  IDENTIFIED BY 'パスワード' WITH GRANT OPTION;
mysql>  GRANT ALL PRIVILEGES ON *.* TO user1@localhost
    ->  IDENTIFIED BY 'パスワード' WITH GRANT OPTION;
mysql>  FLUSH PRIVILEGES;