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

[David Jackson]

Jeff --
Wait, wait I think I got, after making adding users or maybe even changes,
you have to flush-privileges.

I had the same problem after adding user, could figure out why my password
wasn't working?

Dave



> 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
> _______________________________________________
> CLUE-Tech mailing list
> CLUE-Tech at clue.denver.co.us
> http://clue.denver.co.us/mailman/listinfo/clue-tech


--