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 <badoug...@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.wri...@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@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@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 > >
-- users mailing list users@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
