DWQA QuestionsCategory: Mysqlhow to create user with rights only for specific db in mysql?
kandy asked 5 years ago

CREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘some_pass’;
grant all privileges on B.* to ‘myuser’@’localhost’ identified by ‘some_pass’;