Problems with mysql 4.0.13
 

Hello everyone! Ok, I have a small problem with mysql. Well firstly I don't know how to stop it. :D Any suggestions? :) And well secondly, I run it as a user(mysql) and when I want to create a new database it always gives me an error:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'
Ok, it's the same if I try it from user and etc. Well I guess the best help would be if someone could point me to some good manual or tutorial. :) Thanks very much advance!

I don't use MySQL, but it looks like MySQL is trying to connect to your computer as root, using the wrong password.

I'm not sure how MySQL is supposed to connect, but you probably need to tell it to connect as a different user.

Ok guys. I almost sort it out, except that: I want to create a new database right? So I run:
mysql -u mysql
because when I run it with user root it gives me an error that I can't conect to the database. So. When I connect to the database I run:
CREATE DATABASE `kknd`;
And then I get an error:
ERROR 1044: Access denied for user: '@localhost' to database 'kknd'
Oofff.... I don't know what to do. My head hurts because all day I've been installing apache, php, SSL and trying to configure mysql. :( Help me out guys, why can't I create a database?