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
