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

Discus and support Windows 10 update of 9/12 changed xampp, mysql behavior in Windows 10 Installation and Upgrade to solve the problem; Insert constructs in mysql/php/pdo (xampp) which have worked for a year suddenly fail: error code: HY093 error msg: SQLSTATE[HY093]: Invalid... Discussion in 'Windows 10 Installation and Upgrade' started by hugh3700, Sep 12, 2019.

  1. hugh3700 Win User

    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

    :)
     
    hugh3700, Sep 12, 2019
    #1
  2. Joergi Win User

    MySQL: Cannot Connect


    Actually I am using MySQL coming with XAMPP and it is working just nicely under Windows 10.
     
    Joergi, Sep 12, 2019
    #2
  3. 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
     
    Muralidhar_G, Sep 12, 2019
    #3
  4. jFax Win User

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

    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
     
Thema:

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

Loading...
  1. Windows 10 update of 9/12 changed xampp, mysql behavior - Similar Threads - update changed xampp

  2. Surprise, Microsoft changed Windows Update behavior for the better in Windows 10 1903

    in Windows 10 News
    Surprise, Microsoft changed Windows Update behavior for the better in Windows 10 1903: Since the release of Microsoft's Windows 10 operating system in 2015, updating and patching was at the heart of criticism that administrators and power users leveled at Microsoft. It was not the only argument brought forth against Windows 10, Telemetry being another, but it...
  3. Windows 10: Change to 12 Hour Clock

    in Windows 10 BSOD Crashes and Debugging
    Windows 10: Change to 12 Hour Clock: Windows 10: I want to change from 24 hour clock to 12 hour clock. I did several searches on the Internet. Says to go to Time&Language -> Change date& time -> format -> But the formats offered in the drop down are of the form HH:mm and HH:mm:ss. There are no formats of the...
  4. Unexplained changes to Windows 10 desktop, app behavior

    in Windows 10 Customization
    Unexplained changes to Windows 10 desktop, app behavior: Unexplained changes to my PC: 1. All apps now run full-screen - 'restore down' button in upper right doesn't work to switch app to window 2. Lists in Windows Explorer changed from single-spaced to double-spaced 3. Icon for background screen capture utility (Snagit) now...
  5. fyi -- Windows Update from 9/12/2018

    in Windows 10 Installation and Upgrade
    fyi -- Windows Update from 9/12/2018: Just installed updates kb4457128 kb4456655 kb4457146 on one of my computers, the updates seemed to work OK and have no side effects. on another computer, could not open any app as administrator -- could hear the window pop up asking for permission, but no window was...
  6. afertr restore windows xampp not installing

    in Windows 10 Installation and Upgrade
    afertr restore windows xampp not installing: Hi, last week my laptop windows10 is need restore after install windows I was try to reinstall xampp server but it was not install . kindly solve my problem thank you....
  7. Windows 10 Update Behavior

    in Windows 10 Installation and Upgrade
    Windows 10 Update Behavior: Wanted to find out HOW to change The Behavior of Windows Update?? Recent Event: I was in a MMO Game doing a Raid with a Group. Update Literally Yanked Me out of the Game so it could Update my Windows. I was NOT a Happy Camper. Sad Part is I was the Raid Leader. Can't Update...
  8. Wiindows Update 9/12/17 has killed IE

    in Browsers and Email
    Wiindows Update 9/12/17 has killed IE: This week's big patch installed unexpectedly fast considering the list of issues it claims to address, but when the PC came back up, IE was dead. The program file is still there but clicking it gives only a brief hourglass (and brief presence in Task Manager), then nothing....
  9. Windows 10 changes Outlook default behavior

    in Browsers and Email
    Windows 10 changes Outlook default behavior: In upgrading from Windows 8 to Win10, it's changed a number of default settings which I can't figure out how to change. First, when I send a message in Outlook 2013, it returns me to the desktop instead of the Inbox. THis is incredibly annoying. Does anyone know how to...
  10. Windows 9 Could Launch with DirectX 12 – Report

    in Windows 10 News
    Windows 9 Could Launch with DirectX 12 – Report: Microsoft is getting ready to introduce a new DirectX version, as the company has recently launched a teaser indicating that the unveiling could take place at the Game Developer Conference on March 20. The teaser page published on the MSDN blogs also displays the logos of...