Hi i am currently trying to get mysql installed so that i can try out XOOPS on my Fedora 6 test box - but when i try to use the command
mysqladmin -u mysql -p create xoops4
to create a new user it asks me for a password for mysql but i haven't given it one yet and when i enter a password i get the following error. I have tried to search google for a solution to it but i couldn't find one.
[root@xoops ~]# mysqladmin -u mysql -p create xoops4
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'mysql'@'localhost' (using password: YES)'
Any help on what i am doing wrong would be greatly appreciated -