{"id":933,"date":"2015-08-13T21:12:37","date_gmt":"2015-08-13T21:12:37","guid":{"rendered":"https:\/\/fir3netwp.gmsrrpobkbd.com\/2015\/08\/13\/mysql-how-do-i-create-assign-a-user-to-a-database\/"},"modified":"2021-07-24T15:37:24","modified_gmt":"2021-07-24T15:37:24","slug":"mysql-how-do-i-create-assign-a-user-to-a-database","status":"publish","type":"post","link":"https:\/\/www.fir3net.com\/Databases\/Mysql\/mysql-how-do-i-create-assign-a-user-to-a-database.html","title":{"rendered":"MySQL – How to Create\/Assign a User to a Database"},"content":{"rendered":"
Below shows you the syntax required to assign a user (along with password) to a MySQL database.<\/p>\n
This is useful for assigning separate permissions across your databases rather then just assigning root access across the board.<\/p>\n
mysql> GRANT ALL ON <DATABASE>.* TO <USERNAME>@localhost IDENTIFIED<\/a> BY '<PASSWORD>';<\/pre>\n","protected":false},"excerpt":{"rendered":"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>’;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[60],"tags":[],"yoast_head":"\n
MySQL - How to Create\/Assign a User to a Database - Fir3net<\/title>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t\n