Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.0.16
-
Fix Version/s: 10.0.16
-
Component/s: Platform Windows
-
Environment:Windows 7 32 Bit
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"
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
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.
Thanks for the fix.
FYI i use tu Update the mariadb-10.0.16-win32.msi MSI Package.