Users - Revision history

George2 at 14:00, 10 August 2015

2015-08-10T14:00:02Z

2014-09-18T14:03:44Z

2014-09-18T13:51:22Z

2014-09-18T13:50:34Z

2014-09-18T13:49:18Z

2014-09-18T13:48:06Z

2014-09-18T13:45:34Z

2014-09-18T13:44:08Z

Created page with "create user '<username>'@'<hostname' identified by '<password>'<br>"

New page

create user '<username>'@'<hostname' identified by '<password>'<br>

@@ Line 2: / Line 2: @@
 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>
-DROP USER ‘demo’@‘localhost’;
+DROP USER ‘demo’@‘localhost’;<br>

← Older revision		Revision as of 14:03, 18 September 2014
Line 2:		Line 2:
	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>		REVOKE [type of permission] ON [database name].[table name] FROM ‘[username]’@‘localhost’;<br>
		+	DROP USER ‘demo’@‘localhost’;

← Older revision		Revision as of 13:51, 18 September 2014
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>

← Older revision		Revision as of 13:50, 18 September 2014
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>

← Older revision		Revision as of 13:49, 18 September 2014
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>

← Older revision		Revision as of 13:48, 18 September 2014
Line 1:		Line 1:
−	grant ALL on <database>.<table> ~~create user~~ '<username>'@'<hostname' identified by '<password>'<br>	+	grant ALL on <database>.<table> to '<username>'@'<hostname' identified by '<password>'<br>

← Older revision		Revision as of 13:45, 18 September 2014
Line 1:		Line 1:
−	create user '<username>'@'<hostname' identified by '<password>'<br>	+	grant ALL on <database>.<table> create user '<username>'@'<hostname' identified by '<password>'<br>