November 2026
Every post published in November 2026, newest first. Pick a day to jump straight to it.
- Posts
- 863
- Topics
- 79
- Reading time
- 98 h
- Active days
- 15
Posts 841–863 of 863 · November 2–3, 2026
Page 29 of 29
Tuesday, November 3, 2026
2 of 91 posts
Fixed: "ERROR 1064 (42000): You have an error in your SQL syntax … near 'IF NOT EXISTS(SELECT * FROM `__EFMigrationsHistory`'" in an EF Core Idempotent Migration Script
An EF Core idempotent migration script made by dotnet ef migrations script --idempotent failed in MySQL 9.7 with ERROR 1064 at its first IF NOT EXISTS block. Oracle's MySql.EntityFrameworkCore provider writes SQL Server-style IF … BEGIN … END blocks, which MySQL only accepts inside stored programs. Generate the script from the database's last applied migration instead, and it runs.
13 min readFixed: "[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate" in Python on macOS
A Python script on macOS failed to open an HTTPS address with ssl.SSLCertVerificationError: CERTIFICATE_VERIFY_FAILED, unable to get local issuer certificate, while curl opened it fine. Python from python.org uses its own OpenSSL without the Mac's certificates; its Install Certificates script fixes it. Shown on Python 3.15.2.
7 min read
Monday, November 2, 2026
21 posts
How to Connect a .NET C# Web API to a MySQL Database — Part 1: Connect with EF Core and a Secure Connection String
Connect an ASP.NET Core minimal Web API in .NET 10 and C# to MySQL 9.7 with EF Core 10 and Oracle's MySql.EntityFrameworkCore provider. Install the packages, write the DbContext, keep the connection string in user-secrets, require TLS, retry short outages and prove the connection with a readiness health check, then watch the same connection from inside MySQL.
44 min readHow to Add Liveness and Readiness Health Checks to a .NET C# Web API
Add /health/live and /health/ready endpoints to an ASP.NET Core minimal API in .NET 10 and C#: AddHealthChecks, MapHealthChecks, tags and predicates, and an EF Core database check with AddDbContextCheck. See the real 200 and 503 answers when the database goes down and comes back.
9 min readHow to Store a Connection String in .NET C# with dotnet user-secrets
Keep a database connection string and its password out of appsettings.json and out of Git with .NET's Secret Manager: dotnet user-secrets init, set, list, remove and clear, where the secrets file lives, why it's read in Development only, and how the same setting reaches the app as an environment variable everywhere else.
12 min readHow to Create a .NET C# Web API Solution with a Class Library
Create a production-ready .NET 10 C# solution from the command line: an .slnx solution, global.json, shared build rules in Directory.Build.props, central package management, an ASP.NET Core minimal Web API project and a class library that it references. Includes the two errors the strict settings raise on the template, and how to fix them.
19 min readHow to Stop, Start and Remove Docker Compose Containers Without Losing Data
Learn which Docker Compose commands keep your data and which one deletes it: docker compose stop, start, down and up keep a database's named volume, while down -v removes it. Shown live with MySQL 9.7, including proof the data survived.
7 min readHow to Check if a MySQL Connection Uses TLS
Check whether your MySQL connection is encrypted with the status command and the Ssl_cipher and Ssl_version session variables, understand why a Unix socket shows SSL Not in use, make the mysql client require TLS with --ssl-mode=REQUIRED, and check an application's connection in the Performance Schema. Real output from MySQL 9.7.
8 min readHow to Check the MySQL Character Set and Collation
Check the character set and collation of your MySQL server, database and connection, understand what utf8mb4 and utf8mb4_0900_ai_ci mean, and see real proof of accent- and case-insensitive comparisons in MySQL 9.7. Includes the latin1 surprise in Docker's mysql client.
8 min readHow to Check the MySQL Version
Five ways to see exactly which MySQL version you run: SELECT VERSION(), the client's welcome banner, SHOW VARIABLES LIKE 'version%', the status command, and mysqld --version without signing in. Plus why a Docker image tag isn't the exact version. Real output from MySQL 9.7.4.
6 min readHow to Connect to MySQL in a Docker Container with the mysql Client
Open the mysql command-line client that ships inside the official MySQL Docker image with docker compose exec, sign in safely, run your first queries, run a single query or a whole .sql file without staying in, and leave. No MySQL install on your computer. Real output from MySQL 9.7.
11 min readHow to Run MySQL in Docker with Docker Compose
Run MySQL 9.7 LTS on any computer with Docker Desktop: one compose.yaml with a named data volume, a health check, a port only your own computer can reach, and passwords kept in a .env file. Every line explained, with real output from the first start.
15 min readHow to Keep Passwords Out of compose.yaml with an .env File
Keep database passwords out of compose.yaml and out of Git: reference them as ${VARIABLE} with :? so Docker Compose refuses to start without them, store the real values in a git-ignored .env file, and commit a safe .env.example instead. Real output from Docker Compose v5.
8 min readHow to Generate a Strong Random Password in the Terminal
Generate a cryptographically random password with one command, using openssl rand -hex on macOS and Linux and .NET's RandomNumberGenerator in Windows PowerShell, and write it straight into a .env file without it ever appearing on screen.
6 min readHow to Add a .gitignore to a .NET C# Project
Create Microsoft's ready-made .gitignore for .NET and C# with dotnet new gitignore, see what it keeps out of Git (bin, obj, .vs, .env and more), and prove a file is ignored with git check-ignore and git status --ignored. Real output from .NET 10.
6 min readHow to Create a Git Repository and Make Your First Commit
Turn any project folder into a Git repository with git init -b main, then stage and commit your files with git add and git commit, step by step, with real output on Git 2.56 and the same commands for macOS, Linux and Windows.
8 min readFixed: Git Shows Every Line Changed in Files from dotnet new (CRLF Line Endings)
A small change to a .NET project file showed up in Git as every line changed. The dotnet new Web API template ships Windows CRLF line endings, even on macOS, and dotnet commands rewrite files with LF. A .gitattributes file with * text=auto and git add --renormalize fixes it for good.
8 min readFixed: error CA1852: Type 'WeatherForecast' can be sealed because it has no subtypes in its containing assembly and is not externally visible
A brand-new .NET 10 Web API failed to build with error CA1852 on the template's WeatherForecast record, once the recommended analysis rules and TreatWarningsAsErrors were on. Mark the type sealed, as Microsoft's rule page says, and the build succeeds.
6 min readFixed: warning Unable to find a project to restore!
dotnet restore printed warning Unable to find a project to restore! in a .NET 10 solution folder, because the .slnx solution didn't list any projects yet. Restore the project by its path, or add the projects to the solution with dotnet sln add and restore again.
5 min readFixed: error NU1008: The following PackageReference items cannot define a value for Version
dotnet new webapi failed its restore with error NU1008 in a .NET 10 solution that uses central package management, because the template writes the package version into the project file. Move the version to Directory.Packages.props, remove it from the PackageReference, and restore again.
6 min readFixed: Warning 1287: 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated and will be removed in a future release
SHOW PROCESSLIST in MySQL 9.7 answered with 1 warning, and SHOW WARNINGS revealed Warning 1287: 'INFORMATION_SCHEMA.PROCESSLIST' is deprecated. Query performance_schema.processlist instead: the same connections, no warning, and a server setting isn't needed.
6 min readFixed: "ERROR 1045 (28000): Access denied for user 'inventory_app'@'localhost' (using password: YES)" in a MySQL Docker Container
I changed MYSQL_PASSWORD in .env, recreated my MySQL 9.7 container with Docker Compose, and the new password was rejected. The official image only applies its MYSQL_* settings on the very first start. Here is how I proved it and fixed it with ALTER USER without losing any data.
11 min readFixed: Accented Letters Disappear When Typed into the mysql Client in a Docker Container
I typed SELECT 'café' into the mysql client inside the official MySQL 9.7 Docker container and got 'caf': the é never arrived. The container has no locale set. Passing -e LANG=C.utf8 to docker compose exec fixes typing and switches the client to utf8mb4.
8 min read