Member Avatar for khoobl

I would like to create a deployment project for my application. And my application need mysql as database, my deployment package will package the mysql installation. How to use VB.net to check whether mysql had been installed in the client PC and if not install, mysql installation will be initiated before my application instalation start. Hope to get reply with tips, sample code or guide on how to do this. THANK YOU !! :?:

  • 3 Contributors
  • 2 Replies
  • 213 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by cpopham

Dani AI

Generated

Short answer and context: installing a full MySQL server on every client is a common anti-pattern (see ). If you need a local, single-file embedded DB instead of a client/server install, use SQLite (serverless, zero-configuration) as a much simpler alternative: SQLite about page.

If you do need MySQL on the client (offline desktop app or special local-server case), do not try to script raw EXEs from your app. Use a real bootstrapper that detects prerequisites, skips install when present, and chains the MySQL installer before your app installer. Two practical options:

  • Add MySQL as a prerequisite using Visual Studio bootstrapper manifests (or the Bootstrapper Manifest Generator), or
  • Build a bundle with WiX Burn to check registry/service presence and run the MySQL MSI/EXE in order. See WiX Burn docs: WiX Bundle (Burn). MySQL supports MSI command-line installs and a command-line installer console for scripted installs/configuration. See MySQL Installer Console and Windows MSI notes: and msiexec command-line options.

Detection + an install example (VB.NET)

  • Detect by registry key and by Windows service (fast and reliable).
  • If missing, launch the MSI with msiexec in quiet mode and wait for exit.
Imports System.ServiceProcess
Imports Microsoft.Win32
Imports System.Diagnostics

Function IsMySqlInstalled() As Boolean
    Using key = Registry.LocalMachine.OpenSubKey("SOFTWARE\MySQL AB")
        If key IsNot Nothing Then Return True
    End Using

    For Each svc In ServiceController.GetServices()
        If svc.ServiceName.StartsWith("MySQL", StringComparison.InvariantCultureIgnoreCase) _
           OrElse svc.DisplayName.IndexOf("MySQL", StringComparison.InvariantCultureIgnoreCase) >= 0 Then
            Return True
        End If
    Next

    Return False
End Function

' Example: run MSI silently (replace file name)
Dim psi As New ProcessStartInfo("msiexec.exe", "/i ""mysql-server.msi"" /qn /norestart")
psi.UseShellExecute = True
psi.Verb = "runas"   ' request elevation
Process.Start(psi).WaitForExit()

Notes, gotchas and next steps:

  • The MySQL installer typically writes keys under HKEY_LOCAL_MACHINE\SOFTWARE\MySQL AB and the service default name is "MySQL" (instances may use names like MySQL80); see MySQL docs on installation and Windows services for details. (MySQL install notes, starting as Windows service)
  • Test the full install sequence on a clean VM to catch UAC/elevation, VC++ redistributable, firewall and reboot issues.
  • After install, verify the server is running and test a connection from your app using MySQL Connector/NET: Connector/NET docs.
  • If you need help authoring a bootstrapper manifest or a WiX chain, focus on writing a DetectCondition (registry or service check), passing silent arguments to the vendor installer, logging the install, and failing cleanly if a prerequisite fails.

Recommended Answers

All 2 Replies

Member Avatar for Paladine

Pretty broad, and large topic to provide information on. What have you got for code/tips already (not in detail). What instal software are you using (Wise Solutions Installer? Install Shield?) or do you plan to do this solely through VB.Net with some sort of MSI instal file?

I would like to create a deployment project for my application. And my application need mysql as database, my deployment package will package the mysql installation. How to use VB.net to check whether mysql had been installed in the client PC and if not install, mysql installation will be initiated before my application instalation start. Hope to get reply with tips, sample code or guide on how to do this. THANK YOU !! :?:

Member Avatar for cpopham

Why are you needing mysql installed on all of the local machines. This would create many servers, which can be a security risk. A major point of having a database server is to bring all of the data to a central location.

Chester

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.