0

I've got PHp installed from my hosting provider and it doesnt seem to have mysql support built in. I was redirected to an installation script: 

/usr/bin/mysql_secure_installation

Which installed mysql as a program, but phpinfo() still shows:

Configure Command './configure' '--build=x86_64-redhat-linux-gnu' '--host=x86_64-redhat-linux-gnu' .............................. '--without-mysql' '

What do I do next to have mysql support?

siliconpi
  • 1,707
  • 6
  • 30
  • 45

1 Answers1

1

Install php-mysql:

yum install php-mysql

Then check /etc/php.d/mysql.ini file. Tets php:

php -i | grep -i mysql
/etc/php.d/mysql.ini,
/etc/php.d/mysqli.ini,
/etc/php.d/pdo_mysql.ini,
MySQL Support => enabled
MYSQL_MODULE_TYPE => external
MYSQL_SOCKET => /var/lib/mysql/mysql.sock
MYSQL_INCLUDE => -I/usr/include/mysql
MYSQL_LIBS => -L/usr/lib/mysql -lmysqlclient 

php -r 'mysql_connect();'
PHP Warning:  mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in Command line code on line 1
bindbn
  • 5,153
  • 2
  • 26
  • 23
  • Interesting - this sort of installed something, but no change in phpinfo() and no change in my application - "Installed: php-mysql.x86_64 0:5.1.6-27.el5 Dependency Installed: php-pdo.x86_64 0:5.1.6-27.el5" – siliconpi Oct 16 '10 at 11:40
  • test php: php -r 'mysql_connect();' – bindbn Oct 16 '10 at 12:18
  • PHP Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in Command line code on line 1 – siliconpi Oct 16 '10 at 12:35
  • I dont know if it complicates things, but my root password is X, my mysql admin password is Y and the password for the database user for my applicaiton is Z. – siliconpi Oct 16 '10 at 12:38
  • @matt_tm - that error means you've got your mysql support working. Otherwise you'd get some version of a "method not found" error. You can sort out the authentication issues in your php code. – Brad Mace Oct 17 '10 at 19:53
  • You know - the problem 'sorted' itself out... I think the hosting provider did something and I'm seeing mysql stuff show up in phpinfo(). Not sure what they did though... – siliconpi Oct 18 '10 at 07:21