Difference between revisions of "Creating MySQL Users/Databases"
| 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] | ||
Latest revision as of 15:10, 15 January 2021
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';
Drop Users
Drop User %
drop user username;
Drop User localhost
drop user 'username'@'localhost';
Always flush privileges after modifying users:
FLUSH PRIVILEGES;
