MySQL – How to Create/Assign a User to a Database

Below shows you the syntax required to assign a user (along with password) to a MySQL database.

This is useful for assigning separate permissions across your databases rather then just assigning root access across the board.

mysql> GRANT ALL ON <DATABASE>.* TO <USERNAME>@localhost IDENTIFIED BY '<PASSWORD>';
Rick Donato

Want to become a database expert?

Here is our hand-picked selection of the best courses you can find online:
Ultimate MySQL Bootcamp
Complete SQL Bootcamp
MongoDB Complete Developer course
and our recommended certification practice exams:
AlphaPrep Practice Tests - Free Trial