Re: PHP-MYSQL Error: Can't connect to MySQL socket. Can someonehelp me out please?

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@mycomputer.webaddress.com] 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@gmail.com> 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