mysql and php

I have xampp installed and mysql workbench
I would like to install a separate PHP package and mysql instance
can someone please tell my which mysql package I should install and which install procedure(I am ok with the PHP)
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dave BaldwinFixer of ProblemsCommented:
Why?  What do you think you're going to gain by doing that?  Besides trouble.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Radek BaranowskiFull-stack Java DeveloperCommented:
Nevermind your actual motivation, I would recommend to get the latest MySQL package from here:

where installing procedure will of course depend on your operating system. Installation itself should be pretty straightforward, I believe.

As for PHP, it's a bit more complex, as you need to have Apache/IIS (the webserver) running, as php is essentially a runtime library loaded by the webserver which interprets php code ran on the server. But again, go for the latest versions:
Apache 2.x
Please use the Apache builds provided by Apache Lounge. They provide VC9, VC11 and VC14 builds of Apache for x86 and x64. We use their binaries to build the Apache SAPIs.
And latest php which is 5.6:

You might need some manual work to do in php.ini, httpd.conf and mysql.ini files tho, hence better use packaged solution like XAMPP which you already have.

Hope this helps.
Dave BaldwinFixer of ProblemsCommented:
A web server can only run one version of PHP at a time.  If you install a second web server, it has to run on a different, non-standard port.  Same goes for MySQL, a second install must use a different and non-standard port.
Ray PaseurCommented:
I agree with Dave - the idea of trying to run on a non-standard port is a little scary to me - too many things can go wrong.  But that aside, you might consider using a virtual machine if you want more than one instance of PHP.  One possibility:

Basically, you boot up a virtual machine instance and run as if you were the only client on the box.  Need another box?  Just boot up another instance.  This can be really useful in a development environment, for example, if you need to test several different levels of web browsers.
doctorbillTechAuthor Commented:
Points taken
As usual - sound solutions from all
I will go virtual on one of my VM's
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.