DWQA Questions › Category: Mysql › how to create user with rights only for specific db in mysql? 0 Vote Up Vote Down 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’;