Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Setting up Mysql to work with Apache

Posted on 2006-11-22
1
Medium Priority
?
185 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
1 Comment
 
LVL 13

Accepted Solution

by:
rhickmott earned 2000 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: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone 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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month7 days, 21 hours left to enroll

824 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