MySQL on perfect setup CentOS 5.2

Discussion in 'Installation/Configuration' started by spuppy, Jul 25, 2008.

  1. spuppy

    spuppy New Member

    When I enter the command

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

    I get the error:

    mysqladmin: connect to server at 'server1.example.com' failed
    error: 'Host 'server1.example.com' is not allowed to connect to this MySQL server'

    I don't think this will stop my install, but I would like to make sure everything is working perfectly

    Thanks!
     
  2. bolero

    bolero New Member

    localhost? Then simply do not use -h. You try to connect from non-localhost this way and there's likely an ACL to allow only root@localhost.
     
  3. falko

    falko Super Moderator Howtoforge Staff

    IS server1.example.com your hostnme?
    What are the outputs of
    Code:
    hostname -f
    and
    Code:
    netstat -tap | grep mysql
    ?
     
  4. spuppy

    spuppy New Member

    I was just following the instructions directly. They tell you to set your hostname to server1.example.com, so that's what I did. I guess we're supposed to set the hostname again later once everything is installed... Once I do that, I'll see if MySQL can connect.
     
  5. createch

    createch New Member

    .... do you mean you also use "yourrootsqlpassword" instead of using the actual MySQL password in your system too ?
     
  6. falko

    falko Super Moderator Howtoforge Staff

    You should replace server1.example.com with your own hostname.
     
  7. spuppy

    spuppy New Member

    You should update the guide to reflect that. With guides like this, the reader will always follow it to the letter. If you say 'enter this information' people will do just that. So you need to make sure that if the user is entering their own information, that they know to do so.
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    This is already described at the biginning of the howto :)

     
  9. falko

    falko Super Moderator Howtoforge Staff

    I think that the domain name "example.com" implies that...
     

Share This Page