MySQL: Grant Permissions

• Replace {db} with the name of the database.
• Replace {user} with the name of the user.

Grant Permissions

GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%';

Example: Grant all privileges on database web to user andunix.

GRANT ALL PRIVILEGES ON `web` . * TO 'andunix'@'%';