• Can't start the server after installation

    From Fokke Nauta@21:1/5 to All on Mon May 10 11:19:19 2021
    Hi all,

    We run a Windows 10 Pro x64 pc as a server. MySQL was installed and ran
    fine. No problems. Recently I tried to update it with the 8.0.24
    installer. Everything worked fine, except that when applying the
    configuration, the server won't start. I waited quite a long time,
    untill I got a popup with the message "MySQL server 8.0.24 configuration
    is taking longer than expected".
    Then I stopped the proces and uninstalled the server and it's components completely.
    I installed a new server, 8.0.24. Settings: Developement (default). Same problem, installation works fine but the server won't start. After
    waiting a long time I interrupted the process and uninstalled the server
    again and all of it's components. Then I installed the server again, but
    now as MySQL server only.
    The same problem ocurred.
    What can be wrong? What can I do to make the server run?

    Thanks in advance for your answers.

    Fokke Nauta

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From J.O. Aho@21:1/5 to Fokke Nauta on Mon May 10 11:39:47 2021
    On 10/05/2021 11.19, Fokke Nauta wrote:
    Hi all,

    We run a Windows 10 Pro x64 pc as a server. MySQL was installed and ran
    fine. No problems. Recently I tried to update it with the 8.0.24
    installer. Everything worked fine, except that when applying the configuration, the server won't start. I waited quite a long time,
    untill I got a popup with the message "MySQL server 8.0.24 configuration
    is taking longer than expected".
    Then I stopped the proces and uninstalled the server and it's components completely.
    I installed a new server, 8.0.24. Settings: Developement (default). Same problem, installation works fine but the server won't start. After
    waiting a long time I interrupted the process and uninstalled the server again and all of it's components. Then I installed the server again, but
    now as MySQL server only.
    The same problem ocurred.
    What can be wrong? What can I do to make the server run?

    I suggest you start your event viewer and look for events in there, sure
    it had been easier if it has been searchable, but sadly closed source
    products ain't that user friendly.
    Stability with the combination MySQL and MS-Windows have been bad, I
    would recommend to use another OS to run it on, for local testing WSL
    seems to work quite ok.


    I would do recommend you to test MariaDB, go for the 10.x version, it's
    open with it's bug fixes which Oracle ain't. Still they are more or less
    just drop in replacements for each other.

    --

    //Aho

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Fokke Nauta@21:1/5 to J.O. Aho on Mon May 10 16:24:04 2021
    On 10/05/2021 11:39, J.O. Aho wrote:
    On 10/05/2021 11.19, Fokke Nauta wrote:
    Hi all,

    We run a Windows 10 Pro x64 pc as a server. MySQL was installed and
    ran fine. No problems. Recently I tried to update it with the 8.0.24
    installer. Everything worked fine, except that when applying the
    configuration, the server won't start. I waited quite a long time,
    untill I got a popup with the message "MySQL server 8.0.24
    configuration is taking longer than expected".
    Then I stopped the proces and uninstalled the server and it's
    components completely.
    I installed a new server, 8.0.24. Settings: Developement (default).
    Same problem, installation works fine but the server won't start.
    After waiting a long time I interrupted the process and uninstalled
    the server again and all of it's components. Then I installed the
    server again, but now as MySQL server only.
    The same problem ocurred.
    What can be wrong? What can I do to make the server run?

    I suggest you start your event viewer and look for events in there, sure
    it had been easier if it has been searchable, but sadly closed source products ain't that user friendly.
    Stability with the combination MySQL and MS-Windows have been bad, I
    would recommend to use another OS to run it on, for local testing WSL
    seems to work quite ok.


    I would do recommend you to test MariaDB, go for the 10.x version, it's
    open with it's bug fixes which Oracle ain't. Still they are more or less
    just drop in replacements for each other.


    Hi,

    Thanks for your quick response.
    I just found the cause. Allthough during the installation I specified a
    special database location, which I replaced with the original data after
    the installation, MySQL didn't see the databases. I found that it looked
    at a different location. After replacing those files with the original
    ones, it works fine.

    Using another OS is no option, unfortunately. There are many good
    Linuxes around, but my knowledge of them is too little to fully use them.

    Fokke

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Luuk@21:1/5 to Fokke Nauta on Mon May 10 21:03:52 2021
    On 10-5-2021 16:24, Fokke Nauta wrote:
    On 10/05/2021 11:39, J.O. Aho wrote:
    On 10/05/2021 11.19, Fokke Nauta wrote:
    Hi all,

    We run a Windows 10 Pro x64 pc as a server. MySQL was installed and
    ran fine. No problems. Recently I tried to update it with the 8.0.24
    installer. Everything worked fine, except that when applying the
    configuration, the server won't start. I waited quite a long time,
    untill I got a popup with the message "MySQL server 8.0.24
    configuration is taking longer than expected".
    Then I stopped the proces and uninstalled the server and it's
    components completely.
    I installed a new server, 8.0.24. Settings: Developement (default).
    Same problem, installation works fine but the server won't start.
    After waiting a long time I interrupted the process and uninstalled
    the server again and all of it's components. Then I installed the
    server again, but now as MySQL server only.
    The same problem ocurred.
    What can be wrong? What can I do to make the server run?

    I suggest you start your event viewer and look for events in there,
    sure it had been easier if it has been searchable, but sadly closed
    source products ain't that user friendly.
    Stability with the combination MySQL and MS-Windows have been bad, I
    would recommend to use another OS to run it on, for local testing WSL
    seems to work quite ok.


    I would do recommend you to test MariaDB, go for the 10.x version,
    it's open with it's bug fixes which Oracle ain't. Still they are more
    or less just drop in replacements for each other.


    Hi,

    Thanks for your quick response.
    I just found the cause. Allthough during the installation I specified a special database location, which I replaced with the original data after
    the installation, MySQL didn't see the databases. I found that it looked
    at a different location. After replacing those files with the original
    ones, it works fine.

    Using another OS is no option, unfortunately. There are many good
    Linuxes around, but my knowledge of them is too little to fully use them.

    Fokke

    But MariaDB is not an OS,
    Just as MySQL is not an OS.

    Ubuntu, or Debian, that are OS.

    You definitely need start reading some of the articles found here: https://www.google.com/search?q=mysql+vs+mariadb

    😉

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Fokke Nauta@21:1/5 to Luuk on Tue May 11 09:13:45 2021
    On 10/05/2021 21:03, Luuk wrote:
    On 10-5-2021 16:24, Fokke Nauta wrote:
    On 10/05/2021 11:39, J.O. Aho wrote:
    On 10/05/2021 11.19, Fokke Nauta wrote:
    Hi all,

    We run a Windows 10 Pro x64 pc as a server. MySQL was installed and
    ran fine. No problems. Recently I tried to update it with the 8.0.24
    installer. Everything worked fine, except that when applying the
    configuration, the server won't start. I waited quite a long time,
    untill I got a popup with the message "MySQL server 8.0.24
    configuration is taking longer than expected".
    Then I stopped the proces and uninstalled the server and it's
    components completely.
    I installed a new server, 8.0.24. Settings: Developement (default).
    Same problem, installation works fine but the server won't start.
    After waiting a long time I interrupted the process and uninstalled
    the server again and all of it's components. Then I installed the
    server again, but now as MySQL server only.
    The same problem ocurred.
    What can be wrong? What can I do to make the server run?

    I suggest you start your event viewer and look for events in there,
    sure it had been easier if it has been searchable, but sadly closed
    source products ain't that user friendly.
    Stability with the combination MySQL and MS-Windows have been bad, I
    would recommend to use another OS to run it on, for local testing WSL
    seems to work quite ok.


    I would do recommend you to test MariaDB, go for the 10.x version,
    it's open with it's bug fixes which Oracle ain't. Still they are more
    or less just drop in replacements for each other.


    Hi,

    Thanks for your quick response.
    I just found the cause. Allthough during the installation I specified
    a special database location, which I replaced with the original data
    after the installation, MySQL didn't see the databases. I found that
    it looked at a different location. After replacing those files with
    the original ones, it works fine.

    Using another OS is no option, unfortunately. There are many good
    Linuxes around, but my knowledge of them is too little to fully use them.

    Fokke

    But MariaDB is not an OS,
    Just as MySQL is not an OS.

    Ubuntu, or Debian, that are OS.

    You definitely need start reading some of the articles found here: https://www.google.com/search?q=mysql+vs+mariadb

    😉


    He suggested to use a different OS: "Stability with the combination MySQL and MS-Windows have been bad, I
    would recommend to use another OS to run it on, for local testing WSL
    seems to work quite ok."

    Fokke

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From J.O. Aho@21:1/5 to Fokke Nauta on Tue May 11 10:34:15 2021
    On 11/05/2021 09.13, Fokke Nauta wrote:
    On 10/05/2021 21:03, Luuk wrote:
    On 10-5-2021 16:24, Fokke Nauta wrote:

    But MariaDB is not an OS,
    Just as MySQL is not an OS.

    Ubuntu, or Debian, that are OS.

    He suggested to use a different OS: "Stability with the combination
    MySQL and MS-Windows have been bad, I
    would recommend to use another OS to run it on, for local testing
    WSL seems to work quite ok."

    I had two suggestions, one was using MariaDB and and another one to
    switch OS.

    Myself at work I use WSL as we have a closed source OS on our
    development machines, this gives the simplicity of installing programs
    with a package manager (no need to go to shady websites and download
    binaries) and of course configuration a lot more like in production environment.


    I do recommend you to learn Linux, as that will be more and more
    required knowledge. A good starting point can be microsofts WSL
    introduction: https://docs.microsoft.com/en-us/learn/modules/get-started-with-windows-subsystem-for-linux/

    --

    //Aho

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Fokke Nauta@21:1/5 to J.O. Aho on Thu May 13 15:09:33 2021
    On 11/05/2021 10:34, J.O. Aho wrote:

    On 11/05/2021 09.13, Fokke Nauta wrote:
    On 10/05/2021 21:03, Luuk wrote:
    On 10-5-2021 16:24, Fokke Nauta wrote:

    But MariaDB is not an OS,
    Just as MySQL is not an OS.

    Ubuntu, or Debian, that are OS.

    He suggested to use a different OS: "Stability with the combination
    MySQL and MS-Windows have been bad, I
    would recommend to use another OS to run it on, for local testing
    WSL seems to work quite ok."

    I had two suggestions, one was using MariaDB and and another one to
    switch OS.

    Myself at work I use WSL as we have a closed source OS on our
    development machines, this gives the simplicity of installing programs
    with a package manager (no need to go to shady websites and download binaries) and of course configuration a lot more like in production environment.


    I do recommend you to learn Linux, as that will be more and more
    required knowledge. A good starting point can be microsofts WSL
    introduction: https://docs.microsoft.com/en-us/learn/modules/get-started-with-windows-subsystem-for-linux/



    I have used the MariaDB, which was installed when I installed XAMPP. It
    worked fine. But due to XAMPP is was difficult to manage, so I removed
    it and installed MySQL community server separately. Server only, no developement.
    Then my problem started and I was happy to fix it. Since then it runs fine.

    I know quite a lot about Linux. Followed a course of Unix long time ago.
    I have VMWare installed and have a lot of Linuxes as virtual machines.
    On an old laptop I replaced Windows by Zorin OS. This works fine.
    But with Linux there are still some difficulties. Sometimes I run into
    problems with managing the rights, or with an application that won't work.
    My knowledge of Linux is nog good enough to run it on our server.
    I can handle Windows very well, and that's the reason I chose for
    Windows on our server.

    Fokke

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)