Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7531

Update 10.0.15 to 10.0.16 -> Error 2003 (HY000) can't connect to MySql server.

Details

    Description

      After Update 10.0.15 to 10.0.16 i get the error: Error 2003 (HY000) can't connect to MySql server.

      The MySQL service is not running and not in the service list?
      Do the update delete somethin?

      After I registration the MySQL service (Mysqld.exe) new, it still works:

      [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MySQL]
      "Type"=dword:00000010
      "Start"=dword:00000002
      "ErrorControl"=dword:00000001
      "ImagePath"=hex(2):22,00,43,00,3a,00,5c,00,50,00,72,00,6f,00,67,00,72,00,61,00,\
      6d,00,20,00,46,00,69,00,6c,00,65,00,73,00,5c,00,4d,00,61,00,72,00,69,00,61,\
      00,44,00,42,00,20,00,31,00,30,00,2e,00,30,00,5c,00,62,00,69,00,6e,00,5c,00,\
      6d,00,79,00,73,00,71,00,6c,00,64,00,2e,00,65,00,78,00,65,00,22,00,20,00,22,\
      00,2d,00,2d,00,64,00,65,00,66,00,61,00,75,00,6c,00,74,00,73,00,2d,00,66,00,\
      69,00,6c,00,65,00,3d,00,43,00,3a,00,5c,00,50,00,72,00,6f,00,67,00,72,00,61,\
      00,6d,00,20,00,46,00,69,00,6c,00,65,00,73,00,5c,00,4d,00,61,00,72,00,69,00,\
      61,00,44,00,42,00,20,00,31,00,30,00,2e,00,30,00,5c,00,64,00,61,00,74,00,61,\
      00,5c,00,6d,00,79,00,2e,00,69,00,6e,00,69,00,22,00,20,00,22,00,4d,00,79,00,\
      53,00,51,00,4c,00,22,00,00,00
      "DisplayName"="MySQL"
      "ObjectName"="NT AUTHORITY
      NetworkService"
      "Description"="MariaDB database server"

      Attachments

        Activity

          Fozziebear Fozziebear added a comment -

          FYI i use tu Update the mariadb-10.0.16-win32.msi MSI Package.

          Fozziebear Fozziebear added a comment - FYI i use tu Update the mariadb-10.0.16-win32.msi MSI Package.

          We've prepared new 10.0.16 MSI packages where this problem is fixed.

          serg Sergei Golubchik added a comment - We've prepared new 10.0.16 MSI packages where this problem is fixed.

          Fozziebear, thanks a lot for reporting it and sorry for the inconvenience.
          Obviously you have already solved it in your installation, the note below is for other users who encounter the problem and find this bug report.
          if you can suggest a better (more reliable, more user-friendly etc.) workaround, please by all means do so.


          If you upgraded your MSI package to 10.0.16 some time between 2015-01-27 and 2015-01-30, you might have started getting the same error as described in this report.
          Your server installation and the data are still in place; what's missing is the Windows service. You can re-create it manually. In cmd, run

          "C:\Program Files\MariaDB 10.0\bin\mysqld.exe" --install MySQL "--defaults-file=C:\Program Files\MariaDB 10.0\data\my.ini"

          (check if the paths and the service name 'MySQL' are correct for you, these are default ones)

          It should say Service successfully installed.
          Then start it either via the task manager, or run in cmd net start MySQL (or whatever service name you chose).

          After that, MariaDB server should get back to normal.

          If you installed new (as opposed to upgraded to) MariaDB 10.0.16 some time between 2015-01-27 and 2015-01-30, you are okay now, but it's possible you will experience the same problem after the next upgrade. If it happens, also do as described above.

          elenst Elena Stepanova added a comment - Fozziebear , thanks a lot for reporting it and sorry for the inconvenience. Obviously you have already solved it in your installation, the note below is for other users who encounter the problem and find this bug report. if you can suggest a better (more reliable, more user-friendly etc.) workaround, please by all means do so. If you upgraded your MSI package to 10.0.16 some time between 2015-01-27 and 2015-01-30, you might have started getting the same error as described in this report. Your server installation and the data are still in place; what's missing is the Windows service. You can re-create it manually. In cmd, run "C:\Program Files\MariaDB 10.0\bin\mysqld.exe" --install MySQL "--defaults-file=C:\Program Files\MariaDB 10.0\data\my.ini" (check if the paths and the service name 'MySQL' are correct for you, these are default ones) It should say Service successfully installed . Then start it either via the task manager, or run in cmd net start MySQL (or whatever service name you chose). After that, MariaDB server should get back to normal. If you installed new (as opposed to upgraded to) MariaDB 10.0.16 some time between 2015-01-27 and 2015-01-30, you are okay now, but it's possible you will experience the same problem after the next upgrade. If it happens, also do as described above.
          Fozziebear Fozziebear added a comment -

          Thanks for the fix.

          Fozziebear Fozziebear added a comment - Thanks for the fix.

          People

            serg Sergei Golubchik
            Fozziebear Fozziebear
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.