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
root user will have been assigned an authentication password when MySQL was installed
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:
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!