Solved

Setting up Mysql to work with Apache

Posted on 2006-11-22
1
183 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

If you've heard about htaccess and it sounds like it does what you want, but you're not sure how it works... well, you're in the right place. Read on. Some Basics #1. It's a file and its filename is .htaccess (yes, with a dot in the front). #…
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

617 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