How to Create new User Accounts in MySQL Server

If you would ke to creating new user accounts in your MySQL server, using the command below,

Connect to the MySQL server using an existing user with administrative permissions,

mysql -u root -p

Create a new user by running the CREATE USER statement with PASSWORD,

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

Finally, you can use FLUSH PRIVILEGES command to tell the server to reload the grant tables and put new changes into effect:

FLUSH PRIVILEGES;