Xampp Wordpress Database Error - Blog

Xampp WordPress Database Error

By admin 0 Comment March 5, 2019

Xampp wordpress database error

Here is the solution step-by-step:

  1. Open up httpd-ssl.conf in path2xampp\apache\conf\extra
  2. Look for the line Listen 443
  3. Change port number to anything you want. I use 4430 . ex. Listen 4430 .
  4. Replace every 443 string in that file with 4430 .
  5. Save the file.

It’s easier to change the port in VMware Workstation:

  1. Edit > Preferences;
  2. Shared VMs tab;
  3. Disable;
  4. Change port;
  5. Enable.

Run vmware as administrator in windows or as root in linux. Then ctrl+P to open preferences. then on shared vms. You can see a port number 443 by default. This is conflicting with apache that is why it is not starting. Change it to some other value say 8443. Then try to start apache it will run.

Just go to vmvare edit->preferences->shared vms. Click on change settings and disable sharing.click on OK.xampp will work fine.

Connecting to shared virtual machines

Connection to VMware Workstation Server (the shared virtual machines) is administered by the VMware Host Agent service. The service uses TCP ports 80 and 443. This service is also used by other VMware products, including VMware Server and vSphere, and provides additional capabilities. Configuring shared virtual machines

With the Shared VMs Workstation preferences, you can disable/enable the server, assign a different port for connecting, and change the Shared VMs directory.

To access the Shared VMs Workstation preferences:

On Xampp edit apache config

  1. Click Apache ‘config’
  2. Select ‘httpd-ssl.conf’
  3. Look for ‘Listen 443’, change it to ‘Listen 4430’

Say you let vmware use port 443, and use another ssl port in XAMPP Apache (httpd-ssl.conf) :

The red error will keep popping in XAMPP Control Panel. You also need to change the port in the XAMPP Control Panel configuration :

In XAMPP Control Panel, click the "Config" button (top-left). Then click "Service and Port Settings". There you can set the ports to match the ports used by Apache.

Here is the solution: You use Ctrl+Alt+Delete, open task manager and switch to tab services find VMWareHostd and right click to chose StopService. You can start xampp without error

Run XAMPP Control Panel as Administrator if using Windows 7 or more. Windows may block access to ports if not accessed by adminstrator user.

Xampp wordpress database error

I have reinstalled XAMPP for some reason and MySQL is not working, giving the following error in the console:

When checking the "/xampp/mysql/data/mysql_error.log" file I get:

That is just a part of the log, the full one is a bit too big.

16 Answers

Quit your skype and try, if skype is opne

or

Go to your xampp/wamp installed, search for httpd.conf. Open that file using textpad/notepad, search for Listen or 80 , update listen port to 8081 and save the file. Restart xampp/wamp, start the servers.

or
follow below steps in skype

In my case, I did two things:

  1. moved xampp/mysql/backup files into xampp/mysql/data
  2. RUN XAMPP as Administrator

It worked for me 🙂

  • Close the xampp
  • Go to the folder where you installed it, if in (c:) may be something like C:\xampp\ , access folder C:\xampp\mysql\data
  • Delete the file ibdata1
  • Starts XAMPP again.

This worked for me,

  1. quit the XAMPP
  2. cut the All files in C:\xampp\mysql\backup
  3. paste and replace files in C:\xampp\mysql\data
  4. run as administrator the XAMPP

There may be MySQL server installed previously in your computer try to uninstall that and start MySQL at the XAMPP This solved mine

The best solution for this problem is just open your mysql configuration directive file my.ini present inside the folder C:\xampp\mysql\bin and change the information related to the ports, usually some programs occupy the port no. 3306 as a result of that it stops working, Now you follow two steps to make it working.

Thats it, restart you mysql service, it will work for sure.

I would simply try reinstalling XAMPP.

one reason I found ( and not mentioned in addition to other answers given in this site on the similar problem ) was by going to task manager in windows and stopping the mysqld which was running already and prevented mysql server from starting.

just run your xammp as an administrator, it works

For anyone that searched and pressed on this link, i solved it by simply searching for mysql notifier and stop mysql from running there, Then run mysql in xampp again and it runs. why this works ? iam not expert, but i think it is easy : port was taken already by mysql notifier so had to stop it there and run it here.

I am new to XAMPP, but I find that a combination of these suggestions works best (At least on Windows 8.1 with the latest version of XAMPP. Note that the computer I tested this on, also had skype).

First logon to skype and navigate to "Tools https://stackoverflow.com/questions/15169861/xampp-error-mysql-shutdown-unexpectedly/40666663#40666663

In my case : I have just replaced

It worked for me.

If Apache is running without any issue , and u find some blockage by system security settings , simply allow it instead of blocking or closing the dialog box. And change the port number for MySQL to 3607 as it was before 3606 . It worked for me .

if you inistalled mysql Independently you can stop mysql service if running no one of these answers are worked for me this work for me

Well first thing ,, I know its late so I dont know if anyone will upvote it but oh well its okay,, secondly, uninstalling xampp might not do you any good because the process using the port 3306 (Mysql’s default port) will still be running somewhere on your system. might be skype, but might not be skype.

so the best way would be to find out which process is using port 3306, and then terminate the process.

so to find out which process is using port 3306, open command prompt, and type

you will get a screen like this.

Then look for the address with port number 3306 and find out the PID corresponding to that.

Then simply open a command prompt as administrator and type

replace 1234 with your respective PID. Then you can try starting mysql and it will work.

And now if you are lazy to do this step all over again when restarting the computer.

you can simply use the following batch script to terminate the process automatically and enjoy 🙂

Use XAMPP Security Script to Password Protect /xampp and phpMyAdmin root User

This article is part of a series of articles that I’m writing on how to make XAMPP more secure. See the overview page for all of the security steps.

The first step in securing XAMPP is to use its built in security page. Notice I said that this is just the first step, there are many more things to do to secure XAMPP, which are detailed on the overview page.

Start Apache and MySQL and go to http://localhost in your browser (on the same machine as your server). If this is your first time browsing the local site, you should now see a webpage with the XAMPP logo and a choice of languages. Click on your preferred language.

This brings you to an XAMPP control page with navigation links in the left sidebar. Click on “Security”. The page may take a moment to load, it is checking your security status. After it loads, you will see various states of your security status and how your server is currently insecure.

To fix the first 3 problems listed on this page (XAMPP pages publicly accessible, mySQL has no password, and phpMyAdmin is freely accessible), scroll down until you see this link: http://localhost/security/xamppsecurity.php. Click on that link. If you don’t have that link, click here to bring you to that page on your local server.

You’ll now see a page titled “Security console MySQL & XAMPP directory protection”. Do the following:

  1. Enter a password (2 times) for the MySQL SuperUser (root)
  2. Select “cookie” for “PhpMyAdmin authentification” (this is the default, and I prefer it over http authentification).
  3. Do not check “Safe plain password in text file?”
  4. Record this password in a safe place so you don’t forget it.
  5. Click the button “Password changing”.

If done correctly, you should get this message “The root password was successfully changed. Please restart MYSQL for loading these changes!”. Go ahead and restart MySQL via the XAMPP control panel (stop it and then start it again).

Now, back on the XAMPP security page, scroll down to “XAMPP DIRECTORY PROTECTION (.htaccess)”. Do the following:

  1. Enter a username.
  2. Enter a password.
  3. Leave unchecked “Safe plain password in text file? “
  4. Record the username/password in a safe place so you don’t forget it.
  5. Click the button “Make safe the XAMPP directory”

Check that it was successful by looking above the “XAMPP DIRECTORY PROTECTION (.htaccess)” for this message: “SUCCESS: The XAMPP directory is protected now! All personal data was safed in the following file: C:\xampp\security\xampp.users C:\xampp\htdocs\xampp\.htaccess”.

In the future, you can use this page again to change your MySql password, but I don’t recommend using it for your XAMPP password since it will erase any users that you may have added for XAMPP access. If you are the only user for the XAMPP pages, then it is ok to use this form to enter a new password.

You can relaunch the security page to see what XAMPP thinks of your security now. To do this, click on “Security” in the left sidebar. The top 3 items should indicate “Secure” now. If not, you have an issue.

Impacts of your new security and testing it

The security step that you just performed means you will need to supply a username and password when accessing /xampp and /phpmyadmin. Let’s test that this is the case.

To test that /xampp needs a password:

  1. Close and reopen your browser (to erase memory of passwords)
  2. Go to http://localhost/xampp, a window should pop up asking you for a password.
  3. Log in with the username/password that you created for /xampp access.
  4. If this brings you to your XAMPP control page, then this test is sucessful.

To test that /phpmyadmin needs a password:

  1. Since this password protection is cookie based (unles you chose http authentification), you don’t need to close and reopen your browser.
  2. Go to http://localhost/phpmyadmin, a web page should pop up asking you for a password.
  3. Enter “root” as your username and give the password that you supplied to the XAMPP security page.
  4. If this brings you to the phpMyAdmin page, then this test is successful.
  5. You may also want to try signing out of phpMyAdmin and signing back in. To sign out, click the button that looks like this: , which is at the top of the left sidebar.

There is a post on the Apache friends forum that advises to change the root user’s username to something other than “root”, to increase your security. See that post for instructions on how to do that if you want to.

How this security was added

For /xampp, the security webpage script created the file c:\xampp\htdocs\xampp\.htaccess, and gave it the following content:

AuthName “xampp user”
AuthType Basic
AuthUserFile “C:\xampp\security\xampp.users”
require valid-user

This adds Basic Authentification to the /xampp folder, and states that the usernames and passwords are stored in the c:\xampp\security\xampp.users file.

The security script also created a new c:\xampp\security\xampp.users file containing the username and password that you entered. If you examine this file in a text editor, you will see that the password is encrypted. For security purposes, it is important to never make the c:\xampp\security folder accessible via the webserver, or a malicious person could have access to this password file.

For securing phpMyAdmin, the security script did the following

  1. Called the php function mysqlrootupdate() in c:\xampp\security\htdocs\securefunctions.php. This function communicates with the MySQL database to change the root password.
  2. Modified your config.inc.php file to change this line:

in order to enable the cookie based web page authentification to your /phpmyadmin page.

More Security

Now, we have the first level of security for XAMPP. There are still some holes. Additional folders and users need password protection. Also, the passwords you just created will be sent in cleartext and anyone with a network sniffer can see them. You will need to enable encryption for the transmission of these passwords. See the overview page for instructions on how to do these things.

The next step in this tutorial is to remove unused folders.

XAMPP/WAMP Apache Won’t Start in Windows 10 Solution

I’ve just upgraded to windows 10 and found that XAMPP/WAMP Apache won’t start anymore for some reasons. It will simply attempt to start but then fail and ask the user to check the Apache error logs.

The “culprit” or should I say, reason, is because windows 10 comes with a service known as World Wide Web Publishing Service (I will just call it WWWPS for short) which is started automatically when windows starts and uses port 80 by default. Port 80 is what Apache in XAMPP/WAMP uses by default as well, and hence why the error above since port 80 has already been taken by WWWPS.

So the solution is pretty simple:
1. Run Command Prompt and type services.msc, then click OK.

2. Scroll To World Wide Web Publishing Service. Note that the Status should say that it is Running.

3. Double Click on that row. Change the Startup type from Automatic to Manual. Next, click on Stop to stop the WWWPS service. Don’t worry, unless you’re running some software that depends on the Microsoft IIS Web Server, you should be fine.

4. Now, try to start Apache again.

Yup, that’s all and it should work. Please leave a comment if this helps or you have other suggestions.

Ismail Chahrazed says

I just did exactly what you say but it stills not working. Any other suggestion please.

Check the apache log file and windows event viewer to see if there are any errors

the solution works but you must be running a new version. I’m now using v3.2.1(i had to upgrade too)

simon frans says

Earl Alvin Alvizo (@props21) says

Thanks David. It fix my xamp

excelent. I tried 1000 way. and read 100000 Article and didn’t work. thank you. your solution is the best.

My Apache started after stopping IIS, but defined virtual host still not works, why?

Brilliant, David. Worked a treat. Many thanks!

I followed you instructions and it failed to work. Then I ran XAMPP control panel as administrator and it works. Just to add another thought.

This seems to be the issue for me. I ran the XAMPP control panel as administrator and it works … (don’t seem to have the World Wide Publishing Service on my computer for whatever reason).

Fernando Soguero Sánchez says

I was looking for a solution to this problem and find this. Thanks to you, my problem is solved!

Guido Vanthienen says

Thank you very much, problem solved

This didnt work for me i couldnt find worl wide web publishing service

Mohd Rizal Mustafa says

it is work.Tq david

Marilyn O’Sullivan says

Thanks so much for this tip. It worked like a charm.

Thank you! This fix did it. Run Apache Run!

Ajit Singh says

hello.. i was fighting with same problem..
it is an unsatisfiying Error message above and i’ve tryed to run my httpd.exe from CommandLine.

it won’t start and, it said me something like that:
“invalid root folder on line 242 of C:\ xampp \ apache \ conf \ httpd . conf”

than i checked the root path in my config file and it was seem correct..

than i checked the root path, and i find out my root folder was missing. i must be accidently delete and forget that shit.. i mean all was my fool 🙂

pls. check your rooth path twice, and naming of your folders (if you renaming the root on desing time). Xamp giving the same error in this case.

Wow it amazing it fix my problem straight away. Give you A++++ for you excellent Help

YOU THE BEST . THANKS MAN

great! you save me

Ray Hendriksma says

Thankyou Soo much!!

Worked! Very simple, thanks,

it works after restart my PC, thanks a lot

Tried to install wampserver on my Windows 10. Get error httpd.exe cannot start correctly 0xc000007b. Tried all tips here and in other places, still nothing. wamp icon remains red, no services running, there isn’t any Apache log to examine. Yes, IIS is stopped, W3SVC too, changed ports from 80 to 8080, all VC++ dlls are installed, tried just runnin httpd.exe as admin but it won’t work.

Thank you! Ran as admin fixed the problem

Meg Morgan says

Thank you so much! It worked perfectly (Apache 2.2) .

WWWPS service wasn’t installed in my w10, still the apache service can’t run. why?

Thank u soooooooooooooooo much

Great. It works, mate. Thank you so much.

Hi tried your solution but i cant seem to find WWWPS, its a new computer. windows 10.
error log[Sun Jan 10 11:13:02.514568 2016] [ssl:warn] [pid 9160:tid 584] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:02.686445 2016] [ssl:warn] [pid 9160:tid 584] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:02.733320 2016] [mpm_winnt:notice] [pid 9160:tid 584] AH00455: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.15 configured — resuming normal operations
[Sun Jan 10 11:13:02.733320 2016] [mpm_winnt:notice] [pid 9160:tid 584] AH00456: Apache Lounge VC11 Server built: Oct 13 2015 10:54:13
[Sun Jan 10 11:13:02.733320 2016] [core:notice] [pid 9160:tid 584] AH00094: Command line: ‘C:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache’
[Sun Jan 10 11:13:05.248970 2016] [mpm_winnt:notice] [pid 9160:tid 584] AH00418: Parent: Created child process 8384
[Sun Jan 10 11:13:05.686474 2016] [ssl:warn] [pid 8384:tid 500] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:05.827102 2016] [ssl:warn] [pid 8384:tid 500] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:05.858351 2016] [mpm_winnt:notice] [pid 8384:tid 500] AH00354: Child: Starting 150 worker threads.

Thanks very much David. It works. Your great article solve my problem.

thanks. Now it work. Problem solved

Peter Meint says

January 2016, and it still works perfectly 😉

Thanks, this is very helpful

Hi to all, i have the problems with Apache.
Windows 10, not upgrade.
The versione of XAMPP is 3.2.2
No skype installed..

my file http.conf:
ServerRoot “/xampp/www” www exist.
Listen 8080
ServerName localhost:8080
DocumentRoot “/xampp/www”

From the consolle i read:
Attempting to start Apache service…
Executing “net start “Apache2.4″”
Return code: 0

From Events read:
>>> httpd.exe: Syntax error on line 37 of C:/Program Files (x86)/xampp/apache/conf/httpd.conf: ServerRoot must be a valid directory

Luca, try changing the ServerRoot line to

Saturminus Combie says

Thanks it is running on local-host. I had that in mind but could not access the service.

Found these instructions by accident and while they didn’t work for me, I wanted to pose the following question to whoever reads this: My XAMPP apache 2.4 will not start on computer reboot because the IP Helper service is already started. Once I shut down this sevice, apache runs fine. Has anyone come across this before? I don’t have IIS installed.

Denise Perez says

Solved .
Thank you

Jeff Swanson says

Worked great. Thank you!

Paul Hansen says

Also worked great for me. I was about to reinstall Apache and waste a bunch of time. Thanks tremendously!

same as min bro. I coudnt find wwwPublishing service. my xampp is still not working. I tried many ways but nothing happens.

Xampp wordpress database error

Here is the solution step-by-step:

  1. Open up httpd-ssl.conf in path2xampp\apache\conf\extra
  2. Look for the line Listen 443
  3. Change port number to anything you want. I use 4430 . ex. Listen 4430 .
  4. Replace every 443 string in that file with 4430 .
  5. Save the file.

It’s easier to change the port in VMware Workstation:

  1. Edit > Preferences;
  2. Shared VMs tab;
  3. Disable;
  4. Change port;
  5. Enable.

Run vmware as administrator in windows or as root in linux. Then ctrl+P to open preferences. then on shared vms. You can see a port number 443 by default. This is conflicting with apache that is why it is not starting. Change it to some other value say 8443. Then try to start apache it will run.

Just go to vmvare edit->preferences->shared vms. Click on change settings and disable sharing.click on OK.xampp will work fine.

Connecting to shared virtual machines

Connection to VMware Workstation Server (the shared virtual machines) is administered by the VMware Host Agent service. The service uses TCP ports 80 and 443. This service is also used by other VMware products, including VMware Server and vSphere, and provides additional capabilities. Configuring shared virtual machines

With the Shared VMs Workstation preferences, you can disable/enable the server, assign a different port for connecting, and change the Shared VMs directory.

To access the Shared VMs Workstation preferences:

On Xampp edit apache config

  1. Click Apache ‘config’
  2. Select ‘httpd-ssl.conf’
  3. Look for ‘Listen 443’, change it to ‘Listen 4430’

Say you let vmware use port 443, and use another ssl port in XAMPP Apache (httpd-ssl.conf) :

The red error will keep popping in XAMPP Control Panel. You also need to change the port in the XAMPP Control Panel configuration :

In XAMPP Control Panel, click the "Config" button (top-left). Then click "Service and Port Settings". There you can set the ports to match the ports used by Apache.

Here is the solution: You use Ctrl+Alt+Delete, open task manager and switch to tab services find VMWareHostd and right click to chose StopService. You can start xampp without error

Run XAMPP Control Panel as Administrator if using Windows 7 or more. Windows may block access to ports if not accessed by adminstrator user.

Xampp wordpress database error

I have reinstalled XAMPP for some reason and MySQL is not working, giving the following error in the console:

When checking the "/xampp/mysql/data/mysql_error.log" file I get:

That is just a part of the log, the full one is a bit too big.

16 Answers

Quit your skype and try, if skype is opne

or

Go to your xampp/wamp installed, search for httpd.conf. Open that file using textpad/notepad, search for Listen or 80 , update listen port to 8081 and save the file. Restart xampp/wamp, start the servers.

or
follow below steps in skype

In my case, I did two things:

  1. moved xampp/mysql/backup files into xampp/mysql/data
  2. RUN XAMPP as Administrator

It worked for me 🙂

  • Close the xampp
  • Go to the folder where you installed it, if in (c:) may be something like C:\xampp\ , access folder C:\xampp\mysql\data
  • Delete the file ibdata1
  • Starts XAMPP again.

This worked for me,

  1. quit the XAMPP
  2. cut the All files in C:\xampp\mysql\backup
  3. paste and replace files in C:\xampp\mysql\data
  4. run as administrator the XAMPP

There may be MySQL server installed previously in your computer try to uninstall that and start MySQL at the XAMPP This solved mine

The best solution for this problem is just open your mysql configuration directive file my.ini present inside the folder C:\xampp\mysql\bin and change the information related to the ports, usually some programs occupy the port no. 3306 as a result of that it stops working, Now you follow two steps to make it working.

Thats it, restart you mysql service, it will work for sure.

I would simply try reinstalling XAMPP.

one reason I found ( and not mentioned in addition to other answers given in this site on the similar problem ) was by going to task manager in windows and stopping the mysqld which was running already and prevented mysql server from starting.

just run your xammp as an administrator, it works

For anyone that searched and pressed on this link, i solved it by simply searching for mysql notifier and stop mysql from running there, Then run mysql in xampp again and it runs. why this works ? iam not expert, but i think it is easy : port was taken already by mysql notifier so had to stop it there and run it here.

I am new to XAMPP, but I find that a combination of these suggestions works best (At least on Windows 8.1 with the latest version of XAMPP. Note that the computer I tested this on, also had skype).

First logon to skype and navigate to "Tools https://stackoverflow.com/questions/15169861/xampp-error-mysql-shutdown-unexpectedly/40666663#40666663

In my case : I have just replaced

It worked for me.

If Apache is running without any issue , and u find some blockage by system security settings , simply allow it instead of blocking or closing the dialog box. And change the port number for MySQL to 3607 as it was before 3606 . It worked for me .

if you inistalled mysql Independently you can stop mysql service if running no one of these answers are worked for me this work for me

Well first thing ,, I know its late so I dont know if anyone will upvote it but oh well its okay,, secondly, uninstalling xampp might not do you any good because the process using the port 3306 (Mysql’s default port) will still be running somewhere on your system. might be skype, but might not be skype.

so the best way would be to find out which process is using port 3306, and then terminate the process.

so to find out which process is using port 3306, open command prompt, and type

you will get a screen like this.

Then look for the address with port number 3306 and find out the PID corresponding to that.

Then simply open a command prompt as administrator and type

replace 1234 with your respective PID. Then you can try starting mysql and it will work.

And now if you are lazy to do this step all over again when restarting the computer.

you can simply use the following batch script to terminate the process automatically and enjoy 🙂

Use XAMPP Security Script to Password Protect /xampp and phpMyAdmin root User

This article is part of a series of articles that I’m writing on how to make XAMPP more secure. See the overview page for all of the security steps.

The first step in securing XAMPP is to use its built in security page. Notice I said that this is just the first step, there are many more things to do to secure XAMPP, which are detailed on the overview page.

Start Apache and MySQL and go to http://localhost in your browser (on the same machine as your server). If this is your first time browsing the local site, you should now see a webpage with the XAMPP logo and a choice of languages. Click on your preferred language.

This brings you to an XAMPP control page with navigation links in the left sidebar. Click on “Security”. The page may take a moment to load, it is checking your security status. After it loads, you will see various states of your security status and how your server is currently insecure.

To fix the first 3 problems listed on this page (XAMPP pages publicly accessible, mySQL has no password, and phpMyAdmin is freely accessible), scroll down until you see this link: http://localhost/security/xamppsecurity.php. Click on that link. If you don’t have that link, click here to bring you to that page on your local server.

You’ll now see a page titled “Security console MySQL & XAMPP directory protection”. Do the following:

  1. Enter a password (2 times) for the MySQL SuperUser (root)
  2. Select “cookie” for “PhpMyAdmin authentification” (this is the default, and I prefer it over http authentification).
  3. Do not check “Safe plain password in text file?”
  4. Record this password in a safe place so you don’t forget it.
  5. Click the button “Password changing”.

If done correctly, you should get this message “The root password was successfully changed. Please restart MYSQL for loading these changes!”. Go ahead and restart MySQL via the XAMPP control panel (stop it and then start it again).

Now, back on the XAMPP security page, scroll down to “XAMPP DIRECTORY PROTECTION (.htaccess)”. Do the following:

  1. Enter a username.
  2. Enter a password.
  3. Leave unchecked “Safe plain password in text file? “
  4. Record the username/password in a safe place so you don’t forget it.
  5. Click the button “Make safe the XAMPP directory”

Check that it was successful by looking above the “XAMPP DIRECTORY PROTECTION (.htaccess)” for this message: “SUCCESS: The XAMPP directory is protected now! All personal data was safed in the following file: C:\xampp\security\xampp.users C:\xampp\htdocs\xampp\.htaccess”.

In the future, you can use this page again to change your MySql password, but I don’t recommend using it for your XAMPP password since it will erase any users that you may have added for XAMPP access. If you are the only user for the XAMPP pages, then it is ok to use this form to enter a new password.

You can relaunch the security page to see what XAMPP thinks of your security now. To do this, click on “Security” in the left sidebar. The top 3 items should indicate “Secure” now. If not, you have an issue.

Impacts of your new security and testing it

The security step that you just performed means you will need to supply a username and password when accessing /xampp and /phpmyadmin. Let’s test that this is the case.

To test that /xampp needs a password:

  1. Close and reopen your browser (to erase memory of passwords)
  2. Go to http://localhost/xampp, a window should pop up asking you for a password.
  3. Log in with the username/password that you created for /xampp access.
  4. If this brings you to your XAMPP control page, then this test is sucessful.

To test that /phpmyadmin needs a password:

  1. Since this password protection is cookie based (unles you chose http authentification), you don’t need to close and reopen your browser.
  2. Go to http://localhost/phpmyadmin, a web page should pop up asking you for a password.
  3. Enter “root” as your username and give the password that you supplied to the XAMPP security page.
  4. If this brings you to the phpMyAdmin page, then this test is successful.
  5. You may also want to try signing out of phpMyAdmin and signing back in. To sign out, click the button that looks like this: , which is at the top of the left sidebar.

There is a post on the Apache friends forum that advises to change the root user’s username to something other than “root”, to increase your security. See that post for instructions on how to do that if you want to.

How this security was added

For /xampp, the security webpage script created the file c:\xampp\htdocs\xampp\.htaccess, and gave it the following content:

AuthName “xampp user”
AuthType Basic
AuthUserFile “C:\xampp\security\xampp.users”
require valid-user

This adds Basic Authentification to the /xampp folder, and states that the usernames and passwords are stored in the c:\xampp\security\xampp.users file.

The security script also created a new c:\xampp\security\xampp.users file containing the username and password that you entered. If you examine this file in a text editor, you will see that the password is encrypted. For security purposes, it is important to never make the c:\xampp\security folder accessible via the webserver, or a malicious person could have access to this password file.

For securing phpMyAdmin, the security script did the following

  1. Called the php function mysqlrootupdate() in c:\xampp\security\htdocs\securefunctions.php. This function communicates with the MySQL database to change the root password.
  2. Modified your config.inc.php file to change this line:

in order to enable the cookie based web page authentification to your /phpmyadmin page.

More Security

Now, we have the first level of security for XAMPP. There are still some holes. Additional folders and users need password protection. Also, the passwords you just created will be sent in cleartext and anyone with a network sniffer can see them. You will need to enable encryption for the transmission of these passwords. See the overview page for instructions on how to do these things.

The next step in this tutorial is to remove unused folders.

XAMPP/WAMP Apache Won’t Start in Windows 10 Solution

I’ve just upgraded to windows 10 and found that XAMPP/WAMP Apache won’t start anymore for some reasons. It will simply attempt to start but then fail and ask the user to check the Apache error logs.

The “culprit” or should I say, reason, is because windows 10 comes with a service known as World Wide Web Publishing Service (I will just call it WWWPS for short) which is started automatically when windows starts and uses port 80 by default. Port 80 is what Apache in XAMPP/WAMP uses by default as well, and hence why the error above since port 80 has already been taken by WWWPS.

So the solution is pretty simple:
1. Run Command Prompt and type services.msc, then click OK.

2. Scroll To World Wide Web Publishing Service. Note that the Status should say that it is Running.

3. Double Click on that row. Change the Startup type from Automatic to Manual. Next, click on Stop to stop the WWWPS service. Don’t worry, unless you’re running some software that depends on the Microsoft IIS Web Server, you should be fine.

4. Now, try to start Apache again.

Yup, that’s all and it should work. Please leave a comment if this helps or you have other suggestions.

Ismail Chahrazed says

I just did exactly what you say but it stills not working. Any other suggestion please.

Check the apache log file and windows event viewer to see if there are any errors

the solution works but you must be running a new version. I’m now using v3.2.1(i had to upgrade too)

simon frans says

Earl Alvin Alvizo (@props21) says

Thanks David. It fix my xamp

excelent. I tried 1000 way. and read 100000 Article and didn’t work. thank you. your solution is the best.

My Apache started after stopping IIS, but defined virtual host still not works, why?

Brilliant, David. Worked a treat. Many thanks!

I followed you instructions and it failed to work. Then I ran XAMPP control panel as administrator and it works. Just to add another thought.

This seems to be the issue for me. I ran the XAMPP control panel as administrator and it works … (don’t seem to have the World Wide Publishing Service on my computer for whatever reason).

Fernando Soguero Sánchez says

I was looking for a solution to this problem and find this. Thanks to you, my problem is solved!

Guido Vanthienen says

Thank you very much, problem solved

This didnt work for me i couldnt find worl wide web publishing service

Mohd Rizal Mustafa says

it is work.Tq david

Marilyn O’Sullivan says

Thanks so much for this tip. It worked like a charm.

Thank you! This fix did it. Run Apache Run!

Ajit Singh says

hello.. i was fighting with same problem..
it is an unsatisfiying Error message above and i’ve tryed to run my httpd.exe from CommandLine.

it won’t start and, it said me something like that:
“invalid root folder on line 242 of C:\ xampp \ apache \ conf \ httpd . conf”

than i checked the root path in my config file and it was seem correct..

than i checked the root path, and i find out my root folder was missing. i must be accidently delete and forget that shit.. i mean all was my fool 🙂

pls. check your rooth path twice, and naming of your folders (if you renaming the root on desing time). Xamp giving the same error in this case.

Wow it amazing it fix my problem straight away. Give you A++++ for you excellent Help

YOU THE BEST . THANKS MAN

great! you save me

Ray Hendriksma says

Thankyou Soo much!!

Worked! Very simple, thanks,

it works after restart my PC, thanks a lot

Tried to install wampserver on my Windows 10. Get error httpd.exe cannot start correctly 0xc000007b. Tried all tips here and in other places, still nothing. wamp icon remains red, no services running, there isn’t any Apache log to examine. Yes, IIS is stopped, W3SVC too, changed ports from 80 to 8080, all VC++ dlls are installed, tried just runnin httpd.exe as admin but it won’t work.

Thank you! Ran as admin fixed the problem

Meg Morgan says

Thank you so much! It worked perfectly (Apache 2.2) .

WWWPS service wasn’t installed in my w10, still the apache service can’t run. why?

Thank u soooooooooooooooo much

Great. It works, mate. Thank you so much.

Hi tried your solution but i cant seem to find WWWPS, its a new computer. windows 10.
error log[Sun Jan 10 11:13:02.514568 2016] [ssl:warn] [pid 9160:tid 584] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:02.686445 2016] [ssl:warn] [pid 9160:tid 584] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:02.733320 2016] [mpm_winnt:notice] [pid 9160:tid 584] AH00455: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.15 configured — resuming normal operations
[Sun Jan 10 11:13:02.733320 2016] [mpm_winnt:notice] [pid 9160:tid 584] AH00456: Apache Lounge VC11 Server built: Oct 13 2015 10:54:13
[Sun Jan 10 11:13:02.733320 2016] [core:notice] [pid 9160:tid 584] AH00094: Command line: ‘C:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache’
[Sun Jan 10 11:13:05.248970 2016] [mpm_winnt:notice] [pid 9160:tid 584] AH00418: Parent: Created child process 8384
[Sun Jan 10 11:13:05.686474 2016] [ssl:warn] [pid 8384:tid 500] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:05.827102 2016] [ssl:warn] [pid 8384:tid 500] AH01909: http://www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Sun Jan 10 11:13:05.858351 2016] [mpm_winnt:notice] [pid 8384:tid 500] AH00354: Child: Starting 150 worker threads.

Thanks very much David. It works. Your great article solve my problem.

thanks. Now it work. Problem solved

Peter Meint says

January 2016, and it still works perfectly 😉

Thanks, this is very helpful

Hi to all, i have the problems with Apache.
Windows 10, not upgrade.
The versione of XAMPP is 3.2.2
No skype installed..

my file http.conf:
ServerRoot “/xampp/www” www exist.
Listen 8080
ServerName localhost:8080
DocumentRoot “/xampp/www”

From the consolle i read:
Attempting to start Apache service…
Executing “net start “Apache2.4″”
Return code: 0

From Events read:
>>> httpd.exe: Syntax error on line 37 of C:/Program Files (x86)/xampp/apache/conf/httpd.conf: ServerRoot must be a valid directory

Luca, try changing the ServerRoot line to

Saturminus Combie says

Thanks it is running on local-host. I had that in mind but could not access the service.

Found these instructions by accident and while they didn’t work for me, I wanted to pose the following question to whoever reads this: My XAMPP apache 2.4 will not start on computer reboot because the IP Helper service is already started. Once I shut down this sevice, apache runs fine. Has anyone come across this before? I don’t have IIS installed.

Denise Perez says

Solved .
Thank you

Jeff Swanson says

Worked great. Thank you!

Paul Hansen says

Also worked great for me. I was about to reinstall Apache and waste a bunch of time. Thanks tremendously!

same as min bro. I coudnt find wwwPublishing service. my xampp is still not working. I tried many ways but nothing happens.

Add Comment

Your email address will not be published. Required fields are marked *