[PHP-DB] Activating the mysql_clear_password plugin
Hi everyone, I need to use the mysql_clear_password plugin. I'm using the CentOS php 5.3.3 and manually recompiled the mysql mysqli extensions with the Oracle MySQL 5.5 libraries. According to the MySQL documentation ( http://dev.mysql.com/doc/refman/5.5/en/cleartext-authentication-plugin.html), I need to either set the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN or set the MYSQL_ENABLE_CLEARTEXT_PLUGIN option to the mysql client. I tried to set the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN via a SetEnv in Apache with no results. Could anyone help me setting the MYSQL_ENABLE_CLEARTEXT_PLUGIN option to the mysql client ? Regards, Pierre-Gildas MILLON pg.mil...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Activating the mysql_clear_password plugin
Hi everyone, I need to use the mysql_clear_password plugin. I'm using the CentOS php 5.3.3 and manually recompiled the mysql mysqli extensions with the Oracle MySQL 5.5 libraries. According to the MySQL documentation ( http://dev.mysql.com/doc/refman/5.5/en/cleartext-authentication-plugin.html), I need to either set the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN or set the MYSQL_ENABLE_CLEARTEXT_PLUGIN option to the mysql client. I tried to set the LIBMYSQL_ENABLE_CLEARTEXT_PLUGIN via a SetEnv in Apache with no results. The SetEnv directive sets variables for Apache's internal environment.the I believe the MySQL docs are refering to the Operating System's environment, which would set this globally for the MyQL server. This is probably not what you want to do as you appear to be trying to do this per connection. You could try using mysqli_options(), but I do not know if that supports this setting yet. The PHP documentation does not mention it, and I am unable to test it myself at the moment. Could anyone help me setting the MYSQL_ENABLE_CLEARTEXT_PLUGIN option to the mysql client ? Regards, Pierre-Gildas MILLON pg.mil...@gmail.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Activating the mysql_clear_password plugin
Hi You could try using mysqli_options(), but I do not know if that supports this setting yet. The PHP documentation does not mention it, and I am unable to test it myself at the moment. Just occured to me, even if the setting is not directly supported yet, you can create a separate configuration file for this setting the client to use the plugin (enable-cleartext-plugin) then: mysqli_options(MYSQLI_READ_DEFAULT_FILE,'myother.cnf'); to use those settings on the connection. -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Activating the mysql_clear_password plugin
Hi, Many thanks for your quick answer. I tried what you suggest by modifying the phpMyAdmin code and it works great ! Thank you very much ! Le 27/09/2012 17:55, Niel Archer a écrit : Hi You could try using mysqli_options(), but I do not know if that supports this setting yet. The PHP documentation does not mention it, and I am unable to test it myself at the moment. Just occured to me, even if the setting is not directly supported yet, you can create a separate configuration file for this setting the client to use the plugin (enable-cleartext-plugin) then: mysqli_options(MYSQLI_READ_DEFAULT_FILE,'myother.cnf'); to use those settings on the connection. -- Niel Archer niel.archer (at) blueyonder.co.uk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
