Wrong MySQL password??

[Blu3]

For some reason all 4 times Ive ran the ./setup program for ISPConfig, it states all prerequisites met and when I get to the part where I enter in my MySQL info, the setup program quits and states incorrect password detected???

Ive even tested the password by logging into mysql with that user account and password, and it works fine.

I followed these instructions: http://www.howtoforge.com/perfect_setup_ubuntu_5.10 to the exact letter and am pretty much stumped. Why does it not recognize the mysql login?

TIA

[till]

Does your mysql password contains any special characters like this: !"§$%&/#* ?

[rdmandel]

Till asks if the MySQL password contains special characters - are the characters listed by Till not allowed? And I did use some of them and now what do I do about it?

I have tried all the fixes I can find and am still unable to get the system to accept:
#> mysqladmin -u root password blahblah
mysqladmin: connect to server at 'localhost' failed
"error: access denied for user 'root'@'localhost' failed"

SOMEHOW, USING EVERYTHING I COULD FIND ON THE WEB, I WAS ABLE TO RESET THE PASSWORD TO '' AND THEN RESET IT TO A REAL PASSWORD, SO NOW THAT IS FIXED,

BUT IT STILL WILL NOT RECOGNIZE MY HOSTNAME.

root#> mysqladmin -h GX270.tech-transfer.com -u root password Mand1eMM
ERROR - GX270.tech-transfer.com is not allowed to connect to this MySQL server

and
root#> telnet gx270.tech-transfer.com 3306
connects then Phost says 'GX270.tech-transfer.com' is not allowed to connect to this MySQL server. Closed by foreign host

and
root:#>hostname
GX270.tech-transfer.com
and
root:#>hostname -f
GX270.tech-transfer.com

[falko]

What's the output of

netstat -tap

?

[rdmandel]

netstat - tap shows what it is supposed to show as per the how-to with some strangeness:
1) I have uninstalled mysql, but it still shows up;
2) it shows my host as GX270.tech-trans:domain when the hostname and hostname -f commands show the proper name (GX270.tech-transfer.com) but maybe this is an abrreviation for the netstat format.

tcp 0 0 *:mysql *:* LISTEN 3829/mysqld
tcp 0 0 *:ftp *:* LISTEN 4138/proftpd: (acce
tcp 0 0 GX270.tech-trans:domain *:* LISTEN 3671/named
tcp 0 0 localhost:domain *:* LISTEN 3671/named
tcp 0 0 *:smtp *:* LISTEN 4039/master
tcp 0 0 localhost:953 *:* LISTEN 3671/named
tcp6 0 0 *:imaps *:* LISTEN 3746/couriertcpd
tcp6 0 0 *op3s *:* LISTEN 3783/couriertcpd
tcp6 0 0 *op3 *:* LISTEN 3763/couriertcpd
tcp6 0 0 *:imap2 *:* LISTEN 3728/couriertcpd
tcp6 0 0 *:www *:* LISTEN 4181/apache2
tcp6 0 0 *:ssh *:* LISTEN 4068/sshd
tcp6 0 0 *:smtp *:* LISTEN 4039/master
tcp6 0 0 ip6-localhost:953 *:* LISTEN 3671/named
tcp6 0 0 *:https *:* LISTEN 4181/apache2

And this from ps aux | grep mysql

root 3812 0.0 0.5 2616 1284 ? S 08:29 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 3829 0.0 5.8 101732 14948 ? Sl 08:29 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/GX270.tech-transfer.com.pid --skip-locking
root 3830 0.0 0.1 1548 500 ? S 08:29 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
root 4315 0.0 0.3 2876 792 tty1 R+ 09:10 0:00 grep mysql

[sgrayban]

I had the same issue and installed webmin and added the local hostname to the host table and all was good.

Might want to make sure that localhost is allowed along with setting root's password while you are there.

[falko]

Originally Posted by rdmandel

netstat - tap shows what it is supposed to show as per the how-to with some strangeness:
1) I have uninstalled mysql, but it still shows up;

You have uninstalled MySQL?

Originally Posted by rdmandel

but maybe this is an abrreviation for the netstat format.

Yes, it's an abbreviation.