/ Published in: SQL

creates a user that has only access to one database, from any host
Expand |
Embed | Plain Text
CREATE USER 'username'@'%' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'%'; FLUSH PRIVILEGES;
You need to login to post a comment.