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:~#
Take a look here: http://www.howtoforge.com/forums/showthread.php?t=12455&highlight=allowed+connect+MySQL+server
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
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).
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?
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.".
