grant user privileges code example

Example: grant user all privileges

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