2,187
edits
Difference between revisions of "MySQL"
Jump to navigation
Jump to search
→Create Users: Added RO user
(→IP Addresses: Added get-out for binary string gotcha) |
(→Create Users: Added RO user) |
||
| Line 27: | Line 27: | ||
To give user privileges to a user coming from a specific host; | To give user privileges to a user coming from a specific host; | ||
<source lang="mysql"> GRANT USAGE on <database>.* to '<user>'@'<host>' identified by '<password>' with grant option; </source> | <source lang="mysql"> GRANT USAGE on <database>.* to '<user>'@'<host>' identified by '<password>' with grant option; </source> | ||
To give a user read-only access; | |||
<source lang="mysql"> GRANT SELECT on <database>.* to '<user>'@'<host>' identified by '<password>';</source> | |||
=== Delete Users === | === Delete Users === | ||