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

[mcroteau105]

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:~#

[falko]

Take a look here: http://www.howtoforge.com/forums/showthread.php?t=12455&highlight=allowed+connect+MySQL+server

[mcroteau105]

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

Mike

[falko]

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).

[raytracy]

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?

[falko]

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?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.".