Click here to get back home

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

 HomeNewsGroups | Search | About
 mailing.database.mysql    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
'Access denied for user 'root'@'localhost' (using password: NO)' rajbala.3399@gmail.com 11-13-2006
Get Chitika Premium
Posted by rajbala.3399@gmail.com on November 13, 2006, 11:39 pm
Please log in for more thread options

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=-8326718950139043339
=> `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


Posted by Aggro on November 14, 2006, 5:59 pm
Please log in for more thread options
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.

Posted by rajbala.3399@gmail.com on November 14, 2006, 11:35 pm
Please log in for more thread options

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


Posted by rajbala.3399@gmail.com on November 20, 2006, 1:32 am
Please log in for more thread options

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


Posted by Gordon Burditt on November 20, 2006, 7:39 pm
Please log in for more thread options
> 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).



Similar ThreadsPosted
Access denied for user 'ODBC'@'localhost' (using password: NO) February 4, 2006, 1:10 am
Localhost denied access HELP! :) August 8, 2006, 10:47 am
how do I reset user "root" password ? February 12, 2006, 8:12 pm
installing perl on mysql on suse 9.3 - error because root user has password July 21, 2005, 11:56 am
Access denied for user April 13, 2006, 5:16 pm
ERROR 1045: Access denied for user July 4, 2005, 11:10 am
Forget root password August 30, 2006, 4:53 am
root user without privileges? September 18, 2006, 8:42 am
User ID and Password for querying TextLink database October 17, 2005, 4:40 pm
hosted mysql user access problem December 19, 2005, 9:07 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap