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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th July 2008, 04:51
spuppy spuppy is offline
Member
 
Join Date: Aug 2007
Posts: 74
Thanks: 5
Thanked 0 Times in 0 Posts
Default MySQL on perfect setup CentOS 5.2

When I enter the command

mysqladmin -h server1.example.com -u root password yourrootsqlpassword

I get the error:

mysqladmin: connect to server at 'server1.example.com' failed
error: 'Host 'server1.example.com' is not allowed to connect to this MySQL server'

I don't think this will stop my install, but I would like to make sure everything is working perfectly

Thanks!
Reply With Quote
Sponsored Links
  #2  
Old 25th July 2008, 13:17
bolero bolero is offline
Senior Member
 
Join Date: Apr 2008
Posts: 114
Thanks: 2
Thanked 8 Times in 8 Posts
Default

localhost? Then simply do not use -h. You try to connect from non-localhost this way and there's likely an ACL to allow only root@localhost.
Reply With Quote
  #3  
Old 25th July 2008, 14:15
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

IS server1.example.com your hostnme?
What are the outputs of
Code:
hostname -f
and
Code:
netstat -tap | grep mysql
?
__________________
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
  #4  
Old 26th July 2008, 03:10
spuppy spuppy is offline
Member
 
Join Date: Aug 2007
Posts: 74
Thanks: 5
Thanked 0 Times in 0 Posts
Default

I was just following the instructions directly. They tell you to set your hostname to server1.example.com, so that's what I did. I guess we're supposed to set the hostname again later once everything is installed... Once I do that, I'll see if MySQL can connect.
Reply With Quote
  #5  
Old 26th July 2008, 03:25
createch createch is offline
Senior Member
 
Join Date: Aug 2007
Posts: 118
Thanks: 24
Thanked 16 Times in 13 Posts
Default

.... do you mean you also use "yourrootsqlpassword" instead of using the actual MySQL password in your system too ?
Reply With Quote
  #6  
Old 26th July 2008, 12:18
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
Default

Quote:
Originally Posted by spuppy View Post
They tell you to set your hostname to server1.example.com, so that's what I did.
You should replace server1.example.com with your own hostname.
__________________
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
The Following User Says Thank You to falko For This Useful Post:
spuppy (26th July 2008)
  #7  
Old 26th July 2008, 18:42
spuppy spuppy is offline
Member
 
Join Date: Aug 2007
Posts: 74
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko View Post
You should replace server1.example.com with your own hostname.
You should update the guide to reflect that. With guides like this, the reader will always follow it to the letter. If you say 'enter this information' people will do just that. So you need to make sure that if the user is entering their own information, that they know to do so.
Reply With Quote
  #8  
Old 26th July 2008, 18:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,501 Times in 4,330 Posts
Default

This is already described at the biginning of the howto

Quote:
In this tutorial I use the hostname server1.example.com with the IP address 192.168.0.100 and the gateway 192.168.0.1. These settings might differ for you, so you have to replace them where appropriate.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 27th July 2008, 19:02
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,745 Times in 2,578 Posts
 
Default

Quote:
Originally Posted by spuppy View Post
You should update the guide to reflect that.
I think that the domain name "example.com" implies that...
__________________
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
The Perfect Server - CentOS 5.2 VMware Guest pg001 HOWTO-Related Questions 3 26th July 2008 12:32
The Perfect Setup - CentOS 4.3 (64-bit) Questions Sammy HOWTO-Related Questions 3 18th March 2008 16:50
Centos 5.x/ZM 1.23.1 Setup Guide oakleeman Suggest HOWTO 1 18th February 2008 14:49
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Perfect Setup Centos 4.4 MySQL Error formadmirer Installation/Configuration 2 19th April 2007 02:09


All times are GMT +2. The time now is 11:33.


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