Go to the command line
$mysql -u root -p mysql
mysql> INSERT INTO user
VALUES('localhost','monty',PASSWORD('some_pass'),
'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y')
Make sure to change localhost to % if you want the database to be
accesses from anywhere
Change the username monty to whatever you want
Security
This statement will add a user who has all privileges.
Once you get comfortable make sure to restrict the user to permissions
that are required.
You just might want this user to retrieve data, i.e, only SELECT.
Read the manual for more detail.
Its there at http://www.mysql.com/
deepak yadav wrote:
> is there any other way to add a new user to mysql ?
--
Is wisdom knowing you�ll never know,
Or knowing you�ve always known?
-- Donald Marsh
The mailing list archives are available at
http://lists.linux-india.org/cgi-bin/wilma/linux-delhi/
