MySQL Databases - Revision history

320x200 at 14:24, 24 February 2019

2019-02-24T14:24:55Z

← Older revision		Revision as of 14:24, 24 February 2019
Line 7:		Line 7:
	* Create new UTF-8 database called <code>mydatabase</code> (at time of writing, 20190214, these settings seem to be the best practice for UTF-8 settings, YMMV, update if needed)		* Create new UTF-8 database called <code>mydatabase</code> (at time of writing, 20190214, these settings seem to be the best practice for UTF-8 settings, YMMV, update if needed)
	CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;		CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
			* Change the encoding of <code>mydatabase</code> (because some software may not support latest best practices, etc)
			ALTER DATABASE mydatabase CHARACTER SET = utf8 COLLATE = utf8_general_ci;
	* Give full control of <code>mydatabase</code> to existing <code>newuser</code>		* Give full control of <code>mydatabase</code> to existing <code>newuser</code>
	GRANT ALL PRIVILEGES ON mydatabase.* TO newuser@localhost;		GRANT ALL PRIVILEGES ON mydatabase.* TO newuser@localhost;

320x200 at 13:06, 24 February 2019

2019-02-24T13:06:10Z

← Older revision		Revision as of 13:06, 24 February 2019
Line 9:		Line 9:
	* Give full control of <code>mydatabase</code> to existing <code>newuser</code>		* Give full control of <code>mydatabase</code> to existing <code>newuser</code>
	GRANT ALL PRIVILEGES ON mydatabase.* TO newuser@localhost;		GRANT ALL PRIVILEGES ON mydatabase.* TO newuser@localhost;
			FLUSH PRIVILEGES;


	[[Category:Database]]		[[Category:Database]]

320x200 at 13:05, 24 February 2019

2019-02-24T13:05:27Z

← Older revision		Revision as of 13:05, 24 February 2019
Line 5:		Line 5:
	* Create new user called <code>newuser</code>		* Create new user called <code>newuser</code>
	CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';		CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';
	* ~~Creat~~ new UTF-8 database called <code>mydatabase</code> (at time of writing, 20190214, these settings seem to be the best practice for UTF-8 settings, YMMV, update if needed)		* Create new UTF-8 database called <code>mydatabase</code> (at time of writing, 20190214, these settings seem to be the best practice for UTF-8 settings, YMMV, update if needed)
	CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;		CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
			* Give full control of <code>mydatabase</code> to existing <code>newuser</code>
			GRANT ALL PRIVILEGES ON mydatabase.* TO newuser@localhost;


	[[Category:Database]]		[[Category:Database]]

320x200 at 13:01, 24 February 2019

2019-02-24T13:01:45Z

← Older revision		Revision as of 13:01, 24 February 2019
Line 5:		Line 5:
	* Create new user called <code>newuser</code>		* Create new user called <code>newuser</code>
	CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';		CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';
	* Creat new UTF-8 database called <code>mydatabase</code>		* Creat new UTF-8 database called <code>mydatabase</code> (at time of writing, 20190214, these settings seem to be the best practice for UTF-8 settings, YMMV, update if needed)
	CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;		CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

320x200 at 12:21, 24 February 2019

2019-02-24T12:21:22Z

← Older revision		Revision as of 12:21, 24 February 2019
Line 5:		Line 5:
	* Create new user called <code>newuser</code>		* Create new user called <code>newuser</code>
	CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';		CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';
			* Creat new UTF-8 database called <code>mydatabase</code>
			CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;



	[[Category:Database]]		[[Category:Database]]

320x200: Created page with "Some MySQL handy oneliners: * List all users from running instance: SELECT User, Host, Password FROM mysql.user; * Create new user called `newuser` CREATE USER n..."

2019-02-24T12:12:04Z

Created page with "Some MySQL handy oneliners: * List all users from running instance: SELECT User, Host, Password FROM mysql.user; * Create new user called <code>newuser</code> CREATE USER n..."

New page

Some MySQL handy oneliners:

* List all users from running instance:
SELECT User, Host, Password FROM mysql.user;
* Create new user called <code>newuser</code>
CREATE USER newuser@localhost IDENTIFIED BY 'superstrongpassword';

[[Category:Database]]