[CLUE-Tech] MySQL + PHP 4.2 --> localhost.localdomain cannot connect?

[Jeffery Cann]

Weird,

I must have screwed something up because I did this:

  $ mysqladmin -h localhost -u root -p flush-privileges

and now the script connects.

Thanks for the example.
Jeff

On Monday 29 April 2002 07:34 pm, David Jackson wrote:
> Jeff --
> Does you connect.inc look like this, this returns more usefull error
> messages?
>
>
> <?php
> // database connect script
> $dbhostname = "localhost";
> $dbuser = "my_user_name";
> $dbpasswd = "my_password";
> $dbname= "my_db_name";
> $link = mysql_connect("$dbhostname", "$dbuser", "$dbpasswd")
>         or die("Connection to server: $dbhostname FAILED!!");
> mysql_select_db("$dbname")
>         or die("Connection to database: $dbname FAILED!!");
> ?>
>
>
> David
>
> > Greetings.
> >
> > I upgraded to PHP 4.2.0,  statically linked into apache.  When I try to
> >  connect to a MySQL database via a PHP script, PHP replies:
> >
> >    Warning: Host 'localhost.localdomain' is not allowed to connect  to
> >    this MySQL server ...
> >
> > Isn't that interesting?
> >
> > mysql> select host, user from user;
> > +-----------+---------+
> >
> > | host      | user    |
> >
> > +-----------+---------+
> >
> > | localhost | phpesp  |
> >
> > +-----------+---------+
> >
> > I was running PHP 4.0.0 and this script connected with MySQL, ran
> > statements,  etc.  Nothing on the MySQL side changed.  The PHP script
> > passes 'localhost'  for the host name to the MySQL connection.
> >
> >   $db = mysql_connect('localhost','phpesp','php134esp');
> >
> > Nothing turned up on Google except a thread in the Zend/Development
> > list  --  someone observed the same behaviour, but no causes or
> > workarounds were  reported.
> >
> > On a lark, I changed the HOST column for this user from 'localhost' to
> > 'localhost.localdomain' to no avail -- this doesn't work even via the
> > 'mysql'  command line.
> >
> > mysql> select host, user from user;
> > +-----------------------+---------+
> >
> > | host                  | user    |
> >
> > +-----------------------+---------+
> >
> > | localhost.localdomain | phpesp  |
> >
> > +-----------------------+---------+
> >
> > Next, I updated the db table for the 'phpesp' database:
> >
> > mysql> select host,db from db;
> > +-----------------------+------------+
> >
> > | host                  | db         |
> >
> > +-----------------------+------------+
> >
> > | localhost.localdomain | phpesp     |
> >
> > +-----------------------+------------+
> >
> > Still denied!  I am stumped and appreciate any suggestions.
> >
> > Gracias,
> > Jeff
> > _______________________________________________
> > CLUE-Tech mailing list
> > CLUE-Tech at clue.denver.co.us
> > http://clue.denver.co.us/mailman/listinfo/clue-tech