"Access denied for user "root"@"localhost" (using password: NO)"

Hi ,
I want to download sql in my linux system...........

[root@localhost mydb]# rpm -ivh
MySQL-server-5.0.24a-0.glibc23.i386.rpm MySQL-cl
ient-5.0.24a-0.glibc23.i386.rpm
Preparing... ###########################################
[100%]
package MySQL-client-5.0.24a-0.glibc23 is already installed
package MySQL-server-5.0.24a-0.glibc23 is already installed
[root@localhost mydb]# ls
MySQL-client-5.0.24a-0.glibc23.i386.rpm
MySQL-server-5.0.24a-0.glibc23.i386.rpm
[root@localhost mydb]# rpm -q MySQL-server MySQL-client
MySQL-server-5.0.24a-0.glibc23
MySQL-client-5.0.24a-0.glibc23
[root@localhost mydb]# wget --output-document=pubkey_mysql.asc
http://keyserver. veridis.com:11371/export?id=-8326718950139043339
--09:39:42--
http://keyserver.veridis.com:11371/export?id=-83267189501390 43339
=> `pubkey_mysql.asc'
Resolving keyserver.veridis.com... failed: Host not found.

[root@localhost mydb]# gpg --keyserver keyserver.veridis.com --recv-key
5072e1f5 gpg: can't get key from keyserver: Resource temporarily
unavailable
gpg: Total number processed: 0
[root@localhost mydb]# gpg --export -a 5072e1f5 > pubkey_mysql.asc
[root@localhost mydb]# rpm --import pubkey_mysql.asc
[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

please help me to download sql.........

thankyou.
-raju

Re: "Access denied for user "root"@"localhost" (using password: NO)"

rajbala.3399@gmail.com wrote:

> I want to download sql in my linux system...........

Unless you absolutely need some specific version that can't be found
from the package system of your Linux distribution, for that question,
you get best help from the support forums of your Linux distribution.
For example on Ubuntu, installing MySQL requires this:
sudo apt-get update
sudo apt-get install mysql-server

You can of course do that from GUI also, by searching the mysql server
package and marking it for installation. For other distributions, there
should be as simple methods for them too.

> [root@localhost mydb]# mysqladmin -u root password 'sait123'

Try this and it should ask you for the password:

mysqladmin -u root -p

It is not recommended to enter the password directly to the commandline,
as it is visible to other users.

Re: "Access denied for user "root"@"localhost" (using password: NO)"

Aggro wrote:
> rajbala.3399@gmail.com wrote:
>
> > I want to download sql in my linux system...........
>
> Unless you absolutely need some specific version that can't be found
> from the package system of your Linux distribution, for that question,
> you get best help from the support forums of your Linux distribution.
> For example on Ubuntu, installing MySQL requires this:
> sudo apt-get update
> sudo apt-get install mysql-server
>
> You can of course do that from GUI also, by searching the mysql server
> package and marking it for installation. For other distributions, there
> should be as simple methods for them too.
>
> > [root@localhost mydb]# mysqladmin -u root password 'sait123'
>
> Try this and it should ask you for the password:
>
> mysqladmin -u root -p
>
> It is not recommended to enter the password directly to the commandline,
> as it is visible to other users.

hi,
i tried your command. the result is seem's like below .........

[root@localhost mydb]# mysqladmin -u root -p

mysqladmin Ver 8.41 Distrib 5.0.24a, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license


Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....
-c, --count=# Number of iterations to make. This works with -i
(--sleep) only.
-#, --debug[=name] Output debug log. Often this is 'd:t:o,filename'.
-f, --force Don't ask for confirmation on drop database; with
multiple commands, continue even if an error
occurs.
-C, --compress Use compression in server/client protocol.
--character-sets-dir=name
Directory where character sets are.
--default-character-set=name
Set the default character set.
-?, --help Display this help and exit.
-h, --host=name Connect to host.
-p, --password[=name]
Password to use when connecting to server. If
password is
not given it's asked from the tty.
................
....................
......................

I had following commands also. i got error

[root@localhost mydb]# mysql -uroot -psait123
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

tankyou
-raju

Re: "Access denied for user "root"@"localhost" (using password: NO)"

Hi ,
I am still having problem in downloading the sql in linux..

[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Help me for solve above problem.
ThanQ
-raju

Re: "Access denied for user "root"@"localhost" (using password: NO)"

> I am still having problem in downloading the sql in linux..
>
> [root@localhost mydb]# mysqladmin -u root password 'sait123'
>mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user 'root'@'localhost' (using password: NO)'

Does root *ALREADY* have a password? If so, use it (the old one).

Re: "Access denied for user "root"@"localhost" (using password: NO)"

Gordon Burditt wrote:
> > I am still having problem in downloading the sql in linux..
> >
> > [root@localhost mydb]# mysqladmin -u root password 'sait123'
> >mysqladmin: connect to server at 'localhost' failed
> >error: 'Access denied for user 'root'@'localhost' (using password: NO)'
>
> Does root *ALREADY* have a password? If so, use it (the old one).

I dont Know what is that problem. I am able to enter in super user by
using password.

Re: "Access denied for user "root"@"localhost" (using password: NO)"

>> > [root@localhost mydb]# mysqladmin -u root password 'sait123'
>> >mysqladmin: connect to server at 'localhost' failed
>> >error: 'Access denied for user 'root'@'localhost' (using password: NO)'
>>
>> Does root *ALREADY* have a password? If so, use it (the old one).
>
>I dont Know what is that problem. I am able to enter in super user by
>using password.

Your command line above does not include the old root password.
And from the error message, that's probably why it didn't work.

Re: "Access denied for user "root"@"localhost" (using password: NO)"

Gordon Burditt wrote:
> >> > [root@localhost mydb]# mysqladmin -u root password 'sait123'
> >> >mysqladmin: connect to server at 'localhost' failed
> >> >error: 'Access denied for user 'root'@'localhost' (using password: NO)'
> >>
> >> Does root *ALREADY* have a password? If so, use it (the old one).
> >
> >I dont Know what is that problem. I am able to enter in super user by
> >using password.
>
> Your command line above does not include the old root password.
> And from the error message, that's probably why it didn't work.



ok leave my old password. How can i enter by using password in
mysql. I tried to create new password but it give the same problem..
i.e , Acess denied for user root ....
how can i enter in mysql and use mysql.