FUDforum: comp.lang.php » Connecting to MySQL server....

Home » Imported messages » comp.lang.php » Connecting to MySQL server....

Show: Today's Messages :: Polls :: Message Navigator

Re: Connecting to MySQL server.... [message #181049 is a reply to message #181040]

Sun, 07 April 2013 15:04

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

On 07/04/13 14:09, M. Strobel wrote:
> Am 07.04.2013 14:32, schrieb Jerry Stuckle:
>> On 4/7/2013 4:45 AM, M. Strobel wrote:
>>> Am 07.04.2013 05:23, schrieb nag:
>>>> Hi,
>>>>
>>>> I have debconnect.php like the following...
>>>>
>>>>
>>>> <?php
>>>>
>>>> $con=mysql_connect("localhost","root","") ;
>>>>
>>>> if(!$con){
>>>> die('Error in Connection: '. mysql_error());
>>>> }
>>>> mysql_select_db('newdb',$con);
>>>>
>>>> ?>
>>>>
>>>> If I give the password or user name wrong it is flashing the error, but if the
>>>> database name wrong it is simply displaying a blank php file. How can I change the
>>>> above to show the error even if the wrong database name is given.
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>>>
>>> Two more observations:
>>>
>>> - you are using the deprecated mysql API, use mysqli or PDO instead.
>>> - if the db server is local, it is a lot faster to connect to a path pointing to a
>>> local socket
>>>
>>> /Str.
>>>
>>
>> "localhost" DOES use a socket (Linux) or named pipe (Windows).
>
> I am talking about the difference between AF_UNIX and AF_INET, on Linux - is this new
> that "localhost" does not start an IP connection? Can't check now, don't have a test DB.
>

last time I checked it was in fact wrong*: localhost seeems to use
127.0.0.1 not a unix pipe

I know this because whilst I could use the mysql client on a particular
database, php didn't work with it until I granted IP access on interface
127.0.0.1 as well.

*But its Jerry, so this is 'normal behaviour'

> /Str.
>

--
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to
lead are elected by the least capable of producing, and where the
members of society least likely to sustain themselves or succeed, are
rewarded with goods and services paid for by the confiscated wealth of a
diminishing number of producers.

Report message to a moderator

[Message index]

		Connecting to MySQL server.... By: Nagaraju Kachapuram on Sun, 07 April 2013 03:23
		Re: Connecting to MySQL server.... By: J.O. Aho on Sun, 07 April 2013 07:06
		Re: Connecting to MySQL server.... By: The Natural Philosoph on Sun, 07 April 2013 08:07
		Re: Connecting to MySQL server.... By: M. Strobel on Sun, 07 April 2013 08:45
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Sun, 07 April 2013 12:32
		Re: Connecting to MySQL server.... By: M. Strobel on Sun, 07 April 2013 13:09
		Re: Connecting to MySQL server.... By: The Natural Philosoph on Sun, 07 April 2013 15:04
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Mon, 08 April 2013 02:14
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Sun, 07 April 2013 18:17
		Re: Connecting to MySQL server.... By: Peter H. Coffin on Mon, 08 April 2013 01:08
		Re: Connecting to MySQL server.... By: Jerry Stuckle on Mon, 08 April 2013 02:13

Previous Topic:	comparing arrays
Next Topic:	PHP with MS SQL SERVER: is it suitable?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 06:44:05 GMT 2024

Total time taken to generate the page: 0.06819 seconds