Minor SQL issue

Discussion in 'Installation/Configuration' started by crudolphy, Jun 4, 2006.

  1. crudolphy

    crudolphy New Member

    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:confused:

    Again thanks for your help.

    Chuck Rudolphy
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
  3. falko

    falko Super Moderator Howtoforge Staff

Share This Page