Solved

Setting up Mysql to work with Apache

Posted on 2006-11-22
1
180 Views
Last Modified: 2010-03-04
Hey Guys,

Im having trouble installing mysql with my apache installation. I have installed apache 2.2, and php 5 and they are working well, but not the mysql.
I have tried eveything, plz help?
0
Comment
Question by:cjevic
[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
1 Comment
 
LVL 13

Accepted Solution

by:
rhickmott earned 500 total points
ID: 17994421
You dont set up Apache to work with MySQL you configure PHP to do it.

I your Apache Config somewhere you should have a line that says

PHPIniDir

Ideadlly this will be the same as your PHP Installation and you should have a file in there called PHP.INI ( If you dont then thats where your problem lies )

Create a File Caled index.php somewhere in your websapce where you can rin PHP and enter the following code.

<?php
     phpinfo();
?>

Run the script in your browser and search the page for MySQL if you have a section that says "MYSQL" then MySQL is configured and working. If its not then look at the top for where the location of your PHP.INI is to make sure it actually using one and where its location is. Edit the file and find the line that says

extension_dir = ""

Edit this to the path of your PHP folder for example

extension_dir = "c:\php\ext"

Do a search for

;extension=php_mysql.dll

and remove the Semi Colon from the start of it. Restart Apache and *hopefully* your new phpinfo scripe will have a MySQL section in it.

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

As Wikipedia explains 'robots.txt' as -- the robot exclusion standard, also known as the Robots Exclusion Protocol or robots.txt protocol, is a convention to prevent cooperating web spiders and other web robots from accessing all or part of a websit…
If you are running a LAMP infrastructure, this little code snippet is very helpful if you are serving lots of HTML, JavaScript and CSS-related information. The mod_deflate module, which is part of the Apache 2.2 application, provides the DEFLATE…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

739 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