Difference between revisions of "MySQL - Read only privileges on a database for a user"
(Created page with "<pre>GRANT SELECT ON MY-DATABASE.* TO 'USERNAME'@'localhost' IDENTIFIED BY 'MYPASSWORD';</pre> <pre>FLUSH PRIVILEGES;</pre> Use "*" instead if you want to refer to all datab...") |
|||
| Line 2: | Line 2: | ||
<pre>FLUSH PRIVILEGES;</pre> | <pre>FLUSH PRIVILEGES;</pre> | ||
| + | |||
| + | |||
Use "*" instead if you want to refer to all databases. And use wildcard "%" instead of "localhost" for a public user. | Use "*" instead if you want to refer to all databases. And use wildcard "%" instead of "localhost" for a public user. | ||
[[Category: MySQL]] | [[Category: MySQL]] | ||
Latest revision as of 17:08, 5 April 2020
GRANT SELECT ON MY-DATABASE.* TO 'USERNAME'@'localhost' IDENTIFIED BY 'MYPASSWORD';
FLUSH PRIVILEGES;
Use "*" instead if you want to refer to all databases. And use wildcard "%" instead of "localhost" for a public user.
