"People think focus means saying yes to the thing you've got to focus on. But that's not what it means at all. It means saying no to the hundred other good ideas that there are. You have to pick carefully. I'm actually as proud of the things we haven't done as the things I have done. Innovation is saying no to 1,000 things."

(Steve Jobs - Apple Worldwide Developers' Conference, 1997)

icon Blog Detail

How To Create a New User and Grant Permissions in MySQL

  • Posted: Jan 06, 2014 /
  • By: Admin /
  • Reads : 1,389

How to Create a New User

MySQL is an open source database management software that helps users store, organize, and later retrieve data. It has a variety of options to grant specific users nuanced permissions within the tables and databases—this tutorial will give a short overview of a few of the many options.

Open your shell, login with root account mysql then type

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

Sadly, at this point newuser has no permissions to do anything with the databases. In fact, if newuser even tries to login (with the password, password), they will not be able to reach the MySQL shell.

Notes : for create database you can use

create database [databasename];

then grant user to database with this command

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

 

Back

Headstart your career with us

Find out more about current openings at Rhino Technology