MySQL Articles - Boardor

Minimalist Linux Deployment of Enterprise-Level MySQL Server | High Performance Support for Production Environments!

2025-11-19 by boardor

^_^Hello everyone, I am from Code Sea Intelligence!^_^ In enterprise applications, Linux is the preferred operating system for servers, primarily used for databases, middleware servers, and application servers. It is also leading in the deployment of large models that have recently gained popularity! 01 — Environment Preparation Download the Linux version of the MySQL server. … Read more

Developing and Debugging WEB Projects Using the XP Panel on Linux

2025-11-12 by boardor

Click the blue text above ● Follow Jie Chuang Yuan Linux When developing and debugging WEB projects, the configuration of the development environment can sometimes be cumbersome. The XP Panel can be used to integrate the environment. Official website of XP Panel: https://www.xp.cn/ 1. You can use the installation script of the XP Panel for … Read more

Linux Emergency Response – Common Service Logs

2025-11-08 by boardor

System Logs btmp /var/log/btmp records all login attempts that failed, displaying the last ten entries. root@mon0dy-ubuntu:~# lastb –time-format iso -10 root ssh:notty 58.56.52.226 2023-03-11T14:30:23+0800 – 2023-03-11T14:30:23+0800 (00:00) root ssh:notty 58.56.52.226 2023-03-11T14:30:20+0800 – 2023-03-11T14:30:20+0800 (00:00) root ssh:notty 58.56.52.226 2023-03-11T14:30:16+0800 – 2023-03-11T14:30:16+0800 (00:00) root ssh:notty 58.56.52.226 2023-03-11T14:30:05+0800 – 2023-03-11T14:30:05+0800 (00:00) root ssh:notty 58.56.52.226 2023-03-11T14:30:02+0800 – 2023-03-11T14:30:02+0800 (00:00) … Read more

Real Linux Troubleshooting Scenarios: MySQL/MariaDB Server Configuration and Management

2025-11-05 by boardor

Scenario 274: MySQL/MariaDB Service Fails to Start Issue: MySQL/MariaDB service fails to start. Solution: Check the MySQL/MariaDB error log for details: tail -f /var/log/mysql/error.log Verify if there are errors in the MySQL/MariaDB configuration file: cat /etc/my.cnf # or cat /etc/mysql/my.cnf Check for port conflicts: netstat -tulnp | grep 3306 Ensure there is enough disk space. … Read more

Resolving MySQL Startup Issues in Linux Environment: InnoDB Initialization Has Started

2025-10-10 by boardor

Hello everyone, I am Yaoshan, today I will discuss theMySQL startup issues Cause The server was rebooted, and after the server started, I found that the MySQL program did not start, the error message is as follows: 2025-04-19T12:46:47.648559Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.2025-04-19T12:46:55.913703Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 … Read more

Guide to Installing MySQL 5.7 on Linux Without Docker

2025-10-10 by boardor

1. Introduction As of April 20, 2025, the latest version of MySQL is 9.2.0, which I have not specifically studied. New versions always come with some new features, and those interested can check the official website for more information. Different versions can affect the execution of certain statements; for example, there are significant differences between … Read more

How to Change MySQL Data Directory on macOS

2025-09-30 by boardor

Modifying the datadir of MySQL on macOS can indeed fail due to issues related to permissions, configuration file locations, and more. Below is a detailed set of steps and considerations that take into account the characteristics of macOS, which I hope will help you succeed. This case primarily targets MySQL installed via Homebrew (a very … Read more

Implementing DDD with ORM and PyQt6 Using MySQL

2025-09-03 by boardor

SQL: create table School # Create table( `SchoolId` char(5) NOT NULL comment 'Primary key, school number', # Manually input, can also be designed to auto-increment, 5 characters, numeric, or a combination of numeric and characters, with code restrictions when saving data in text. `SchoolName` nvarchar(500) NOT NULL DEFAULT '' comment 'School name', `SchoolTelNo` varchar(8) NULL … Read more

Introduction to Python Series Part 12 (Database Operations)

2025-09-03 by boardor

1. Introduction In application development, data management, such as data storage and retrieval, is a fundamental requirement. Regardless of the type or scale of the application, data storage management is essential. In most business applications, the two most commonly used types of databases are NoSQL databases, such as Redis, and relational databases, such as MySQL. … Read more