Aaron Gray wrote:
> I have set the 'root' password for my mysql instillation using :-
>
> SET PASSWORD FOR root = PASSWORD( '###');
>
> Since doing this I can no longer create databases under a new user name and
> password.
>
> I am confused as to how I go about creating and adminstering new users and
> databases.
>
> If someone could set me straight on how to do this please.
>
> Many thanks in advance,
>
> Aaron
>
>
>

The manual is a good place to start...

http://dev.mysql.com/doc/refman/5.1/...ement-sql.html

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================