MySQL error during setup

[jon335]

I keep getting this error:
Host 'localhost.localdomain' is not allowed to connect to this MySQL server
after I enter the MySQL information.

I have tried it on several machines and I keep getting this error on all of them. :confused: :eek: :confused:

I'm using the Debian Sarge Perfect Setup.

[falko]

I keep getting this error:
Host 'localhost.localdomain' is not allowed to connect to this MySQL server
after I enter the MySQL information.

I have tried it on several machines and I keep getting this error on all of them. :confused: :eek: :confused:

I'm using the Debian Sarge Perfect Setup.
This has changed in Debian Sarge since I've written the tutorial. :(
Open /etc/mysql/my.cnf and comment out the line
bind-address = 127.0.0.1
Then restart MySQL.

[jon335]

I tried that but I still keep getting this error:
ERROR 1045: Access denied for user: 'root@localhost.localdomain'

Would using a different Perfect Setup (i.e. another operating system) work?? If so which would you reccomend?

:mad: :confused: :confused: :mad:

[falko]

I tried that but I still keep getting this error:
ERROR 1045: Access denied for user: 'root@localhost.localdomain'

Would using a different Perfect Setup (i.e. another operating system) work?? If so which would you reccomend?

:mad: :confused: :confused: :mad:

Can you open the database mysql with phpMyAdmin and have a look at the user table? Is there an entry for root and localhost.localdomain?

[jon335]

I haven't gotten phpMyAdmin installed, because this error occurs during ISPConfig setup.

[falko]

I haven't gotten phpMyAdmin installed, because this error occurs during ISPConfig setup.
You can run apt-get install phpmyadmin or get phpMyAdmin from www.phpmyadmin.net and install it manually under /var/www.

You can then reach it under http://<your IP address>/phpmyadmin/

[jon335]

I looked around in the forums here and tried using a blank MySQL password. It worked. Thanks for your help.