getting started with mysql [solved]

[Duncan Lithgow]

>try this 
>
>[root at 3e6b36fa ~]# mysqladmin -u root password "newpassword"
>
>Note: the root user for mysql is different than the root(superuser) of Linux.
>          "newpassword" here is the password for the user root.
>
>now you have to login as
>
>[root at 3e6b36fa ~]#  mysql -u root -p
>
>It will ask for the password of the root user(mysql root user) ,give
>the correct password.After successful authentication you will log into
>the mysql prompt
>
>give the access rights to the users.
>
>Regards
>
>Ankush Grover
>
>  
>
I've got phpMyAdmin working with create rights - so things seem to be 
solved now - thanks all.

Duncan