Creating MySQL Users/Databases - Revision history

Srapaz at 15:10, 15 January 2021

2021-01-15T15:10:55Z

50.98.120.25 at 17:20, 6 May 2018

2018-05-06T17:20:16Z

70.79.79.234 at 21:01, 8 July 2013

2013-07-08T21:01:25Z

New page

Create a database user:
create user userName;

Create a database:
create database dataBaseName;

Grant user database permissions:
grant all on dataBaseName.* to userName@localhost identified by 'PASSWORD';

←Older revision		Revision as of 15:10, 15 January 2021
Line 19:		Line 19:
	Always flush privileges after modifying users:		Always flush privileges after modifying users:
	FLUSH PRIVILEGES;		FLUSH PRIVILEGES;
		+
		+	== MariaDB ==
		+
		+	[https://www.daniloaz.com/en/how-to-create-a-user-in-mysql-mariadb-and-grant-permissions-on-a-specific-database/ User Permissions]

←Older revision		Revision as of 17:20, 6 May 2018
Line 7:		Line 7:
	Grant user database permissions:		Grant user database permissions:
	grant all on dataBaseName.* to userName@localhost identified by 'PASSWORD';		grant all on dataBaseName.* to userName@localhost identified by 'PASSWORD';
		+
		+
		+	== Drop Users ==
		+
		+	Drop User %
		+	drop user username;
		+
		+	Drop User localhost
		+	drop user 'username'@'localhost';
		+
		+	Always flush privileges after modifying users:
		+	FLUSH PRIVILEGES;