Question about mysql on perfect Debian Setup

[goingininsane]

Hi, been following the Perfect Debian Setup found here:

http://howtoforge.com/perfect_setup_debian_etch

I've made it up to page 4 with mysql. I commented out the bind.address like it says. and I'm trying to set my passwords. Except no matter what i type i keep getting the return "error: 'access denied for user 'root'@'localhost' (using password: NO)'".

I've tried every combination of "mysqladmin -u root 'password' 'passwordiwant'" that i can think, i've typed in every password i've created but i still get this error, and don't want to move on before i get this to work. any help is greatly appreciated.

[White]

you could try

apt-get remove --purge mysql-server mysql-client libmysqlclient15-dev

which will completely remove all instances of mysql

then

apt-get install mysql-server mysql-client libmysqlclient15-dev

and follow the steps again.

i take it you did replace 'yourrootsqlpassword' below with your own password

mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword

[sergio.morales]

My issue is very similar, but I can't get to the step below his. My password is set and all is OK there, but when I try running the:
mysqladmin -h server1.example.com -u root password yourrootsqlpassword

it fails. I think it's because my hostname has a dash in it, but I don't know! This is the error I get:
mysqladmin -h email-bestXXXX.com -u root password mypassword
mysqladmin: connect to server at 'email-bestXXXX.com' failed
error: 'Host 'email-bestXXXX.com' is not allowed to connect to this MySQL server'

The "XXXX" is simply to hide my hostname . . .

Please HELP!!!

[falko]

You can try to correct the hostname in the MySQL database as shown in chapter 8 on http://www.howtoforge.com/perfect_se...pensuse10.3_p4 , beginning with "As you've seen in the netstat output, MySQL is not only listening on localhost, but on all interfaces, which means it can be accessed from the outside. Therefore we need to set a password for the user root@server1.example.com as well. But there's one little problem: most likely the Host column in the mysql.user table doesn't contain server1.example.com, but server1. We will change that now, and afterwards we will set a MySQL password for the user root@server1.example.com."