How-to create a MySQL database and assign user privileges to it?

Question: How-to create a MySQL database and assign user privileges to it?


NOTE: Please note that this is done in the Command Line Interface.

Answer: 

• First login to the mySql server using root.
  

  mysql -uroot -pROOT_PASSWORD

  Replace ROOT_PASSWORD with the password for the root user.
• Once logged in we create a new database called TEST_DB replace with your database name
  

  create database TESTDB;
  Query OK, 1 row affected (0.00 sec)

• We grant access privileges to user MYUSER to connect to the mysql server from localhost using the password MYPASSWORD
  

  grant usage on *.* to MYUSER@localhost identified by 'MYPASSWORD';
  Query OK, 0 rows affected (0.00 sec)

• Now we grant all privileges to MYUSER on the database TESTDB
  

  grant all privileges on TESTDB.* to MYUSER@localhost ;
  Query OK, 0 rows affected (0.00 sec)

• Type exit to log out
  

  exit;

• Now you can login to TESTDB using user MYUSER and password MYPASSWORD
  

  mysql -u MYUSER -p'MYPASSWORD' TESTDB

• Add New Search
• Comments

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.