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

["Nathan Nobbe" <quickshiftin@xxxxxxxxx>]

On Sun, May 11, 2008 at 1:05 AM, Rahul <rahul986@xxxxxxxxx> wrote:

> 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


i have seen this before, but i cant recall, specifically what the problem
could be.  i recommend google ;)


> $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 believe this is because the user root, does not have permission to connect
to the datbase from host 'localhost', especially since you said this didnt
work from the command line either.  you will have to add a grant clause to
allow the root user to connect from the localhost.

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
>

that is likely the way your distribution has designed the permission scheme
for the mysql server.

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
>

this is probly because you dont have permission to make the change...  you
could do it via sudo, but i wouldnt recommend it.  your distro has set it up
this way on purpose.


> Just thought it might be related to the problem


have you created any databases after installing mysql?  you should create at
least one, like test db or something, and its good practice to create a
specific user to access the database through as well.  instead of having php
connect as root.  thats like a hackers dream right there.

-nathan