MySQL error during setup

Discussion in 'Installation/Configuration' started by jon335, Oct 6, 2005.

  1. jon335

    jon335 New Member

    I keep getting this error:
    Code:
    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.
     
    Last edited: Oct 6, 2005
  2. falko

    falko Super Moderator ISPConfig Developer

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

    jon335 New Member

    I tried that but I still keep getting this error:
    Code:
    ERROR 1045: Access denied for user: '[email protected]'
    Would using a different Perfect Setup (i.e. another operating system) work?? If so which would you reccomend?

    :mad: :confused: :confused: :mad:
     
  4. falko

    falko Super Moderator ISPConfig Developer

    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?
     
  5. jon335

    jon335 New Member

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

    falko Super Moderator ISPConfig Developer

    You can run
    Code:
    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/
     
  7. jon335

    jon335 New Member

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

Share This Page