solved : Re: system : Install Mysql 5.x binaries with php4 on Debian
Thank you Ian, I used the link method {the least change} { It turned that the mysql.sock was in /tmp , I missed it because I tried to find it with the "locate" command } Create a symbolic link from the mysql.sock to the place where php expects to find it: ln -s /current/location/mysql.sock /new/location/mysql.sock AND THEN I run in a little snag : Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in ... I SOLVED it thanks to google, with : mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('the_password') WHERE User='the_user'; regards to all, this list is great, mysql too. - gilles - On 13 Dec 2006 at 18:59, Gilles MISSONNIER wrote: Hello, I use Debian Linux, and I could install (with apt-get install) fine the Mysql-4.1+apache+php4. I tried fine Mysql 5. on the same debian machine. Now I want to use mysql 5. through web/php4 Then I run into problem, like : Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /var/www/test/t1.php on line 9 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/test/t1.php on line 10 from script.php : connexion a la base refuse the tool "my_print_defaults" doesn't help. any hint? Hi, First of all, is the mysql server running? If not then the mysql.sock socket file will not be created. If it is, then its probably in a different location to the one that php expects to find it. In which case you have several choices: Change 'mysql.default_socket =' in php.ini to point at the real location of mysql.sock (check with the php.net site to make sure that this option has not changed in the version you have). Change the location that mysql puts the socket file in my.ini (see the manual on dev.mysql.com for the exact syntax). Create a symbolic link from the mysql.sock to the place where php expects to find it: ln -s /current/location/mysql.sock /new/location/mysql.sock I consider the latter the best option as it wont break anything else that depends on the socket. Regards Ian -- _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: system : Install Mysql 5.x binaries with php4 on Debian
On 13 Dec 2006 at 18:59, Gilles MISSONNIER wrote: > Hello, > I use Debian Linux, and I could install (with apt-get install) fine > the Mysql-4.1+apache+php4. > > I tried fine Mysql 5. on the same debian machine. > > Now I want to use mysql 5. through web/php4 > > Then I run into problem, like : > > Warning: mysql_connect(): Can't connect to local MySQL server through > socket '/var/run/mysqld/mysqld.sock' (2) in > /var/www/test/t1.php on line 9 > > Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link > resource in /var/www/test/t1.php on line 10 > from script.php : connexion a la base refuse > > the tool "my_print_defaults" doesn't help. > > any hint? Hi, First of all, is the mysql server running? If not then the mysql.sock socket file will not be created. If it is, then its probably in a different location to the one that php expects to find it. In which case you have several choices: Change 'mysql.default_socket =' in php.ini to point at the real location of mysql.sock (check with the php.net site to make sure that this option has not changed in the version you have). Change the location that mysql puts the socket file in my.ini (see the manual on dev.mysql.com for the exact syntax). Create a symbolic link from the mysql.sock to the place where php expects to find it: ln -s /current/location/mysql.sock /new/location/mysql.sock I consider the latter the best option as it wont break anything else that depends on the socket. Regards Ian -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
system : Install Mysql 5.x binaries with php4 on Debian
Hello, I use Debian Linux, and I could install (with apt-get install) fine the Mysql-4.1+apache+php4. I tried fine Mysql 5. on the same debian machine. Now I want to use mysql 5. through web/php4 Then I run into problem, like : Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /var/www/test/t1.php on line 9 Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/www/test/t1.php on line 10 from script.php : connexion a la base refuse the tool "my_print_defaults" doesn't help. any hint? thank you _-¯-_-¯-_-¯-_-¯-_ Gilles Missonnier IAP - [EMAIL PROTECTED] 01 44 32 81 36 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]