Host 'webphpsrv' is not allowed to connect to this Mto this MySQL serv

[ponetguy2]

Hello, I'm trying to connect my existing apache2/php5 server to a mysql5 server. Both machines are on thesame network and are both running on Solaris 9 sparc. When I try to connect to the mysql5 server, I get the message below:

Could not connect: Host 'webphpserver' is not allowed to connect to this MySQL server

I already gave permission to webphpserver to the database it's trying to access. I also successfully connected from my pc to the mysql server using mysqladmin application (w2k). Any suggestions?

Thank you in advance.

 

[dodge20]

Try here.

http://www.webyog.com/faq/23_36_en.html

And here

http://dev.mysql.com/doc/refman/5.0/en/connection-access.html

Dodge20

 

[ponetguy2]

thank you for the reply. i figured out the problem. it does'nt make sense, but i fixed it.

it was a mysql permission problem. see below for the solution:

mysql> SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');

i'm running php5 and mysql5. this should'nt be an issue. according to mysql docs, i only need to do this if i'm running php4. weirdness.