Forum : How to create MYSQL new users?
Brief description  about Online courses   join in Online courses
View Abhijit  Paul 's Profile

How to create MYSQL new users?

hi,
Can any body explain, how to create the mysql new users..
Asked by Abhijit Paul | Mar 17, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Hi Abhijit Paul,

on your command prompt and at the mysql\bin directory type the following:
c:\mysql\bin>mysql --user=root mysql

this will log you into mysql as the root user, which is the default user, then type the following:

mysql> GRANT ALL PRIVILEGES ON *.* TO monty@localhost
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTION;

this will add the new user and setup the privileges of that user.

Jul 26, 2010