PHP Mailing List wrote:
Can I maintain just one mysql connection resource to all my pages per
user session. As far as I knows create connection is more expensive than
executing queries ?
No, you can't store resources (of which mysql connections are one
example) in sessions.
Any reference h
In most systems, database connections are pooled, meaning that when you give
them up, they are not completely closed but the sql client software keeps
them in a pool available for the next script asking for a similar
connection, thus saving on the time to establish a connection.It is the
co
On Wednesday 26 October 2005 08:35, the author Jay Blanchard contributed to
the dialogue on-
RE: [PHP] MySql connection error on win XP for script that works on Freebsd
5.3:
>[snip]
>I have searched the mysql website and located an article which shows
>reference
>to this erro
[snip]
I have searched the mysql website and located an article which shows
reference
to this error indicating that the client may need to be upgraded but as I am
using the mysql-5.0.13-rc-win32.zip package I am cautious about assuming
that
that is the actual cause.
[/snip]
http://us3.php.net/m
I think you've just answered your own question here:
"I get a "Can't Connect to MySQL Server" error. I am not sure if it is
localhost, since my webserver is on a different machine with a different
name. The MySQL installation is on a different machine, separate from
the web server with its own
Robb Kerr wrote:
Ok, I feel like a complete bonehead because I can't seem to figure this
thing out. But, I readily welcome someone making me feel worse by pointing
out my simple mistake. I can't get DW to connect to a MySQL database on a
new server with which I'm working. I've worked with other se
Hello,
Thanks it works now
Regards
Moses
> Hello, This seems not to be working, I am using win2000 and a newbie. please
> simplify this process.
>
> ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
> mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
> -> IDENTIF
On Tue, 2003-06-17 at 18:19, [EMAIL PROTECTED] wrote:
> Hello, This seems not to be working, I am using win2000 and a newbie. please
> simplify this process.
>
> ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
> mysql> GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]
> -
n Wilson <[EMAIL PROTECTED]>
>> date:Wed, 18 Jun 2003 01:17:15
>> to: [EMAIL PROTECTED]
>> cc: [EMAIL PROTECTED]
>> subject: Re: [PHP] MySQL Connection
>>
>> On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED] wrote:
>> > Hello,
>> &
OPTION;
ERROR 1045: Access denied for user: '@127.0.0.1' (Using password: NO)
mysql>
Regards
> from:Lars Torben Wilson <[EMAIL PROTECTED]>
> date:Wed, 18 Jun 2003 01:17:15
> to: [EMAIL PROTECTED]
> cc: [EMAIL PROTECTED]
> subject: Re: [PH
On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED] wrote:
> Hello,
>
> Would be grateful if someone couldkindly point me in the right direction.
Check the MySQL documentation. You also might want to ask on the MySQL
mailing list.
http://www.mysql.com/doc/en/Default_privileges.html
http://www.mys
>My server is running on shared server which has support for PHP 4.1.2. I
>installed mySQL for our shared server. I also installed phpMyAdmin. Both
>are running properly. But I am facing following problems
>
>1) If there is any error in the script - It is not getting displayed -
>screen is beco
I don't think those variables are readable in the function. Not totally
sure though.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
- Original Message -
From: "Patrick Hartnett" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 30, 2002 1
31/03/2002 01:02:04, "Patrick Hartnett" <[EMAIL PROTECTED]> wrote:
You Need to use the command
Mysql_Select_Db("$db_name") Or Die("Unable to connect!");
after connect with mysql
I use something like this:
mysql_connect($db_host, $db_user, $db_pass) or die ("Unable to connect!");
Mysql_Select_D
On Tuesday 29 January 2002 15:29, Uma Shankari T. wrote:
> Hello,
>
>
> How do i check php support mysql..
>
>
> If any one came to know this tell me...
You have already been told how to. See the posting by Chris in response to
your posting about the same question just a little while ago.
Hey Uma
call to undefined function, well thats exactly what it means (it doesnt like
the function specified eg mysql_connect)this means that your php
installation does not have support for mysql.
You can check this with the following
run this via a browser and check the config of php... it
>If I use extention .inc for including my connection-
>variables file then browser attempts to download this file which is
>not better then first. I searched the net on this topic and found a
>LOT of information about this problem and the best that I found is
>here I just want you to be aware of
27;t be made.
> > No code is shown, just a line number. If, in your
> > case, PHP dumps the
> > source code to the browser window when the db
> > connection won't work,
> > then something has to be wrong. :)
> >
> > --Matt
> >
> >
> &g
ce code to the browser window when the db
> connection won't work,
> then something has to be wrong. :)
>
> --Matt
>
>
> -Original Message-
> From: BRACK [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, August 09, 2001 5:57 AM
> To: Attila Strauss
> Cc: [EMA
won't work,
then something has to be wrong. :)
--Matt
-Original Message-
From: BRACK [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 09, 2001 5:57 AM
To: Attila Strauss
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL connection
I have tested again what I said yesterday and found
Hi All,
Also a good advice is to restrict the access to the files where you
include your login/pass. Give permissions to only the PHP user, I mean
the user that runs the php process (in unix/linux make a ps axu and look
at the user column). Then change the file permissions to just that user
(unix
I have tested again what I said yesterday and found that if I have
problems in PHP support in Apache then all my information
(username and password) are seing simly on the screen, so it's not
about dead SQL server but PHP.
However, I went through all docs that I have on this topic and found
Ha ha... "hardcore the user/password"
Sorry... I realize you gave a good answer, just had to laugh. :)
-Original Message-
From: Attila Strauss [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 1:33 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL connection
hi,
there are 2 ways.
1. you hardcore the user/password in the php.ini file.
2. u do a simply error checking like :
of course you could also do like kindaheader("Location: http://host";); instead of
print "connection failed".
i hope i could help you.
best regards
attila strauss
>
Hey Jouri,
I don't agree with this one. I tested it out on my
localhost and got the two error messages I told you I
was going to get:
Warning: Unknown MySQL Server Host...
Warning: MySQL Connection Failed...
No usernames/passwords. I have to say however that I
always include my connect.php fil
Yes that is what I mean, but also When I played with my Apache I
saw ALL my information on the screen without any error message.
Actually it maybe that my PHP server was down at that moment
as well, well, I must check it up
Youri
On 7 Aug 2001, at 13:00, Bjorn Van Simaeys wrote:
> Hi,
>
>
If you have Apache and MySQL servers make this experiment -
start Apache but "forget" to start SQL and go to your site
http://localhost/... you will see yourself all the information on the
screen.
Youri
On 7 Aug 2001, at 12:53, Ryan Christensen wrote:
> I'm curious as to how the "hacker" wou
I mean he will know all your sensitive information to enter your SQL
server in couple of hours when server will be up again.
Youri
On 7 Aug 2001, at 14:40, Tyler Longren wrote:
> If the SQL server is down how will he hack it? That's like hacking a
> webserver that doesn't exist.
>
> Tyler Lo
Hi,
I think BRACK a.k.a. Jouri means that the connection
string (from the PHP pages) would be visible in the
client's browser once the SQL server stops running.
However, I am not so sure about this as all commands
are processed on the server - it will, however display
an error message that the S
I'm curious as to how the "hacker" would see all this information (the
username.. password, etc..) just by going to a site where the SQL backend
was down?
Ryan
> -Original Message-
> From: BRACK [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 07, 2001 12:36 PM
> To: [EMAIL PROTECTED]
If the SQL server is down how will he hack it? That's like hacking a
webserver that doesn't exist.
Tyler Longren
Captain Jack Communications
[EMAIL PROTECTED]
www.captainjack.com
On Tue, 7 Aug 2001 21:35:58 +0200
"BRACK" <[EMAIL PROTECTED]> wrote:
> I just wanned to bring the issue of securit
> Warning: MySQL Connection Failed: Can't connect to MySQL server on
> 'localhost' (10061) in c:\arquivos de
> programas\apache group\apache\htdocs\db_connect.php on line 3
> Couldn't connect.
Is the MySQL deamon running?
IE, is there a black MS-DOS window (maybe minimized) that has something not
32 matches
Mail list logo