2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
m
→Create Users: Added website script example
(→Create Users: Corrected GRANT USAGE) |
m (→Create Users: Added website script example) |
||
| Line 30: | Line 30: | ||
To give a user read-only access; | To give a user read-only access; | ||
<source lang="mysql"> GRANT SELECT on <database>.* to '<user>'@'<host>' identified by '<password>';</source> | <source lang="mysql"> GRANT SELECT on <database>.* to '<user>'@'<host>' identified by '<password>';</source> | ||
To give user ''web-user'', read-only access to local database ''webdb''; | |||
<source lang="mysql"> GRANT SELECT ON webdb.* TO 'web-user'@'localhost' IDENTIFIED BY 'password';</source> | |||
=== Delete Users === | === Delete Users === | ||