PHP 4.3 and MySQL

battman21

Hi all,

I am just wondering if anyone out there has started to use the client_flags option that is now available in mysql_connect and mysql_pconnect under PHP 4.3.

If so... how do you use it? I want to do secure mysql connections through SSL from a PHP host to a remote mysql DB and i have an idea that this is where i can do it.

Any ideas?
Thanks

Battman

diego25

According to the documentation at
http://www.php.net/manual/en/function.mysql-connect.php
you'd need to pass MYSQL_CLIENT_SSL as the client_flags argument.

Diego

battman21

Thanks Deigo.. i am blind.. could not see the forest for the trees 😉

Battman

RedDragon

hmm what else important did change from 4.2 to 4.3x ?

ningham

Are the client_flags actually working in PHP 4.3 and 4.3.1? In particular, I'm wanting to only use an SSL connection to MySQL.

mysql_connect($DATABASE,$USER,$PASS,false,MYSQL_CLIENT_SSL);

Works, according to PHP - ie it doesn't error out or generate any warnings, even with my error reporting set to All.

However, when I go into MySQL and grant the user access, but REQUIRE SSL in the grant table, I get an Access denied for user: (Using password: YES). So the username and password are correct, but there's something screwy with the SSL connection.

PHP is comiled with openssl support (0.97a) and mysql (4.0.11a-gamma).

MySQL with vio and openssl as well.

Has anyone gotten this to work? Am I missing some configuration or something?