Re: problem connecting php and mysql

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



i have installed php 4.3.10.exe and now the previous error that
mysql_connect() function undefined is not there now. Also i have got
the service of mysql. i checked it with phpinfo()

But now one more problem is coming
that is

Warning: mysql_connect(): Client does not support authentication
protocol requested by server; consider upgrading MySQL client in
D:\PHP\teknohub\new.php on line 13
Could not connect Client does not support authentication protocol
requested by server; consider upgrading MySQL client

what to do for that

Thank you


On 4/26/05, Prathaban Mookiah <prathap@xxxxxxxxxxxx> wrote:
> Hi,
> 
> I had this same problem and I followed the the following instructions found
> in 
> the online manual on installing PHP for windows:
> 
> ================
> 
> If you've run other versions of PHP in the past and are having trouble 
> upgrading to PHP5, particularly in loading the dynamic link library 
> 'php_mysql.dll' (despite following all the guidance in this documentation),
> 
> try the following:
> 
> 1.)  REMOVE old copies of 'libmysql.dll' from your WINDOWS and 
> WINDOWS\system32 folders (check BOTH places).
> 
> 2.)  Verify that your System Path is correctly configured to search the 'C:
> \PHP5' and 'C:\PHP5\ext'.  To do this on WinXP, go to your Control Panel,
> open 
> System, click Advanced tab, click on Environment Variables, under (lower
> pane) 
> 'System variables', select 'Path', and then click Edit.  Your system path 
> should look something like:
> 
> %SystemRoot%\system32;%SystemRoot%; C:\Program Files\MySQL\MySQL Server 4.
> 1\bin;C:\PHP5;C:\PHP5\ext;
> 
> Because the system path checks the Windows and System32 folders for dll's 
> *before* checking the PHP folder, old copies of php_mysql.dll will load up 
> first and foul your PHP initialization if you don't remove them.
> 
> ===============
> 
> Hope this helps.
> 
> Prathap
> 
> ---------- Original Message -----------
> From: rahot man <rahot1983@xxxxxxxxx>
> To: php-general@xxxxxxxxxxxxx
> Sent: Tue, 26 Apr 2005 11:11:38 +0530
> Subject:  problem connecting php and mysql
> 
> > I have windows server 2003, PHPv5.0.3, Mysql v4.1 and IIS 6 and i am
> > working in Macromedia Dreamweaver MX2004
> > 
> > i am unable to connect to the mysql server. but my php files are running
> > fine and my mysql server is also running fine.
> > 
> > i) i had changed the php.ini-dist file to php.ini.
> > ii)i uncommented the extensions of php_mysql.dll in php.ini file
> > iii)i set the extensions_dir to
> >   extension_dir = "D:\PHP\php-5.0.3\ext\" in php.ini file
> > iv)i had copied the libmysql.dll in windows\system32 and windows\system
> > v)i also copied the php_mysql.dll to D:\PHP\
> > 
> > i wrote the following code:
> > <?php
> > $dbhost = "localhost";
> > $dbusername = "root";
> > $dbpassword = "admin";
> > $dbname = "test";
> > $connect = @mysql_connect ( $dbhost,$dbusername,$dbpassword ) or
> > die ("Could not connect ".mysql_error());
> > mysql_select_db($dbname,$connect) or
> > die("Could not select database".mysql_error());
> > ?>
> > 
> > but after all these i am still getting the error
> > Fatal error: Call to undefined function mysql_connect() in
> > D:\PHP\teknohub\new.php on line 14
> > 
> > please help me to solve this problem out
> > 
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> ------- End of Original Message -------
>

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux