[PHP-DB] Cannot connect to MySQL

[The Phantom]

Hello,

First of all, I apologise if I do something wrong, because I'm new to this 
weird system.

For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and MySQL 
5.1.44 on Windows 7 Home Premium. However, whenever I try accessing MySQL via 
PHP, I get the following error:

A connection attempt failed because the connected party did not properly 
respond after a period of time, or established connection failed because 
connected host has failed to respond.

MySQL's command line client is still working fine. I think that PHP simply does 
not see MySQL, though the settings in php.ini seem to be correct. Earlier 
(before I upgraded to Windows 7 and PHP 5.3) it worked. I've tried turning off 
the antivirus, because sometimes it may cause timeouts, but it didn't help. Can 
someone please help me fix this?
  
_
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/201469227/direct/01/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Cannot connect to MySQL

[Gunawan Wibisono]

you install php, apache and mysql one-by-one?
how about try access other db (example: odbc)

On Fri, Mar 5, 2010 at 9:33 PM, The Phantom  wrote:

>
> Hello,
>
> First of all, I apologise if I do something wrong, because I'm new to this
> weird system.
>
> For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and MySQL
> 5.1.44 on Windows 7 Home Premium. However, whenever I try accessing MySQL
> via PHP, I get the following error:
>
> A connection attempt failed because the connected party did not properly
> respond after a period of time, or established connection failed because
> connected host has failed to respond.
>
> MySQL's command line client is still working fine. I think that PHP simply
> does not see MySQL, though the settings in php.ini seem to be correct.
> Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've tried
> turning off the antivirus, because sometimes it may cause timeouts, but it
> didn't help. Can someone please help me fix this?
>
> _
> Hotmail: Trusted email with powerful SPAM protection.
> http://clk.atdmt.com/GBL/go/201469227/direct/01/
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
akan ada dimana mulut terkunci dan suara tak ada lagi..
saat itu gunakanlah HP untuk melakukan SMS!!
-> ini aliran bedul.. bukan aliran aneh.
tertawa sebelum tertawa didepan RSJ..

[PHP-DB] Cannot connect to MySQL using

[Nur_Adman]

Dear All,

 

 

I need some help. I`m trying to connect to MySQL using these script :

 



 

But if I changed the Hostname with the Server Name/IP Address (not using
localhost), the error message become :

 

Warning: mysql_connect() [function.mysql-connect
 ]: Host
'157.47.115.180' is not allowed to connect to this MySQL server in
c:\wamp\www\CMS\forecast\includes\db_connection.php on line 10
Error !! Unable to connect to database

 

 

What should I do?

 

Thanks & Regards,

 

Anita

 

[PHP-DB] cannot connect to mysql on windows

[raj]

Hello,

I have apache 2 and mysql 4.1 and php5 and am unable to connect to mysql 
database server, and keep getting the following error:

Fatal error: Call to undefined function mysql_connect() in 
D:\backup\test.php on line 10

I have removed the semicolon before the line:

extension=php_mysql.dll

I do have the extension at C:/php/ext/
also,  I even have the server running but no luck.

Please help.

Raj

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

RE: [PHP-DB] Cannot connect to MySQL using

[Ralph Brickley]

It looks right on the function use, but you may want to check the
installation of the mySQL service to ensure you have the right setup. There
is normally always a password on root.

Also, I would be a little more careful of pasting your IP Address into a
message forum. I'm sure we are all honest people but you never know. Coupled
with your DB name we can now look at your data if we get in.

You didn't tell us what the error was when using 'localhost' versus the IP
address. What does it say then?

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, March 29, 2006 2:31 PM
To: php-db@lists.php.net
Subject: [PHP-DB] Cannot connect to MySQL using

Dear All,

 

 

I need some help. I`m trying to connect to MySQL using these script :

 



 

But if I changed the Hostname with the Server Name/IP Address (not using
localhost), the error message become :

 

Warning: mysql_connect() [function.mysql-connect
<http://tu-lip-nt4/CMS/forecast/function.mysql-connect> ]: Host
'157.47.115.180' is not allowed to connect to this MySQL server in
c:\wamp\www\CMS\forecast\includes\db_connection.php on line 10
Error !! Unable to connect to database

 

 

What should I do?

 

Thanks & Regards,

 

Anita

 



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

Re: [PHP-DB] Cannot connect to MySQL using

[Chris]

Warning: mysql_connect() [function.mysql-connect
 ]: Host
'157.47.115.180' is not allowed to connect to this MySQL server in
c:\wamp\www\CMS\forecast\includes\db_connection.php on line 10
Error !! Unable to connect to database

 

 


What should I do?


Read the error message, it tells you all you need to know.


Your host (157.47.115.180) is not allowed to connect to that mysql server.


Mysql isn't configured to allow connections using the ip.

http://dev.mysql.com/doc/refman/5.1/en/privilege-system.html

Is a good place to start.

--
Postgresql & php tutorials
http://www.designmagick.com/

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

RE: [PHP-DB] Cannot connect to MySQL using

[Nur_Adman]

If I used "localhost", the script running well.

But if I used Server name or IP address, the error message displayed :

 

Warning: mysql_connect() [function.mysql-connect

<http://tu-lip-nt4/CMS/forecast/function.mysql-connect> ]: Host

'157.47.115.180' is not allowed to connect to this MySQL server in

c:\wamp\www\CMS\forecast\includes\db_connection.php on line 10

Error !! Unable to connect to database

 

 

Thanks & Regards,

Anita

 

 

 

-Original Message-
From: Ralph Brickley [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 30, 2006 7:39 AM
To: Adman, Nur anita; php-db@lists.php.net
Subject: RE: [PHP-DB] Cannot connect to MySQL using

 

It looks right on the function use, but you may want to check the

installation of the mySQL service to ensure you have the right setup.
There

is normally always a password on root.

 

Also, I would be a little more careful of pasting your IP Address into a

message forum. I'm sure we are all honest people but you never know.
Coupled

with your DB name we can now look at your data if we get in.

 

You didn't tell us what the error was when using 'localhost' versus the
IP

address. What does it say then?

 

-Original Message-

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 

Sent: Wednesday, March 29, 2006 2:31 PM

To: php-db@lists.php.net

Subject: [PHP-DB] Cannot connect to MySQL using

 

Dear All,

 

 

 

 

 

I need some help. I`m trying to connect to MySQL using these script :

 

 

 



 

 

 

But if I changed the Hostname with the Server Name/IP Address (not using

localhost), the error message become :

 

 

 

Warning: mysql_connect() [function.mysql-connect

<http://tu-lip-nt4/CMS/forecast/function.mysql-connect> ]: Host

'157.47.115.180' is not allowed to connect to this MySQL server in

c:\wamp\www\CMS\forecast\includes\db_connection.php on line 10

Error !! Unable to connect to database

 

 

 

 

 

What should I do?

 

 

 

Thanks & Regards,

 

 

 

Anita

 

 

 

 

Re: [PHP-DB] Cannot connect to MySQL using

[Balazs Hegedus]

Hi,

did you try to grant the IP address?
I mean:

grant x,y,z on db_name.{table_name|*} to [EMAIL PROTECTED]
identified by 'password';

Hope it helps, cheers,

Balazs

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

RE: [PHP-DB] Cannot connect to MySQL using

[Nur_Adman]

Dear All,

 

I found the way.

 

I opened file --> C:\WINNT\system32\drivers\etc\hosts

Then change :

  127.0.0.1   localhost

become :

157.47.115.180  [my_server_name]

 

Then my problem solved.

 

 

Thanks & Regards,

Anita

Re: [PHP-DB] Cannot connect to MySQL using

[Constantin Wolber]

[EMAIL PROTECTED] wrote:


Then change :

 127.0.0.1   localhost

become :

157.47.115.180  [my_server_name]
 



Changing this line is probably not the best way. This file is used for
resolving the hostnames ti ip adresses. So a better way would probably
be adding the line to the file. Since the entry for localhost should
remain in this file.

Greets Constantin

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

RE: [PHP-DB] Cannot connect to MySQL using

[Nur_Adman]

Thanks so much, Constantin...

 

Regards,

Anita

 

-Original Message-
From: Constantin Wolber [mailto:[EMAIL PROTECTED] 
Sent: Thursday, March 30, 2006 5:44 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] Cannot connect to MySQL using

 

[EMAIL PROTECTED] wrote:

 

>Then change :

> 

>  127.0.0.1   localhost

> 

>become :

> 

>157.47.115.180  [my_server_name]

>  

> 

 

Changing this line is probably not the best way. This file is used for

resolving the hostnames ti ip adresses. So a better way would probably

be adding the line to the file. Since the entry for localhost should

remain in this file.

 

Greets Constantin

 

-- 

PHP Database Mailing List (http://www.php.net/)

To unsubscribe, visit: http://www.php.net/unsub.php

 

[PHP-DB] Cannot connect to MySQL server using MyODBC and unixODBC

[Miroslav Šulc]

Hello,

I have the following problem:

I cannot connect with:
$var=odbc_connect('myodbc-test','root','password');
to my MyODBC data source.

I get this error:
Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Can't open
lib '/usr/lib/libmyodbc3.so' : unknown error, SQL state IM003 in
SQLConnect in /home/httpd/bagr/docs/test.php on line 2

I would appreciate any help or suggestions that could lead me to solve this
problem.

Please see my detailed description at http://bugs.php.net/bug.php?id=26049
(I have submitted this as error and got classification "Bogus").

Thank you for your help.

--
Miroslav Šulc

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

[PHP-DB] Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

[Gunawan Wibisono]

sry.. this kinda other person problem
thx for your support and I kinda found this problem on other place.. Is
posible.. the problem in the windows 7?

On Sun, Mar 7, 2010 at 12:12 AM, Venkat Raman Don
wrote:

> Seems like IPV6 functionality of Windows and MySQL driver is not gelling
> well.
>
> Please see http://bugs.php.net/bug.php?id=50172.
> This is also discussed in MySQL forum at
> http://forums.mysql.com/read.php?52,294772,294772#msg-294772.
>
> Thanks,
> Don.
>
>
> -Original Message-
> From: Lester Caine [mailto:les...@lsces.co.uk]
> Sent: Saturday, March 06, 2010 9:01 AM
> To: php-windows
> Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
>
> Gunawan Wibisono wrote:
> > Hello,
> >
> >  First of all, I apologise if I do something wrong, because I'm new to
> this
> >  weird system.
> >
> >  For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and
> MySQL
> >  5.1.44 on Windows 7 Home Premium. However, whenever I try accessing
> MySQL
> >  via PHP, I get the following error:
> >
> >  A connection attempt failed because the connected party did not properly
> >  respond after a period of time, or established connection failed because
> >  connected host has failed to respond.
> >
> >  MySQL's command line client is still working fine. I think that PHP
> simply
> >  does not see MySQL, though the settings in php.ini seem to be correct.
> >  Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've
> tried
> >  turning off the antivirus, because sometimes it may cause timeouts, but
> it
> >  didn't help. Can someone please help me fix this?
>
> PHP does not come with any database enabled by default, so you will need to
> enable one. For MySQL just look in php.ini for the line
> ;extension=php_mysql.dll
> and remove the ';' at the front, and then restart Apache.
> The first page you should create is
>
>  phpinfo();
> ?>
>
> Which will list all the modules that are active ;)
>
>
>
> --
> Lester Caine - G8HFL
> -
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>


-- 
akan ada dimana mulut terkunci dan suara tak ada lagi..
saat itu gunakanlah HP untuk melakukan SMS!!
-> ini aliran bedul.. bukan aliran aneh.
tertawa sebelum tertawa didepan RSJ..

[PHP-DB] Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

[Pierre Joye]

On Sun, Mar 7, 2010 at 4:36 PM, Gunawan Wibisono  wrote:
> sry.. this kinda other person problem
> thx for your support and I kinda found this problem on other place.. Is
> posible.. the problem in the windows 7?

No, php works fin on windows 7.

Cheers,
-- 
Pierre

@pierrejoye | http://blog.thepimp.net | http://www.libgd.org

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

[PHP-DB] RE: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

[Venkat Raman Don]

Hi,

Let me take a shot at explaining this in simple terms. Most of the Operating 
System today is building support for IPV6. IPV4 has its own set of limitation 
and hence the world is moving to IPV6. I am not going to explain differences 
between two, but for the sake of this discussion assume that they are different.

A close look at PHP MySQL driver code indicates that mysql_connect() function 
uses mysql_real_connect() to connect to MySQL. The API mysql_real_connect() is 
an API which comes from MySQL dll (MySQL development team and is part of MySQL 
database installation). So this means the support for IPV6 in PHP MySQL driver 
is not possible unless there is a support for IPV6 in MySQL database. So the 
limitation (or no support for IPV6 or whatever word may be used to describe 
this situation) is coming from MySQL database limitation. So now it is clear 
that this is not a PHP bug in the sense that nothing can be changed in PHP code 
base to fix it.

Let's move on to operating system concern now. A typical host file 
(irrespective of OS) has two columns which contains the IP address and host 
name binding to it. In order to support both IPV4 and IPV6 (at least on 
Windows) localhost is getting mapped to two IP addresses. There can be other 
reasons for mapping same localhost to multiple IP address. What is important is 
that, there is a case where we have multiple IP address pointing to same host 
name. A close inspection of MySQL code reveals that the function 
mysql_real_connect() actually tries to connect to only the first IP address 
returned for the hostname and if this fails, no further attempt to connect 
using other IP address associated with same host name is made. This can be 
fixed and I believe a patch is already lying in some development branch of 
MySQL and please follow MySQL release to know which version has this fix 
integrated. I do not have any idea about that. But an important thing is that 
this bug can surface on any OS where you have above condition satisfied for the 
host file. Yes WINDOWS, Ubuntu, Solaris all will and may get impacted. So this 
means that this is not a problem with Windows OS or for that reason any other 
OS.

Hope this explain things.

Thanks,
Don.


-Original Message-
From: Gunawan Wibisono [mailto:landavi...@gmail.com] 
Sent: Sunday, March 07, 2010 7:37 AM
To: php-wind...@lists.php.net; php-db@lists.php.net
Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

sry.. this kinda other person problem
thx for your support and I kinda found this problem on other place.. Is
posible.. the problem in the windows 7?

On Sun, Mar 7, 2010 at 12:12 AM, Venkat Raman Don
wrote:

> Seems like IPV6 functionality of Windows and MySQL driver is not gelling
> well.
>
> Please see http://bugs.php.net/bug.php?id=50172.
> This is also discussed in MySQL forum at
> http://forums.mysql.com/read.php?52,294772,294772#msg-294772.
>
> Thanks,
> Don.
>
>
> -Original Message-
> From: Lester Caine [mailto:les...@lsces.co.uk]
> Sent: Saturday, March 06, 2010 9:01 AM
> To: php-windows
> Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
>
> Gunawan Wibisono wrote:
> > Hello,
> >
> >  First of all, I apologise if I do something wrong, because I'm new to
> this
> >  weird system.
> >
> >  For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and
> MySQL
> >  5.1.44 on Windows 7 Home Premium. However, whenever I try accessing
> MySQL
> >  via PHP, I get the following error:
> >
> >  A connection attempt failed because the connected party did not properly
> >  respond after a period of time, or established connection failed because
> >  connected host has failed to respond.
> >
> >  MySQL's command line client is still working fine. I think that PHP
> simply
> >  does not see MySQL, though the settings in php.ini seem to be correct.
> >  Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've
> tried
> >  turning off the antivirus, because sometimes it may cause timeouts, but
> it
> >  didn't help. Can someone please help me fix this?
>
> PHP does not come with any database enabled by default, so you will need to
> enable one. For MySQL just look in php.ini for the line
> ;extension=php_mysql.dll
> and remove the ';' at the front, and then restart Apache.
> The first page you should create is
>
>  phpinfo();
> ?>
>
> Which will list all the modules that are active ;)
>
>
>
> --
> Lester Caine - G8HFL
> -
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://w

[PHP-DB] Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

[Gunawan Wibisono]

thx for your enlighment

On Mon, Mar 8, 2010 at 2:15 AM, Venkat Raman Don wrote:

> Hi,
>
> Let me take a shot at explaining this in simple terms. Most of the
> Operating System today is building support for IPV6. IPV4 has its own set of
> limitation and hence the world is moving to IPV6. I am not going to explain
> differences between two, but for the sake of this discussion assume that
> they are different.
>
> A close look at PHP MySQL driver code indicates that mysql_connect()
> function uses mysql_real_connect() to connect to MySQL. The API
> mysql_real_connect() is an API which comes from MySQL dll (MySQL development
> team and is part of MySQL database installation). So this means the support
> for IPV6 in PHP MySQL driver is not possible unless there is a support for
> IPV6 in MySQL database. So the limitation (or no support for IPV6 or
> whatever word may be used to describe this situation) is coming from MySQL
> database limitation. So now it is clear that this is not a PHP bug in the
> sense that nothing can be changed in PHP code base to fix it.
>
> Let's move on to operating system concern now. A typical host file
> (irrespective of OS) has two columns which contains the IP address and host
> name binding to it. In order to support both IPV4 and IPV6 (at least on
> Windows) localhost is getting mapped to two IP addresses. There can be other
> reasons for mapping same localhost to multiple IP address. What is important
> is that, there is a case where we have multiple IP address pointing to same
> host name. A close inspection of MySQL code reveals that the function
> mysql_real_connect() actually tries to connect to only the first IP address
> returned for the hostname and if this fails, no further attempt to connect
> using other IP address associated with same host name is made. This can be
> fixed and I believe a patch is already lying in some development branch of
> MySQL and please follow MySQL release to know which version has this fix
> integrated. I do not have any idea about that. But an important thing is
> that this bug can surface on any OS where you have above condition satisfied
> for the host file. Yes WINDOWS, Ubuntu, Solaris all will and may get
> impacted. So this means that this is not a problem with Windows OS or for
> that reason any other OS.
>
> Hope this explain things.
>
> Thanks,
> Don.
>
>
> -Original Message-
> From: Gunawan Wibisono [mailto:landavi...@gmail.com]
> Sent: Sunday, March 07, 2010 7:37 AM
> To: php-wind...@lists.php.net; php-db@lists.php.net
> Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
>
> sry.. this kinda other person problem
> thx for your support and I kinda found this problem on other place.. Is
> posible.. the problem in the windows 7?
>
> On Sun, Mar 7, 2010 at 12:12 AM, Venkat Raman Don
> wrote:
>
> > Seems like IPV6 functionality of Windows and MySQL driver is not gelling
> > well.
> >
> > Please see http://bugs.php.net/bug.php?id=50172.
> > This is also discussed in MySQL forum at
> > http://forums.mysql.com/read.php?52,294772,294772#msg-294772.
> >
> > Thanks,
> > Don.
> >
> >
> > -Original Message-
> > From: Lester Caine [mailto:les...@lsces.co.uk]
> > Sent: Saturday, March 06, 2010 9:01 AM
> > To: php-windows
> > Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
> >
> > Gunawan Wibisono wrote:
> > > Hello,
> > >
> > >  First of all, I apologise if I do something wrong, because I'm new to
> > this
> > >  weird system.
> > >
> > >  For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and
> > MySQL
> > >  5.1.44 on Windows 7 Home Premium. However, whenever I try accessing
> > MySQL
> > >  via PHP, I get the following error:
> > >
> > >  A connection attempt failed because the connected party did not
> properly
> > >  respond after a period of time, or established connection failed
> because
> > >  connected host has failed to respond.
> > >
> > >  MySQL's command line client is still working fine. I think that PHP
> > simply
> > >  does not see MySQL, though the settings in php.ini seem to be correct.
> > >  Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've
> > tried
> > >  turning off the antivirus, because sometimes it may cause timeouts,
> but
> > it
> > >  didn't help. Can someone please help me fix this?
> >
> > PHP does not come with any database enabled by default, so you will need
> to
> > enable one. For MySQL just look in php.ini for the line