You are not logged in.

#1 2006-02-14 22:44:43

mauz
Member
From: Medellín, Antioquia, COLOMBIA.
Registered: 2005-02-19
Posts: 31
Website

MYSQL CONECT ERROR!

Hi all!
When a try to execute:
#mysqladmin -u root password 'roots_password'
I get this error:
mysqladmin:conect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost'

Do i have to configure the /etc/hosts.allow?
How can i do it?

Thaks...

Offline

#2 2006-02-15 00:13:52

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: MYSQL CONECT ERROR!

mysql -uroot -ppassword

looks like your syntax is wrong. i think mysqladmin uses the same syntax as mysql itself.. try mysql and see if that works.


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#3 2006-02-15 01:03:21

mauz
Member
From: Medellín, Antioquia, COLOMBIA.
Registered: 2005-02-19
Posts: 31
Website

Re: MYSQL CONECT ERROR!

it seems that the problem is in the configuration of /etc/hosts.allow file.
untitled7lr.th.png

What do you think  Archers?

Offline

#4 2006-02-15 09:42:50

mezcal
Member
From: Czech Republic
Registered: 2006-01-31
Posts: 67
Website

Re: MYSQL CONECT ERROR!

i have written in hosts.allow

mysqld: ALL : ALLOW

Offline

#5 2006-02-15 12:33:26

mauz
Member
From: Medellín, Antioquia, COLOMBIA.
Registered: 2005-02-19
Posts: 31
Website

Re: MYSQL CONECT ERROR!

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

Offline

#6 2006-02-15 13:44:11

elasticdog
Member
From: Washington, USA
Registered: 2005-05-02
Posts: 995
Website

Re: MYSQL CONECT ERROR!

If that's a screenshot of exactly what you typed in, then don't put the word 'password' in there...do this:

$ mysql -u root -p

...and then it will prompt you to put in the correct password for the root MySQL user.  Unless of course your password is <code>password</code>.

Offline

#7 2006-02-16 03:39:33

mauz
Member
From: Medellín, Antioquia, COLOMBIA.
Registered: 2005-02-19
Posts: 31
Website

Re: MYSQL CONECT ERROR!

It still prompt the same think:
Access denied for user 'root' @'localhost' (using password: YES)

Offline

Board footer

Powered by FluxBB