[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, 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
