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 is a Network Automation Architect/Evangelist and the founder of Packet Coders.

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:
Delta Practice Tests