Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 15th April 2007, 08:43
lwizardl lwizardl is offline
Junior Member
 
Join Date: Sep 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with Ubuntu 6.06 LTS Perfect Guide

Everytime I follow any of the guides (Ubutnu 6.06 LTS, Ubuntu 6.10, or Centos 4.4) I get an error at the exact same place

Quote:
mysqladmin -u root password yourrootsqlpassword
mysqladmin -h server1.example.com -u root password yourrootsqlpassword
the first part goes in just fine but when I add the -h server in front of the user I get this error evertime

unable to connect to server server.tld (will post exact error in few mins I'm sure I'll get it again retrying the install)
*edited to include error

Quote:
mysqladmin -u root password **removed**
mysqladmin -h **removed** -u root password **removed**
mysqladmin: connect to server at '**removed**' failed
error: 'Host '**removed**' is not allowed to connect to this MySQL server'

Last edited by lwizardl; 15th April 2007 at 09:21.
Reply With Quote
Sponsored Links
  #2  
Old 15th April 2007, 12:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

This happens because you don't have server1.example.com in the Host column of the user table in the mysql database.
You can use phpMyAdmin later on to change the hostname and restart MySQL. Afterwards, the command will work.

BTW, did you use the forum's search function? Because this topic has been covered a zillion times here...
__________________
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 16th April 2007, 02:43
lwizardl lwizardl is offline
Junior Member
 
Join Date: Sep 2006
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

thanks for the quick answer. I did browse but I didn't see anything that matched.

James
Reply With Quote
  #4  
Old 16th April 2007, 09:18
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,775
Thanks: 840
Thanked 5,610 Times in 4,421 Posts
 
Default

Quote:
Originally Posted by lwizardl
thanks for the quick answer. I did browse but I didn't see anything that matched.

James
Just make sure that there is no record for user root without password, then everything is fine.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
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
The Perfect Setup - Ubuntu 6.06 LTS Server (Dapper Drake) Q&A NGNZ Installation/Configuration 8 13th June 2008 18:52
The Perfect Setup - Ubuntu 6.06 LTS Server and SPAM Virus Filtering WaveQam HOWTO-Related Questions 5 19th January 2007 23:18
Quota problem on ubuntu 6.06 perfect setup. mandrakethepenguin HOWTO-Related Questions 4 3rd August 2006 17:34
Help with The Perfect Setup - Ubuntu 6.06 LTS Server LinuxNewb HOWTO-Related Questions 6 30th July 2006 14:43
Request: Perfect Ubuntu 6.06 LTS - Automatic LAMP Server Installation (co-location) Anim Suggest HOWTO 19 6th June 2006 12:30


All times are GMT +2. The time now is 13:47.


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