Skip to main content

AssignMySQL_DB_To_User

How to Assign Specific Database to Specific User in MySQL​

  • Login to MySQL with Root User
mysql -u root -p
  • Create New User
Syntax:- CREATE USER 'user_name'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'user_password';
Example:- CREATE USER 'rahul'@'localhost' IDENTIFIED WITH caching_sha2_password BY 'Hello123456#';
  • Create New Database
Syntax:- CREATE DATABASE database_name;
Example:- CREATE DATABASE osmsdb;
  • Verify Created New Database and New User
show databases;
use mysql;
select user from user;
  • Assign Database to Specific user
Syntax:- GRANT ALL PRIVILEGES ON database_name.* TO 'user_name'@'localhost';
Example:- GRANT ALL PRIVILEGES ON osmsdb.* TO 'rahul'@'localhost';
  • Exit from MySQL
exit
  • Restart Apache
service apache2 restart