GRANT ALL PRIVILEGES ON on user code example

Example: grant user all privileges

mysql> GRANT ALL PRIVILEGES ON database_name.* TO 'username'@'localhost';