How To Create a New User and Grant Permissions in MySQL – ubuntu 21.4

How To Create a New User and Grant Permissions in MySQL - ubuntu 21.4
How To Create a New User and Grant Permissions in MySQL – ubuntu 21.4
5/5 - (7 votes)

To grant new user permission in MySQL, you must first log in to your server. in this guide you will learn how to create a user and grant permission to the user

Typically the root user will have been assigned an authentication password when MySQL was installed

Lets Start.

Login to your server using ssh using putty or a local terminal. I used bitvise ssh software.

Once you log-in on to your server simple ty command:

mysql

How to Create a New User

Let’s start by making a new user within the MySQL shell:

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

Therefore, the first thing to do is to provide the user with access to the information they will need.

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

That is. its very simple!

Total
2
Shares
0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
Previous Post
How to setup cron jobs in Ubuntu 21.04

How to setup cron jobs in Ubuntu 21.04

Next Post
How to Install IonCube Loader for WHMCS on Ubuntu

How to Install IonCube Loader for WHMCS on Ubuntu

Related Posts
Total
2
Share
0
Would love your thoughts, please comment.x
()
x