How to create MySQL user in Linux server

How to create MySQL user in Linux server

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;

Related posts

Creating a Bootable Installation Media for Ubuntu OS

Secure Your Website with Let’s Encrypt and Nginx: A Step-by-Step Guide

Monitoring Calls with FreeSWITCH CLI: A Comprehensive Guide

3 comments

JamesEpift April 27, 2020 - 7:59 pm
You've got one of the best websites.
Ankit June 19, 2023 - 11:59 am
Very Informative.
Shital July 6, 2023 - 11:25 am
Useful blogs. one of the best blog website.
Add Comment