<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
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:<br>
<br>
<br>
mysqladmin -u root -p create databasename<br>
(enter the password when prompted)<br>
<br>
mysql -u root -p<br>
(again - enter the password when prompted)<br>
<br>
And then pick up the instructions right after that.<br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://www.intoxination.net">http://www.intoxination.net</a>
<a class="moz-txt-link-freetext" href="http://www.hollyit.net">http://www.hollyit.net</a></pre>
<br>
On 6/29/2011 7:40 AM, chetan patil wrote:
<blockquote
cite="mid:BANLkTikinCsRh82tYTeEe8Hp4WiH8EFfug@mail.gmail.com"
type="cite">
<div>1)</div>
<div><br>
</div>
<div>[chetanpatil@chetanpatil www]$ mysqladmin -u xyz -p create
pqr</div>
<div>Enter password: <b>
<==============when i entered my to be password
then error occurs.</b></div>
<div>mysqladmin: connect to server at 'localhost' failed</div>
<div>error: 'Access denied for user 'chetanpatil'@'localhost'
(using password: YES)'</div>
<div><br>
</div>
<div>I get above error.</div>
<div><br>
</div>
<div>The root is accessible by:</div>
<div><br>
</div>
<div>[chetanpatil@chetanpatil www]$ mysql -u root -h localhost -p</div>
<div>Enter password: </div>
<div>Welcome to the MySQL monitor. Commands end with ; or \g.</div>
<div>Your MySQL connection id is 14</div>
<div>Server version: 5.1.56 Source distribution</div>
<div><br>
</div>
<div>Copyright (c) 2000, 2010, Oracle and/or its affiliates. All
rights reserved.</div>
<div>This software comes with ABSOLUTELY NO WARRANTY. This is free
software,</div>
<div>and you are welcome to modify and redistribute it under the
GPL v2 license</div>
<div><br>
</div>
<div>Type 'help;' or '\h' for help. Type '\c' to clear the current
input statement.</div>
<div><br>
</div>
<div>mysql> </div>
<div><br>
</div>
<div>2) Do i need to be in useraccount or root account for
installing drupal on fedora 14.</div>
<div><br>
</div>
<div><br>
</div>
<div>Thanks.</div>
<div><br>
</div>
<div><br>
</div>
-- <br>
Chetan Arvind Patil,<br>
+919970018364<br>
<br>
<br>
<br>
</blockquote>
</body>
</html>