Try:
/usr/bin/mysql -uroot

then when you're connected type:

grant all on *.* to root@localhost identified by 'newpassword';
flush privileges;

and that should work
----
Andrei Cojocaru
[EMAIL PROTECTED]
----- Original Message -----
From: "Suresh Pun" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 20, 2002 6:59 AM
Subject: MySQL new-bee...


> Hi
>  I have installed mysql server and client version using command.
>
> # rpm -i MySQL-3.23.49a-1.i386.rpm MySQL-client-3.23.49a-1.i386.rpm
>
> I am trying to change root password but i am not able to change it.
>
> # /usr/bin/mysqladmin -u root -p password new-password
> Enter password:                           (   I just pressed Enter here )
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password:NO)'
>
> #
> The above error come's wether I press Enter or type anything.
> Pls help me .
>
> Suresh.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to