MySQL: How to Add an Existing User to an Existing Database

Submitted by admin on Mon, 09/19/2016 - 19:36

GRANT USAGE ON `<DATABASE_NAME>`.* TO '<USERNAME>'@'%';
GRANT ALL PRIVILEGES ON `<DATABASE_NAME>`.* TO '<USERNAME>'@'%' WITH GRANT OPTION;

Tags