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

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

Running Python scripts with Xampp

Run Python in XAMPP for Windows Step 1: Download and Install Python Download and install the latest version of Python from https://www.python.org/downloads. Step 2: Configure XAMPP for Python Open the Apache httpd.conf configuration file located at …/xampp/apache/conf/httpd.conf using a text editor of your choice. The XAMPP GUI can also quickly access the httpd.conf file: Copy … Read more

What is the location of mysql client “.my.cnf” in XAMPP for Windows?

Type this: mysql –help Then look at the output. There is a block of text about 3/4 the way down describing what files it finds its defaults .my.cnf from. Here is an example from XAMPP v3.2.1, default options are read from the following files in the given order: C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf C:\xampp\mysql\my.ini C:\xampp\mysql\my.cnf C:\xampp\mysql\bin\my.ini … Read more

Why does Microsoft Edge open some local websites, but not others, where the domain name is routed to 127.0.0.1 in hosts file

Your network can block loopback as a security measure in Windows 10. Open a command prompt as administrator, and run this to exempt Edge from a loopback: CheckNetIsolation LoopbackExempt -a -n=”Microsoft.MicrosoftEdge_8wekyb3d8bbwe” (Microsoft.MicrosoftEdge_8wekyb3d8bbwe is the identifier for the Edge app) There’s a blog post here giving more detail: https://blogs.msdn.microsoft.com/msgulfcommunity/2015/07/01/how-to-debug-localhost-on-microsoft-edge/