Posted By

Tagged

Viewed 1095 times

Favorited by 1 user(s)

/ Published in: SQL

creates a user that has only access to one database, from any host

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

CREATE USER 'username'@'%' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON `database` . * TO 'username'@'%';
FLUSH PRIVILEGES;

Comment:

You need to login to post a comment.