How to Create New user and Give access to it in mariaDB/MySQL?
1. Go to MySQL Prompt.
mysql -u root -p
2. At MySQL Prompt choose the DB and create the User.
MariaDB [(none)]> use mysql;
MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
3. Now give Privileges to the user. I've Given all privileges to the User.
MariaDB [(none)]> GRANT ALL PRIVILEGES ON * . * TO 'user'@'localhost';
To give any specific user with a permission you use following pattern.
GRANT [type of PRIVILEGES] ON [DB name].[table name] TO '[username]'@'localhost’;
4. Now Flush Privilages to get the Privilages effected.
MariaDB [(none)]> FLUSH PRIVILEGES;
1. Go to MySQL Prompt.
mysql -u root -p
2. At MySQL Prompt choose the DB and create the User.
MariaDB [(none)]> use mysql;
MariaDB [(none)]> CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
3. Now give Privileges to the user. I've Given all privileges to the User.
MariaDB [(none)]> GRANT ALL PRIVILEGES ON * . * TO 'user'@'localhost';
To give any specific user with a permission you use following pattern.
GRANT [type of PRIVILEGES] ON [DB name].[table name] TO '[username]'@'localhost’;
4. Now Flush Privilages to get the Privilages effected.
MariaDB [(none)]> FLUSH PRIVILEGES;
0 Comments