try this
[root@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@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
