Minor SQL issue

[crudolphy]

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

[till]

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.

[falko]

Have a look here: http://www.howtoforge.com/forums/sho...r1.example.com