Host is not allowed to connect to this MySQL server'?

Discussion in 'HOWTO-Related Questions' started by mcroteau105, May 10, 2007.

  1. mcroteau105

    mcroteau105 New Member

    I am installing ISPConfig on an Ubuntu6.06 distribution. It is desktop version, I used http://www.howtoforge.com/perfect_setup_ubuntu_6.06_p3 for installation instructions. In trying to connect mysql to the server I have set up I get the error :

    'Host 'server2.randrinc.com' is not allowed to connect to this MySQL server'.

    Can someone offer some insight into this issue? I am a junior techie who has hit a brick wall. Im not sure what is causing this problem for me... not sure if I dont have msyql server setup correctly... or my Ubuntu set up right. Any information on this would be most helpful!

    Thanks in advance. Below is the actual shell printout.

    root@server2:~# mysqladmin -h server2.randrinc.com -u root password XXX
    mysqladmin: connect to server at 'server2.randrinc.com' failed
    error: 'Host 'server2.randrinc.com' is not allowed to connect to this MySQL server'
    root@server2:~#
     
  2. falko

    falko Super Moderator Howtoforge Staff

  3. mcroteau105

    mcroteau105 New Member

    How can I access user table

    Still new to all of this... how can I access the mysql user table to alter them accordingly? Thanks in advance

    Mike
     
  4. falko

    falko Super Moderator Howtoforge Staff

    If you have ISPConfig installed, you can install phpMyAdmin ( http://www.ispconfig.org/downloads/phpmyadmin-2.10.1.pkg ) and use it to change the hostname in the mysql.user table. Restart MySQL afterwards (you can also do this with phpMyAdmin - there's a restart link somewhere on the phpMyAdmin welcome page).
     
  5. raytracy

    raytracy New Member

    I have the same problem when follow the howto with a fresh new Centos 5.3 i386, but don't know how to fix it since I have no idea with MySql administration.

    What I concerned is: if many people will jammed in this step, why the author did not fix it to show a correct step for pass it?

    BTW, is there any 'howto' shown step by step to fix this problem?
     
  6. falko

    falko Super Moderator Howtoforge Staff

    This is no problem with the tutorial, but with your hostname configuration.

    Please take a look at chapter 8 on http://www.howtoforge.com/perfect_server_opensuse10.3_p4 , starting with "As you've seen in the netstat output, MySQL is not only listening on localhost, but on all interfaces, which means it can be accessed from the outside.".
     

Share This Page