Create new user in Mysql using Terminal or Command.

Опубликовано: 31 Март 2026
на канале: BUGBUG
21
3

Commands are :-
-- Create user
a - CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
b - grant all privileges on . to 'username'@'localhost';
-List Users :
a - SELECT user FROM mysql.user where user='username';


The MySQL user is a record in the USER table of the MySQL server that contains the login information, account privileges, and the host information for MySQL account. It is essential to create a user in MySQL for accessing and managing the databases.

BUGBUG
bugbug