exactly what/how do you attempt to access mysql through the php app?
are you sure you used to exact same attributes when you access mysql from the cli?
what do the mysql log files say?
On Mon, Jan 23, 2012 at 1:05 PM, Fedora Linux <fedoralinux@xxxxxxxxxxxxxxxxx> wrote:
HelloBy 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 PHPThe 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.phpSo 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@xxxxxxxxx> 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@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxx 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
