Difference between revisions of "Users"

From MyWiki
Jump to: navigation, search
Line 1: Line 1:
 
grant ALL on <database>.<table>  to '<username>'@'<hostname>' identified by '<password>'<br>
 
grant ALL on <database>.<table>  to '<username>'@'<hostname>' identified by '<password>'<br>
 +
GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;<br>

Revision as of 13:50, 18 September 2014

grant ALL on <database>. to '<username>'@'<hostname>' identified by '<password>'
GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;