Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th May 2007, 00:52
mcroteau105 mcroteau105 is offline
Junior Member
 
Join Date: May 2007
Location: Reno
Posts: 17
Thanks: 3
Thanked 2 Times in 1 Post
Default 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:~#
Reply With Quote
Sponsored Links
  #2  
Old 10th May 2007, 18:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Take a look here: http://www.howtoforge.com/forums/sho...t+MySQL+server
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 14th May 2007, 22:03
mcroteau105 mcroteau105 is offline
Junior Member
 
Join Date: May 2007
Location: Reno
Posts: 17
Thanks: 3
Thanked 2 Times in 1 Post
Default 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
Reply With Quote
  #4  
Old 15th May 2007, 14:27
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

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).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 6th September 2009, 10:00
raytracy raytracy is offline
Junior Member
 
Join Date: Sep 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?
Reply With Quote
  #6  
Old 7th September 2009, 12:52
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
 
Default

Quote:
Originally Posted by raytracy View Post
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.".
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Please enter your MySQL server:localhost The MySQL server you specified cannot be rea Null Installation/Configuration 9 26th March 2007 08:51
550-The recipient cannot be verified email problem safoo Installation/Configuration 7 29th November 2006 19:55
Could not connect to MySQL server! bruma Installation/Configuration 12 15th August 2006 14:49
enter the host name (e.g. www):www - I have a second server tadelste Installation/Configuration 1 26th April 2006 19:51


All times are GMT +2. The time now is 16:20.


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