Home » How to create MySQL user in Linux server

How to create MySQL user in Linux server

by Salman Chawhan
3 comments

1] login in MySQL
mysql -u root -p

2] run the below command replace the value username and password which you want

CREATE USER ‘username’@’localhost’ IDENTIFIED BY ‘password’;
GRANT ALL PRIVILEGES ON
* . * TO ‘username’@’localhost’;

FLUSH PRIVILEGES;

You may also like

3 comments

JamesEpift April 27, 2020 - 7:59 pm

You’ve got one of the best websites.

Reply
Ankit June 19, 2023 - 11:59 am

Very Informative.

Reply
Shital July 6, 2023 - 11:25 am

Useful blogs.
one of the best blog website.

Reply

Leave a Comment

10 − 2 =

Are you sure want to unlock this post?
Unlock left : 0
Are you sure want to cancel subscription?
-
00:00
00:00
Update Required Flash plugin
-
00:00
00:00