mysql_connect problem
I am using the following in a PHP script: bash-3.00$ cat mail ?php $connect = mysql_connect(localhost, bp5am, bp5ampass) or ? Which gives the following MySQl error: Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/php_sql/createmovie.php on line 2 Did not connect successfuly to server. I presume this is a MySQL Problem. Any ideas as to what is causing this? Warren Steffen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql_connect problem
Which version is your php and your mysql? WSteffen [EMAIL PROTECTED] escreveu na mensagem news:[EMAIL PROTECTED] I am using the following in a PHP script: bash-3.00$ cat mail ?php $connect = mysql_connect(localhost, bp5am, bp5ampass) or ? Which gives the following MySQl error: Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/php_sql/createmovie.php on line 2 Did not connect successfuly to server. I presume this is a MySQL Problem. Any ideas as to what is causing this? Warren Steffen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql_connect problem
http://dev.mysql.com/doc/refman/5.0/en/old-client.html Regards! Edwin. -Mensaje original- De: WSteffen [mailto:[EMAIL PROTECTED] Enviado el: Miércoles, 28 de Junio de 2006 10:29 a.m. Para: mysql@lists.mysql.com Asunto: mysql_connect problem I am using the following in a PHP script: bash-3.00$ cat mail ?php $connect = mysql_connect(localhost, bp5am, bp5ampass) or ? Which gives the following MySQl error: Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/apache2/htdocs/php_sql/createmovie.php on line 2 Did not connect successfuly to server. I presume this is a MySQL Problem. Any ideas as to what is causing this? Warren Steffen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql_connect() problem
Hi, I am trying to setup network having 1) Linux main server running IPTABLES firewall, squid, dns server. 2) LAN connected to main server. 2) DMZ having apache, mysql and php, mail server connected to main server. User will use php script from remote host to connect to mysql as follows: MYSQL_CONNECT(localhost, abc, abc ) OR DIE(Unable to connect to database); @mysql_select_db(abc) or die(Unable to select database); where local host will be dmz. Is it O.K. if I give all user give host as localhost in script? Will it involve any security problem? If so what is generally done in this type of case. My reverse DNS does not point to my domain instead it point sto domain of Internet bandwidth service porvider. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
mysql_connect() problem
Hi, I am trying to setup network having 1) Linux main server running IPTABLES firewall, squid, dns server. 2) LAN connected to main server. 2) DMZ having apache, mysql and php, mail server connected to main server. User will use php script from remote host to connect to mysql as follows: MYSQL_CONNECT(localhost, abc, abc ) OR DIE(Unable to connect to database); @mysql_select_db(abc) or die(Unable to select database); where local host will be dmz. Is it O.K. if I give all user give host as localhost in script? Will it involve any security problem? If so what is generally done in this type of case. My reverse DNS does not point to my domain instead it point sto domain of Internet bandwidth service porvider. Thanks for support. - Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing
Mysql_connect problem
I'm having a problem with mysql_connect(). Here is the code I am using:
function db_connect() {
global $dbhost, $dbusername, $dbuserpassword, $default_dbname;
global $MYSQL_ERRNO, $MYSQL_ERROR;
$link_id = mysql_connect($dbhost, $dbusername, $dbuserpassword);
if(!$link_id) {
$MYSQL_ERRNO = 0;
$MYSQL_ERROR = Connection failed to the host $dbhost.;
return 0;
}
else if(!mysql_select_db($dbname)) {
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
return 0;
}
else return $link_id;
}
The problem is, that it completely hangs up and times out. I use this
code on many diff websites and servers, but on this particular server
and site, this happens. I have never done anything else on this server,
so I was thinking it might be the settings, but I'm not even sure where
to start. Usually I just get back error message such as invalid password
or user etcbut this completely hangs and times out, just on the
mysql_connect() alone. If I take that out, the page loads up fine, but
of course I can't do any MySQL work. Any help would be appreciated and I
thank you in advance :)
-Chris
Christopher Moreno
Web Developer
http://www.chaosad2000.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
