HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   HOWTO-Related Questions (http://www.howtoforge.com/forums/forumdisplay.php?f=2)
-   -   Host is not allowed to connect to this MySQL server'? (http://www.howtoforge.com/forums/showthread.php?t=12606)

mcroteau105 10th May 2007 00:52

Host is not allowed to connect to this MySQL server'?
 
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 10th May 2007 18:46

Take a look here: http://www.howtoforge.com/forums/sho...t+MySQL+server

mcroteau105 14th May 2007 22:03

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

falko 15th May 2007 14:27

If you have ISPConfig installed, you can install phpMyAdmin ( http://www.ispconfig.org/downloads/p...min-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 6th September 2009 10:00

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 7th September 2009 12:52

Quote:

Originally Posted by raytracy (Post 203444)
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_se...pensuse10.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.".


All times are GMT +2. The time now is 04:30.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.