MySQL is not working on PHP with Fedora 16

[Fedora Linux]

Hello

By command line I am able to connect normally, so the problem is not
MySQL... I use "mysql -u root -h localhost -p" and it works... Note that
the application also uses root since it must create the database and a user
for the application...

I have tried to restart MySQL and the whole system, but it still does not
connect from PHP

The error is:
[error] [client ::1] PHP Warning:  mysql_connect(): Can't connect to local
MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in
/var/www/html/install2.php on line 22, referer: http://localhost/install.php

So I guess the problem is in the PHP, Apache or on the interface between
MySQL and Apache/PHP...

Any other suggestion?

Regards

On Sun, Jan 22, 2012 at 12:04 PM, bruce <badouglas at gmail.com> wrote:

> hi...
>
> ok.. basic debug stuff.. skip if you've already done..
> -using the user/passwd.. can you access mysql from the cmdline..
>    [i assume you can]
> -what are the permissions on the mysql db/tbls? have they changed?
> --did you stop/restart mysql?
> -what do the mysql logs say?
>
> let us know..
>
>
> On Sun, Jan 22, 2012 at 12:28 PM, Mike Wright <mike.wright at mailinator.com>wrote:
>
>> On 01/22/2012 07:02 AM, Fedora Linux wrote:
>>
>>> Hello
>>>
>>> I have a web application but it is not working on my Fedora 16 with PHP,
>>> for some reason it is unable to connect to the MySQL server, it returns
>>> the error:
>>>
>>> [Sun Jan 22 08:40:24 2012] [error] [client ::1] PHP Warning:
>>>  mysql_connect(): Can't connect to local MySQL server through socket
>>> '/var/lib/mysql/mysql.sock' (13) in /var/www/html/install2.php on line
>>> 22, referer: http://localhost/install.php
>>>
>>> Notice that the user/password is correct, the PHP is installed and
>>> working and MySQL is up and running...
>>>
>>> Even the socket is there
>>>
>>> # ls -l /var/lib/mysql/mysql.sock
>>> srwxrwxrwx. 1 mysql mysql 0 Jan 22 08:37 /var/lib/mysql/mysql.sock
>>>
>>> What can be the problem? The application is okay, I am using it in a
>>> production server and it is running in 2 other local computers (with
>>> slackware) for testing purposes...
>>>
>>> This is the first time that I can't connect to MySQL via PHP... I don't
>>> know if it requires an extra configuration or there is a missing package
>>> that I should install... the httpd log does not give more details...
>>>
>>> Thanks for any help!
>>>
>>
>> Do you have port 3306 open on your firewall?
>>
>>>
>>>
>>>
>>>
>> --
>> users mailing list
>> users at lists.fedoraproject.org
>> To unsubscribe or change subscription options:
>> https://admin.fedoraproject.**org/mailman/listinfo/users<https://admin.fedoraproject.org/mailman/listinfo/users>
>> Guidelines: http://fedoraproject.org/wiki/**Mailing_list_guidelines<http://fedoraproject.org/wiki/Mailing_list_guidelines>
>> Have a question? Ask away: http://ask.fedoraproject.org
>>
>
>
> --
> users mailing list
> users at lists.fedoraproject.org
> To unsubscribe or change subscription options:
> https://admin.fedoraproject.org/mailman/listinfo/users
> Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
> Have a question? Ask away: http://ask.fedoraproject.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.fedoraproject.org/pipermail/users/attachments/20120123/2d227f97/attachment.html>