Windows 10: Windows 10 update of 9/12 changed xampp, mysql behavior

Insert constructs in mysql/php/pdo (xampp) which have worked for a year suddenly fail:



error code: HY093
error msg: SQLSTATE[HY093]: Invalid parameter number: parameter was not defined


mysql Ver 15.1 Distrib 10.1.38-MariaDB, for Win64 (AMD64)

Windows 10 Pro, 1903, installed 6/16/2019, 18362.356

:)

 

MySQL: Cannot Connect


Actually I am using MySQL coming with XAMPP and it is working just nicely under Windows 10.

 

How to completely uninstall MySQL?

Hi,

Thank you for writing to Microsoft Community Forums.

Which version of Windows is installed on your device?

Refer the article ‘Which Windows operating system am I running’
to provide the details.

I suggest you to follow the steps mentioned below to uninstall MySQL from the device.

Step 1

Uninstall MySQL from Control Panel. To do so,

Go to Control Panel >Programs and Features > Select
MySQL > Click on Uninstall.

After you have uninstalled MySQL through Add/Remove programs, you now need to remove the existing database information which includes your actual data. If you need any of that data, be sure to back it up. Next you can delete
the data directory.

Step 2

Run Command Prompt as Administrator and execute the following command to stop and remove MySQL service.

Net stop MySQL

Sc delete MySQL

Step 3

1. Click on Start, type in Show hidden files and folders.
   
2. Select the View tab and select
   Show hidden files and folders.
   
3. Now explore the following locations and delete following folders.
   
   C:\Program Files\MySQL
   
   C:\Program Files (x86)\MySQL
   
   C:\ProgramData\MySQL
   
   And if exists, delete the folder from the location.
   
   C:\Users\[User-Name]\AppData\Roaming\MySQL
   
4. Restart your device and check the status.
   

Get back to us for further assistance on this issue. We will be happy to help you.

Regards,

Muralidhar

Microsoft Community Moderator

 

XAMPP on Windows 10

You can change the port of apache:

• Go to C:\xampp\apache\conf\httpd.
• Find by combination Ctrl+F line #Listen 12.34.56.78:80 and change the 80 to any you like for example 81
• The same with Listen 80 change to 81
• The same with ServerName localhost:80 change to 81.
• Go to C:\xampp\apache\conf\extra\httpd-vhosts and change 80 to 81

NameVirtualHost *:80 here

VirtualHost *:80 and here (two times)

• Restart apache

To enter your web page type:
http://localhost:81/index.html