How to create (add new) a MySQL user in command line

Question

How can i easily create a new mysql user using command line?

When you are setting up your MySQL you need to create new users. Using the command line you can do it easily.

Answer

First create your database if it’s not done yet. Then create your mysql user.

create database mynewdb;

What you need to replace:

  • mynewdb : the name of the database
  • some_table : the name of the table
  • localhost : the host of your database, in my case everything is on the same server
  • user1 : the name of your mysql user
  • @s3cur3PWD : the password of your user

A user who can access all tables in a given database

grant all privileges on mynewdb.* to 'user1'@'localhost' identified by "@s3cur3PWD";

A user who can access all databases

grant all privileges on *.* to 'user1'@'localhost' identified by "@s3cur3PWD";

A user who can access a given table in a given database

grant all privileges on mynewdb.some_table to 'user1'@'localhost' identified by "@s3cur3PWD";