Page 1 of 1

Installation Process cannot recognize MySQL 5.0

Posted: Tue Nov 07, 2006 6:05 am
by PBlue
At Step 3 of the Installation process, the install script cannot find mysql and I have nothing to choose from the "Database Type" and the following error message appears:

Database Type: 
No valid database drivers appear to be compiled into your PHP install. Please confirm that you have mysql, mysqli, and/or postgres7 support installed, and try again.


In fact, I can connect to mysql using the console with the user "cms_user" and password "cms_pass" and access the database "cms".

# mysql -u cms_user -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 49 to server version: 5.0.22

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use cms;
Database changed

mysql> show tables;
Empty set (0.00 sec)

mysql>


The database "cms" has been created and the user "cms_user" has been granted privileges.

Basic information:
(1) I am using Fedora Core 6.
(2) Mysql version is 5.0.22

Please can anybody advise what's wrong?

Re: Installation Process cannot recognize MySQL 5.0

Posted: Tue Nov 07, 2006 12:09 pm
by Dee
It looks like your PHP install lacks mysql support. You probably need to install some php-mysql package.

Re: Installation Process cannot recognize MySQL 5.0

Posted: Thu Nov 09, 2006 5:03 am
by PBlue
Yes, you are right!

After I execute #yum install php-mysql and then I can install CMS Made Simple successfully.

More information about php-mysql:

Name  : php-mysql
Arch  : i386
Version: 5.1.6
Release: 3.1.fc6
Size  : 82 k
Repo  : updates
Summary: A module for PHP applications that use MySQL databases.
Description:
The php-mysql package contains a dynamic shared object that will add
MySQL database support to PHP. MySQL is an object-relational database
management system. PHP is an HTML-embeddable scripting language. If
you need MySQL support for PHP applications, you will need to install
this package and the php package.

So CMSMS can work with Fedora Core 6 and MySQL 5 without any problem.

Re: Installation Process cannot recognize MySQL 5.0

Posted: Mon Feb 12, 2007 3:50 am
by chmod411
Hello - I'm trying the install cms as well, and I have been reading your forum to find out where I can get php-mysql package together. I have downloaded both mysql-essential 5.0.27 and php 5.2.1. I use Apache 2.0.5 on Windows XP SP2.

I also got the same error at step 3 - I have nothing to choose from the Database type and "Database Type:   
No valid database drivers appear to be compiled into your PHP install. Please confirm that you have mysql, mysqli, and/or postgres7 support installed, and try again."

I have done mysql command, the database "cms" has been created, and privileges for cms_user has been granted.

You mentioned in here that there is a php-mysql package, can someone send me the link where to find this package? Thank you.