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
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
[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]
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 error indicating
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
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]
- IDENTIFIED BY
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
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: [PHP] MySQL Connection
On Tue, 2003-06-17 at 17:13, [EMAIL PROTECTED
PROTECTED]
subject: Re: [PHP] MySQL Connection
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
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]
-
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 becoming
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!);
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 10:02
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
?php
phpinfo();
?
run this via a browser and check the
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.
--
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 this
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
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
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 that if I
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
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: [EMAIL PROTECTED]
Subject: Re: [PHP] MySQL connection
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,
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
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 would
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
hi,
there are 2 ways.
1. you hardcore the user/password in the php.ini file.
2. u do a simply error checking like :
?php
$connect = mysql_connect($host, $user, $pass);
if(!$connect)
{
print connection failed;
}
?
of course you could also do like kindaheader(Location: http://host;);
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
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 security of
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]
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
31 matches
Mail list logo