在Visual Studio2017中使用Windows Service访问MySQL数据库

Install-Package MySql.Data -Version 8.0.23

using System.ServiceProcess;
using MySql.Data.MySqlClient;

public class MyService : ServiceBase
{
    protected override void OnStart(string[] args)
    {
        // 连接字符串
        string connectionString = "server=localhost;user=root;database=mydatabase;port=3306;password=mypassword";

        try
        {
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                connection.Open();
                MySqlCommand command = new MySqlCommand("SELECT * FROM mytable", connection);
                MySqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    // 处理数据
                    Console.WriteLine(reader["ColumnName"].ToString());
                }
            }
        }
        catch (Exception ex)
        {
            // 错误处理
            EventLog.WriteEntry("MyService", ex.Message, EventLogEntryType.Error);
        }
    }

    protected override void OnStop()
    {
        // 停止服务时的清理工作
    }
}

using System.Configuration.Install;
using System.ServiceProcess;

[RunInstaller(true)]
public class ProjectInstaller : Installer
{
    private ServiceInstaller serviceInstaller;
    private ServiceProcessInstaller processInstaller;

    public ProjectInstaller()
    {
        processInstaller = new ServiceProcessInstaller();
        serviceInstaller = new ServiceInstaller();

        processInstaller.Account = ServiceAccount.LocalSystem;
        serviceInstaller.StartType = ServiceStartMode.Automatic;
        serviceInstaller.ServiceName = "MyService";
        serviceInstaller.DisplayName = "My Windows Service";

        Installers.Add(serviceInstaller);
        Installers.Add(processInstaller);
    }
}

InstallUtil.exe MyService.exe

connection.ConnectionString += ";Connection Timeout=30";