PowerDNS and MySQL

Discussion in 'HOWTO-Related Questions' started by Lazydog, Jul 30, 2011.

  1. Lazydog

    Lazydog New Member

    I am trying to follow PowerDNS with MySQL backend and I am running into an issue I am hoping you can help me with.

    In Step 2 you have to do the following:

    Code:
    mysqladmin -u root password yourrootsqlpassword
    mysqladmin -h server1.example.com -u root password yourrootsqlpassword
    
    The first step I can do but the second give me the following error:

    Code:
    mysqladmin: connect to server at 'vm7.intranetshield.com' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    
    What would be causing this and how can I fix this. I do not have the
    knowledge of MySQL so I am sort of stuck at this point.

    Any help you could provide I would be most thankful.
     
  2. falko

    falko Super Moderator Howtoforge Staff

    I suggest you run
    Code:
    mysql_secure_installation 
    instead of
    Code:
    mysqladmin -u root password yourrootsqlpassword
    mysqladmin -h server1.example.com -u root password yourrootsqlpassword
    to set your password.
     
  3. Lazydog

    Lazydog New Member

    Thnx for the information. It worked nicely. Now I have to figure out SELinux to get things working without setenforce. I do not want to turn off SELinux.
     

Share This Page