[MDEV-7531] Update 10.0.15 to 10.0.16 -> Error 2003 (HY000) can't connect to MySql server. Created: 2015-01-29  Updated: 2015-02-02  Resolved: 2015-01-30

Status: Closed
Project: MariaDB Server
Component/s: Platform Windows
Affects Version/s: 10.0.16
Fix Version/s: 10.0.16

Type: Bug Priority: Critical
Reporter: Fozziebear Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: update, verified
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"

 Comments   
Comment by Fozziebear [ 2015-01-30 ]

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

Comment by Sergei Golubchik [ 2015-01-30 ]

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

Comment by Elena Stepanova [ 2015-01-31 ]

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.

Comment by Fozziebear [ 2015-02-02 ]

Thanks for the fix.

Generated at Thu Feb 08 07:20:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.