[Asterisk-Users] Problem in MySql-3.23.49

[DIPAK PAUL]

Hi

I am a user of Asterisk-0.5.0. I am a final year student of MCA in IGNOU.All 
the system are running in  Red Hat-7.3 OS. I am able to transfered call in 
the following procedures:

PSTN(INDIA)>>Mediatrix 1204>>Asterisk server>> VOCAL server>>Mediatrix 
1204>>PSTN(USA)

Now I want to save the cdr data in my Asterisk box.I am using RedHat-7.3 OS.

I am using the command "mysql -u user" to access mysql promt in the Konsole,
When I am trying to create the root's password by using the command

"SET PASSWORD FOR root=PASSWORD("password");"

The Konsole give the error message.
ERROR 1044: Access denied for user: '@localhost' to database 'mysql'

And also when I am trying to create a user by using the command

"GRANT ALL PRIVILEGES ON *.* TO asteriskcdrdb at localhost IDENTIFIED BY 
"password" WITH
GRANT OPTION;"

The Konsole give the error message
ERROR 1045: Access denied for user: '@localhost' (Using password: NO)


Please help me to create user with password, database and grant to access 
all works.

Thanks.

Dipak;

_________________________________________________________________
Are you an Elvis fan? Want to visit Heartbreak Hotel? 
http://server1.msn.co.in/sp03/elvis/ Here's how you can win a trip!