Re: USER and MYSQL

[Malcolm Hutty]

> hi all:
>      I am a beginner!
>      I want to know how to create USER and   set  PASSWORD using mysql!

The need to use the password function threw me when I tried 
setting privileges the first time.i.e.

Use:

insert into user (host,user,password) values 
('localhost','me',password('mypassword'));

as opposed to:

insert into user (host,user,password) values 
('localhost','me','mypassword');