Solved

How to install pdo_mysql on server

Posted on 2008-10-11
6
7,725 Views
Last Modified: 2013-12-13
Hi all,

I'm a bit new to this but I wish to install the pdo_mysql module on my shared server environment

I have access to the /php/ext folder and also php.ini

The server details are as follows:
Apache version      1.3.41 (Unix)
PHP version      5.2.5
MySQL version      5.0.51a-community
Architecture      i686
Operating system      Linux

Can somebody please give me a step by step guide on how to install the pdo_mysql module?
0
Comment
Question by:hubfub
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 50

Expert Comment

by:Steve Bink
ID: 22695954
See:

http://www.php.net/manual/en/mysqli.setup.php

PHP must be compiled with support for the mysqli extension.  You can see if that is the case with your installation by checking the output of phpinfo().  The configure line should include "--with-mysqli=mysql_config_path", and you should see a mysql/i section in the extension detail.
0
 
LVL 1

Author Comment

by:hubfub
ID: 22696016
mysqli is already installed. I'm looking to install pdo_mysql
0
 
LVL 50

Accepted Solution

by:
Steve Bink earned 500 total points
ID: 22698113
My apologies...I mis-read your question.

PDO should already be installed on your version by default.  PHP should have been compiled with zlib, also.  If you don't already have it in there, you should be able to install it with:

# pecl install pdo

You'll also need this line in your php.ini:

extension=pdo.so

http://www.php.net/manual/en/pdo.installation.php
0
How our DevOps Teams Maximize Uptime

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us. Read the use case whitepaper.

 
LVL 1

Author Comment

by:hubfub
ID: 22716508
how do i run the line

# pecl install pdo


?? i'm a beginner sorry
0
 
LVL 50

Expert Comment

by:Steve Bink
ID: 22726504
You will need to log into the server's shell.  I'm assuming this is a linux machine.  I'm not sure how PECL works on a Windows machine.
0
 

Expert Comment

by:kuldeep005
ID: 23764116
One more solution to this

wget http://pecl.php.net/get/PDO_MYSQL-1.0.2.tgz
tar xzf PDO_MYSQL-1.0.2.tgz
cd PDO_MYSQL-1.0.2
phpize
./configure
make install clean

In php.ini
extension_dir = "/usr/local/lib/php/extensions/no-debug-non-zts-20060613"
extension=pdo_mysql.so
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If your site has a few sections that need to be secure when data is transmitted between the server and local computer, such as a /order/ section for ordering or /customer/ which contains customer data, etc it would of course be recommended to secure…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question