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

[rajbala.3399@gmail.com]

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:113 71/export?id=-832671895013904 3339
--09:39:42--

http://keyserver.veridis.com:11371/export?id=-8326718950139043339

=`pubkey_mysql. asc'
Resolving keyserver.verid is.com... failed: Host not found.

[root@localhost mydb]# gpg --keyserver keyserver.verid is.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.as c
[root@localhost mydb]# rpm --import pubkey_mysql.as c
[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localho st' (using password: NO)'

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

thankyou.
-raju

[Aggro]

Re: 'Access denied for user 'root'@'localho st' (using password: NO)'

rajbala.3399@gm ail.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.

[rajbala.3399@gmail.com]

Re: 'Access denied for user 'root'@'localho st' (using password: NO)'


Aggro wrote:

rajbala.3399@gm ail.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'@'localho st' (using
password: YES)
[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localho st' (using password: NO)'

tankyou
-raju

[rajbala.3399@gmail.com]

Re: 'Access denied for user 'root'@'localho st' (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'@'localho st' (using password: NO)'

Help me for solve above problem.
ThanQ
-raju

[Gordon Burditt]

Re: 'Access denied for user 'root'@'localho st' (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'@'localho st' (using password: NO)'

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

[rajbala.3399@gmail.com]

Re: 'Access denied for user 'root'@'localho st' (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'@'localho st' (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.

[Gordon Burditt]

Re: 'Access denied for user 'root'@'localho st' (using password: NO)'

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

>mysqladmin: connect to server at 'localhost' failed
>error: 'Access denied for user 'root'@'localho st' (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.

[rajbala.3399@gmail.com]

Re: 'Access denied for user 'root'@'localho st' (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'@'localho st' (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.