Database Administration
MySQL, SQL Server, Oracle, SQLite and recovery notes · 21 notes
Practical Tech & Game Server Notes for Real-World Projects
Hands-on notes for databases, web deployment, AI environments, Minecraft servers, game backend services, and developer workflows.
Explore by Topic
Web App Deployment
Flask, Java Web, Spring Boot, Vue and server setup · 2 notes
AI & Deep Learning
PyTorch, computer vision, LLMs and model environments · 7 notes
Developer Environment
Windows, Linux, macOS, Docker, VS Code and Java tooling · 5 notes
Game Server Development
Minecraft servers, plugins, mods, GTA V FiveM and game backend services · 2 notes
Latest Project Notes
Database Administration
Trying to Recover Accidentally Deleted MySQL 8.0 Data on CentOS 8 Using InnoDB File-Level Recovery
Overview This article documents a real-world data recovery case on a CentOS 8 server running MySQL 8.0. An accidental DELETE operation removed critical rows from production tables. Because…
Database Administration
Fix MySQL Account Is Locked Error on Windows
A practical MySQL account is locked recovery case on Windows, covering root@localhost unlock, skip-grant-tables, named pipe access, datadir mismatch checks, mysql.user updates, and normal login verification.
Database Administration
Installing MySQL 8.0.42 from the ZIP Package on Windows and Resetting the Root Password
Overview This article documents a hands-on process for installing MySQL 8.0.42 from the ZIP package on Windows, initializing the data directory, registering the Windows service, and resetting the…
Database Administration
Fix MySQL Startup Failure on Windows from secure-file-priv Error
A practical MySQL startup failure troubleshooting case on Windows, covering secure-file-priv path errors, a missing uploads directory, my.ini checks, mysqld console testing, and MySQL service reinstall steps.
Database Administration
Fix DBeaver InterSystems JDBC Connection Failure on Windows
A practical DBeaver InterSystems JDBC connection troubleshooting case on Windows, covering IRISDriver errors, Ensemble and Cache-compatible JDBC settings, driver class names, URL templates, and JAR file checks.
Database Administration
Fix MySQL Command Not Found and libncurses.so.5 Missing on Linux
Fix MySQL command not found on Linux when MySQL 5.7 is installed but the mysql client cannot run because of PATH issues or missing libncurses.so.5.
Database Administration
MySQL Root Password Recovery on Windows and datadir Startup Fix
A practical MySQL root password recovery workflow on Windows, including skip-grant-tables, named pipe connection, root password reset, MySQL service restart, and datadir startup error troubleshooting.