How repair corrupt xampp ‘mysql.user’ table?

This is almost certainly a known bug in mariaDB (ie mySQL). See ApacheFriends.org for the description. Problem occurs after user password changes – often user root. General advice seems to be to cut your losses and downgrade your XAMPP to 7.3.5 Otherwise the problem may later recur even after a complete uninstall/re-install of 7.3.7 for … Read more

Apache is not running from XAMPP Control Panel ( Error: Apache shutdown unexpectedly. This may be due to a blocked port)

There are many possible answers for this problem. The most common and most likely is that you’re running another program which is blocking port 80 or 443. If you’ve installed Skype, then you’ve found your problem! Change apache’s port settings to 81 and apache will work. There’s a good tutorial on that To check this … Read more

Error when trying to access XAMPP from a network [closed]

In your xampppath\apache\conf\extra open file httpd-xampp.conf and find the below tag: # Close XAMPP sites here <LocationMatch “^/(?i:(?:xampp|licenses|phpmyadmin|webalizer|server-status|server-info))”> Order deny,allow Deny from all Allow from ::1 127.0.0.0/8 ErrorDocument 403 /error/HTTP_XAMPP_FORBIDDEN.html.var </LocationMatch> and add “Allow from all” after Allow from ::1 127.0.0.0/8 {line} Restart xampp, and you are done. In later versions of Xampp …you can … Read more

PHP on Windows with XAMPP running 100 times too slow

I found the problem was Xdebug in xampp\php\php.ini. Here’re the results of trying many solutions found around the web: Run XAMPP as adminisrator and restart server: 3617 ms In xampp/apache/conf/httpd.conf, replace localhost with 127.0.0.1 and restart server: 3639 ms In Windows/System32/drivers/etc/hosts, add “127.0.0.1 127.0.0.1” & “127.0.0.1 localhost” and restart Windows: 3960 ms In Windows/System32/drivers/etc/hosts, un-comment … Read more

Setting up SSL on a local xampp/apache server

Apache part – enabling you to open https://localhost/xyz There is the config file xampp/apache/conf/extra/httpd-ssl.conf which contains all the ssl specific configuration. It’s fairly well documented, so have a read of the comments and take look at http://httpd.apache.org/docs/2.2/ssl/. The files starts with <IfModule ssl_module>, so it only has an effect if the apache has been started … Read more

MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)

I had this problem after changing the password for the root user in phpMyAdmin. I know nothing about programming but I solved it by doing the following: Go to file C:\wamp\apps\phpmyadmin3.2.0.1\config.inc.php (I guess you would replace “wamp” with the name of your server if you’re not using Wamp Server) Find the line $cfg[‘Servers’][$i][‘password’]=” and change … Read more

Adding VirtualHost fails: Access Forbidden Error 403 (XAMPP) (Windows 7)

Okay: This is what I did now and it’s solved: My httpd-vhosts.conf looks like this now: <VirtualHost dropbox.local:80> DocumentRoot “E:/Documenten/Dropbox/Dropbox/dummy-htdocs” ServerName dropbox.local ErrorLog “logs/dropbox.local-error.log” CustomLog “logs/dropbox.local-access.log” combined <Directory “E:/Documenten/Dropbox/Dropbox/dummy-htdocs”> # AllowOverride All # Deprecated # Order Allow,Deny # Deprecated # Allow from all # Deprecated # –New way of doing it Require all granted </Directory> … Read more

How can I change MariaDB to MySQL in XAMPP?

Running XAMPP with MySQL Here are exact step by step instructions for truly integrating MySQL into XAMPP on Windows. This has been successfully tested with Windows 10 and XAMPP 7.3.11 for both MySQL 8.0.18 and 5.7.28. Stop MySQL (which actually is MariaDB) in the XAMPP Control Panel. Download the MySQL community server as zip archive … Read more