It sounds like the username you are trying to access MySQL with is either invalid or doesn't have the CREATE privilege. You can create the new database as root and then go into the MySQL command line as root and run the GRANT query to give your new user access to the database. So it would be:

mysqladmin -u root -p create databasename
(enter the password when prompted)

mysql -u root -p
(again - enter the password when prompted)

And then pick up the instructions right after that.

Jamie Holly
http://www.intoxination.net 
http://www.hollyit.net

On 6/29/2011 7:40 AM, chetan patil wrote:

1)

[chetanpatil@chetanpatil www]$ mysqladmin -u xyz -p create pqr

Enter password: <==============when i entered my to be password then error occurs.

mysqladmin: connect to server at 'localhost' failed

error: 'Access denied for user 'chetanpatil'@'localhost' (using password: YES)'

I get above error.

The root is accessible by:

[chetanpatil@chetanpatil www]$ mysql -u root -h localhost -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 14

Server version: 5.1.56 Source distribution

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

This software comes with ABSOLUTELY NO WARRANTY. This is free software,

and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

2) Do i need to be in useraccount or root account for installing drupal on fedora 14.

Thanks.

--
Chetan Arvind Patil,
+919970018364