Difference between revisions of "Users"

Revision as of 13:50, 18 September 2014 (view source) George2 (Talk | contribs) ← Older edit		Revision as of 13:51, 18 September 2014 (view source) George2 (Talk | contribs) Newer edit →
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>		GRANT [type of permission] ON [database name].[table name] TO ‘[username]’@'localhost’;<br>
		+	REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;<br>

---

Revision as of 13:51, 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’;
REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;