How to create new MYSQL user?

Создать анонс-обзор

MySQL is an open-source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users nuanced permissions within the tables and databases—this tutorial will give a short overvie

Просмотр обзора
  1. Home
    2. /
  2. it-programming
    3. /
  3. How to create new MYSQL user?
Author:
Subjects: IT, Programming
datePublished:

Create a New User

mysql> CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';

GRANT ALL PRIVILEGES

mysql> GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';

FLUSH PRIVILEGES

mysql> FLUSH PRIVILEGES;