Re: mysql_connect stops via php

farhan wrote:
Hi Jerry,

I'm not sure how to control the length of time to wait other than the
timeout value for mysql.connect which phpinfo() says is 60 seconds.
Firefox seems to try for about 5 seconds (you know the browser wait
thingy) before giving up. The MySql server seems to be fine as I can
connect to it at that address and username/password via the command
line.


But can you do it from a command line on your web server? That is, are you running your web server on your local machine, or is it on another one? And if it is another server, can you connect to the MySQL database from the command line there?

On a related note, I did forget to mention a bit of history. To start
with my Linux installation contained MySql 4.x but when installing on
Windows, I used 5.1. So consequently when I tried to connect from the
4.x client to the 5.1 server, it said something about not being about
to authenticate, so I downloaded 5.0 on linux and everything worked
fine on the command line. However, phpinfo() still reported the MySQL
client as 4.x. Not finding any installation scripts, I manually
copied all executables to /usr/bin and all libraries to /lib. Now
phpinfo is correct.

BTW, my php version is 4.3.10.


IOW you could still have mixed file versions - some from 4.x and some from 5.1. That doesn't sound good.

What happens if you try to connect with an invalid userid/password and/or to an invalid system?


-Farhan





--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================

.

Relevant Pages

  • Re: MySQL FC3
    ... >> After you get your mysql back up and running, ... > same user that the mysqld server runs as. ... > You can stop the MySQL server by sending a normal kill (not kill ... > cat command; these cause the output of cat to be substituted into the ...
    (Fedora)
  • Re: MySQL permission
    ... > you after installing the initial database you would not have this problem. ... I just gave the command "sudo yum install mysql-server". ... on my MySQL server, and have not had any problems on that score. ...
    (comp.os.linux.misc)
  • Re: Tomcat connecting to MySQL - Ubuntu 8.10 Server
    ... Mysql must have a command line client. ... This should work on a default install, but ymmv if passwords and users ... I can use the mysql command line client with no problems. ... Server in a virtual machine, ...
    (Ubuntu)
  • Re: using mysql client to read a file to create a table in a database in a mysql server
    ... so I wonder what is the syntax of the mysql command, ... Also because I am using mysql server 4.1.16 the installed client ... When you issue a mysql statement from the command line, ... I know that I can create the table by typing the commands in to the ...
    (comp.lang.ruby)
  • Re: PHP-Mysql Socket Problem
    ... In my mysql "my.cnf" file i have specified the socket for both client ... and server as ... for mysql socket i have specified ... My phpinfo() gives the following two lines for mysql sock ...
    (comp.lang.php)