Old 4th June 2006, 21:31
crudolphy crudolphy is offline
Join Date: Nov 2005
Location: The Woodlands (Near Houston) Texas USA
Posts: 40
Thanks: 1
Thanked 0 Times in 0 Posts
Default Minor SQL issue

I rebuilt my server using Ubuntu 6.06 LTS server (Dapper Drake) and followed the ISPConfig setup for Ubuntu 5.01 (Breezy). I have also installed the Drupal CMS. So far everthing seems to be working just fine (been up about 1 day).

I followed the "Breezy" How To because the "Dapper" How To hadn't been posted yet. In looking over both How To's this command is in both and it is failing on my setup.

mysqladmin -h crud-03.ccrudolphy.net -u root password mypassword
When I execute this command I get the following message:

mysqladmin: connect to server at 'crud-03.ccrudolphy.net' failed
error: 'Host 'crud-03.ccrudolphy.net' is not allowed to connect to this MySQL server'
I have no problem connecting to the database. I can login at the command line with the mysql command. Additionally I created another db through ISPConfig for Drupal, ran their script to setup the tables, and Drupal connects to the database just fine. I have also setup phpmyadmin and can see and adminster all DB's.

What do you think the problem is

Again thanks for your help.

Chuck Rudolphy
Reply With Quote
Sponsored Links
Old 5th June 2006, 12:39
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

Originally Posted by crudolphy
What do you think the problem is
Thats no problem to worry about. There is just no root user that is allowed to connect from crud-03.ccrudolphy.net.

I recommend to have a look with phpmyadmin in the mysql user table. If every root user has a password, then everything is fine.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Old 5th June 2006, 15:10
falko falko is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,751 Times in 2,581 Posts

Have a look here: http://www.howtoforge.com/forums/sho...r1.example.com
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


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
Apache Setup Issue Using Perfect Setup Suse10.1 E.L. Hibee HOWTO-Related Questions 8 12th June 2006 16:45
DNS issue? nms Installation/Configuration 1 18th February 2006 12:59
ISPCONFIG Logn Issue mainester Installation/Configuration 2 31st January 2006 21:46
Network issue - newbie reddogg Installation/Configuration 1 22nd January 2006 09:03
Outlook 2003 issue with courier-pop3 RotHorseKid Installation/Configuration 6 7th December 2005 21:35

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

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