Perfect Ubuntu 5.10 question (MYSQL)

Discussion in 'HOWTO-Related Questions' started by Lord_Garfield, Aug 31, 2006.

  1. Lord_Garfield

    Lord_Garfield New Member

    Hi all

    After installing mysql with apt get and set the root password I have to set the root password with my hostname like this

    mysqladmin -h server1.wintam.lan -u root password *******

    I get the folowing response

    mysqladmin: connect to server at 'server1.wintam.lan' failed
    error: 'Lost connection to MySQL server during query'

    So I tried
    mysqladmin -h server1 -u root password *******
    this gave me:
    mysqladmin: connect to server at 'server1' failed
    error: 'Host 'localhost.localdomain' is not allowed to connect to this MySQL server'

    How can I fix this?
    What is the cause of this?

    tank you.
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Just skip this command, you can set the password for the second root account later with phpmyadmin.
  3. Lord_Garfield

    Lord_Garfield New Member

    Yes i have readed that to but still. I would like to know the cause of this? Why is the command not working? What are the things I probably have messed up so that command won't work?

    tanks in advance?
  4. falko

    falko Super Moderator ISPConfig Developer

    The command was added later to the tutorial because we had missed it at first. We didn't test it again, so it's possible that it's in the wrong place. However, it should give you the idea what has to be done.

Share This Page