I have recorded both the errors by changing the variable:
$host = "mycomputer.webaddress.com"
PHP Warning: mysql_connect(): Lost connection to MySQL server during
query in /export/home/rpo219/may/conf_global.php on line 18
Lost connection to MySQL server during query
$host = "localhost"
PHP Warning: mysql_connect(): Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/export/home/rpo219/may/conf_global.php on line 18
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock'
I found something weird for the first time:
I tried looking at the mysql6 data directory and it says the following:
total 28
drwxr-xr-x 3 nfsnobody nfsnobody 4096 May 10 23:57 .
drwxrwxrwx 21 root root 4096 May 7 14:35 ..
-rw-rw---- 1 nfsnobody nfsnobody 1009 May 10 23:57
mycomputer.webaddress.com.err
drwxr-xr-x 2 nfsnobody nfsnobody 4096 Jan 24 20:07 mysql
And when I try to change the ownership of the directory to mysql by
[root@xxxxxxxxxxxxxxxxxxxxxxxxx] chown mysql ./mysql6
chown: changing ownership of `./mysql6': Operation not permitted
Just thought it might be related to the problem
Thanks,
Rahul
Rahul wrote:
Thanks a lot for your reply.
I have tried using
$host = "localhost";
$db = "dbname";
$table_main = "tablename";
$dbusername = "root";
$dbpass = "passhere";
mysql_connect($host, $dbusername, $dbpass) or die(mysql_error());
and
$host = "mycomputer.webaddress.com";
$db = "dbname";
$table_main = "tablename";
$dbusername = "root";
$dbpass = "passhere";
mysql_connect($host, $dbusername, $dbpass) or die(mysql_error());
And this mycomputer.webaddress.com works when I use with mysql like this:
mysql -h mycomputer.webaddress.com -u root -p
Thank You
Nathan Nobbe wrote:
On Sun, May 11, 2008 at 12:30 AM, Rahul <rahul986@xxxxxxxxx> wrote:
I am using Fedora Core 4. As I was unable to use PHP or MySQL
together, I
uninstalled both of them and installed again using the following
commands:
yum install mysql
And then
apt-get install php php-devel php-gd php-imap php-ldap php-mysql
php-odbc
php-pear php-xml php-xmlrpc curl curl-devel perl-libwww-perl ImageMagick
And then started the mysql server.
I am able to connect to the server from the console my typing
mysql -h <hostname> -u root -p <mypass>
However, when I try to connect to mysql through PHP I get the following
errors:
PHP Warning: mysql_query(): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (2) in
/export/home/rahul/may/sample.php
on line 5
PHP Warning: mysql_query(): A link to the server could not be
established
in /export/home/rahul/may/sample.php on line 5
Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)
Can someone please help me out?
what is the hostname you are typing at the command line and what is
the one
you are using when trying to connect from php? when using mysql, you
will
have to have a separate entry for localhost connections.
-nathan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
