#1  
Old 4th June 2006, 20:31
crudolphy crudolphy is offline
Member
 
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.

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

Code:
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
  #2  
Old 5th June 2006, 11:39
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,069
Thanks: 826
Thanked 5,396 Times in 4,240 Posts
Default

Quote:
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
  #3  
Old 5th June 2006, 14:10
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Have a look here: http://www.howtoforge.com/forums/sho...r1.example.com
__________________
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
Apache Setup Issue Using Perfect Setup Suse10.1 E.L. Hibee HOWTO-Related Questions 8 12th June 2006 15:45
DNS issue? nms Installation/Configuration 1 18th February 2006 11:59
ISPCONFIG Logn Issue mainester Installation/Configuration 2 31st January 2006 20:46
Network issue - newbie reddogg Installation/Configuration 1 22nd January 2006 08:03
Outlook 2003 issue with courier-pop3 RotHorseKid Installation/Configuration 6 7th December 2005 20:35


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


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