[Solved] Mysql cannot connect error after compiling php
Hello, I've been trying everything that I've read to do over the last few days and nothing has worked. I was able to install and compile php with litespeed successfully, but I just can't seem to get MySql to connect. I made sure to configure --with-mysql and I made sure that the socket = /var/lib/mysql/mysql.sock is the right location and specified in php.ini and my.conf. Also, when I login to phpmyadmin, I get this error: Cannot load mysql extension. Please check your PHP configuration.
Also, php info does not show a mysql module, though I see that mysql is working as I am able to "service mysqld restart" and it stops and starts fine. Even verified from "top" command. I do not have Cpanel. The only control panel that I'm using is Webmin and I don't even think there's an extension that makes Litespeed compatible. I am running CentOS and I compiled PHP v3.5.8 with APC and it compiled successfully.
What I can't figure out is that the very first time that I did a php compile and I opened my website, it loaded fine. Then I went to add the apc.so extension in the php.ini file, and then I started getting the cannot load mysql error. Don't know if that caused it or not, but I did remove the apc.so and mysql error still exists.
Any help would be very much appreciated because I have tried everything for several days now. Thanks.