https://www.dkpminus.com/wow/private-servers/

https://uwow.biz/

https://www.dkpminus.com/blog/vanilla-wow-download-1-12-1-client/...

2025-10-06T08:27:04.914780Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824
2025-10-06T08:27:04.914979Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2025-10-06T08:27:04.914987Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2025-10-06T08:27:04.915012Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2025-10-06T08:27:04.915041Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 85559 ...
2025-10-06T08:27:04.919351Z 0 [Warning] You need to use --log-bin to make --binlog-format work.
2025-10-06T08:27:04.934818Z 0 [Note] InnoDB: PUNCH HOLE support available
2025-10-06T08:27:04.934870Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2025-10-06T08:27:04.934876Z 0 [Note] InnoDB: Uses event mutexes
2025-10-06T08:27:04.934879Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2025-10-06T08:27:04.934885Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-10-06T08:27:04.935330Z 0 [Note] InnoDB: Number of pools: 1
2025-10-06T08:27:04.935444Z 0 [Note] InnoDB: Using CPU crc32 instructions
2025-10-06T08:27:04.936628Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M
2025-10-06T08:27:04.992772Z 0 [Note] InnoDB: Completed initialization of buffer pool
2025-10-06T08:27:05.010105Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2025-10-06T08:27:05.023372Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2025-10-06T08:27:05.044447Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2025-10-06T08:27:05.044529Z 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2025-10-06T08:27:05.087963Z 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2025-10-06T08:27:05.089303Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2025-10-06T08:27:05.089329Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2025-10-06T08:27:05.090158Z 0 [Note] InnoDB: 5.7.44 started; log sequence number 2811868
2025-10-06T08:27:05.090369Z 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2025-10-06T08:27:05.090584Z 0 [Note] InnoDB: Buffer pool(s) load completed at 251006 16:27:05
2025-10-06T08:27:05.090636Z 0 [Note] Plugin 'FEDERATED' is disabled.
mysqld: Table 'mysql.plugin' doesn't exist
2025-10-06T08:27:05.090833Z 0 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
2025-10-06T08:27:05.091488Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2025-10-06T08:27:05.093354Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2025-10-06T08:27:05.093377Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2025-10-06T08:27:05.093385Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2025-10-06T08:27:05.093388Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2025-10-06T08:27:05.093973Z 0 [Warning] CA certificate ca.pem is self signed.
2025-10-06T08:27:05.094011Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2025-10-06T08:27:05.094084Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2025-10-06T08:27:05.094128Z 0 [Note] IPv6 is available.
2025-10-06T08:27:05.094134Z 0 [Note]   - '::' resolves to '::';
2025-10-06T08:27:05.094153Z 0 [Note] Server socket created on IP: '::'.
2025-10-06T08:27:05.096829Z 0 [Warning] Failed to open optimizer cost constant tables

2025-10-06T08:27:05.096982Z 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2025-10-06T08:27:05.097013Z 0 [ERROR] Fatal error: Failed to initialize ACL/grant/time zones structures or failed to remove temporary table files.
2025-10-06T08:27:05.097091Z 0 [ERROR] Aborting

2025-10-06T08:27:05.097118Z 0 [Note] Binlog end
2025-10-06T08:27:05.097186Z 0 [Note] Shutting down plugin 'ngram'
2025-10-06T08:27:05.097193Z 0 [Note] Shutting down plugin 'partition'
2025-10-06T08:27:05.097197Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2025-10-06T08:27:05.097200Z 0 [Note] Shutting down plugin 'ARCHIVE'
2025-10-06T08:27:05.097203Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-10-06T08:27:05.097257Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2025-10-06T08:27:05.097260Z 0 [Note] Shutting down plugin 'MyISAM'
2025-10-06T08:27:05.097275Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2025-10-06T08:27:05.097279Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2025-10-06T08:27:05.097282Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2025-10-06T08:27:05.097285Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2025-10-06T08:27:05.097288Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2025-10-06T08:27:05.097290Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2025-10-06T08:27:05.097293Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2025-10-06T08:27:05.097296Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2025-10-06T08:27:05.097299Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2025-10-06T08:27:05.097301Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2025-10-06T08:27:05.097304Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2025-10-06T08:27:05.097307Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2025-10-06T08:27:05.097310Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2025-10-06T08:27:05.097312Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2025-10-06T08:27:05.097315Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2025-10-06T08:27:05.097317Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2025-10-06T08:27:05.097320Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2025-10-06T08:27:05.097323Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2025-10-06T08:27:05.097325Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2025-10-06T08:27:05.097328Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2025-10-06T08:27:05.097330Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2025-10-06T08:27:05.097333Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2025-10-06T08:27:05.097336Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-10-06T08:27:05.097338Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2025-10-06T08:27:05.097341Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2025-10-06T08:27:05.097344Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2025-10-06T08:27:05.097347Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2025-10-06T08:27:05.097349Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2025-10-06T08:27:05.097352Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2025-10-06T08:27:05.097355Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2025-10-06T08:27:05.097357Z 0 [Note] Shutting down plugin 'InnoDB'
2025-10-06T08:27:05.097468Z 0 [Note] InnoDB: FTS optimize thread exiting.
2025-10-06T08:27:05.097606Z 0 [Note] InnoDB: Starting shutdown...
2025-10-06T08:27:05.198024Z 0 [Note] InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2025-10-06T08:27:05.198252Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 251006 16:27:05
2025-10-06T08:27:06.512887Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2811887
2025-10-06T08:27:06.514962Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2025-10-06T08:27:06.514993Z 0 [Note] Shutting down plugin 'MEMORY'
2025-10-06T08:27:06.515000Z 0 [Note] Shutting down plugin 'CSV'
2025-10-06T08:27:06.515004Z 0 [Note] Shutting down plugin 'sha256_password'
2025-10-06T08:27:06.515006Z 0 [Note] Shutting down plugin 'mysql_native_password'
2025-10-06T08:27:06.515148Z 0 [Note] Shutting down plugin 'binlog'
2025-10-06T08:27:06.516999Z 0 [Note] /www/server/mysql/bin/mysqld: Shutdown complete

20251006 1628 ...

ss -tulnp | grep -E '80|443'

set realmlist 137.184.177.199:80

# 修改 .env 文件中的端口映射
sed -i 's/DOCKER_AUTH_EXTERNAL_PORT=.*/DOCKER_AUTH_EXTERNAL_PORT=80/' /opt/azerothcore-wotlk/.env
sed -i 's/DOCKER_WORLD_EXTERNAL_PORT=.*/DOCKER_WORLD_EXTERNAL_PORT=443/' /opt/azerothcore-wotlk/.env
# 修改 authserver.conf 文件
sed -i 's/RealmServerPort.*/RealmServerPort = 80/' /opt/azerothcore-wotlk/env/dist/etc/authserver.conf
# 修改 worldserver.conf 文件
sed -i 's/WorldServerPort.*/WorldServerPort = 443/' /opt/azerothcore-wotlk/env/dist/etc/worldserver.conf
# 重启容器
docker compose down && docker compose up -d

20251006 ...

现在整机扫描mysqld.service

sudo find / -name mysqld.service -type f 2>/dev/null

Kimi:

问题复盘：aaPanel 一键安装 MySQL 5.7 后，**「重启 MySQL」按钮（或 systemctl restart mysql）总是失败**，日志只看到 mysqld 干净退出，无端口冲突报错。

根因

aaPanel 把 MySQL 程序和数据放在非标准路径（`/www/server/mysql` + `/www/server/data`），却**没有生成永久的 systemd 单元文件**；系统默认的 `mysql.service` 指向 `/var/lib/mysql`，路径不对，启动即失败。

表象

```

systemctl restart mysql → 失败

systemctl status mysql → 找不到服务或路径错误

/run/systemd/generator.late/mysqld.service 是唯一生成的临时单元，重启后消失。

```

解决办法（三步）

1. 找到真实单元

```bash

sudo find / -name mysqld.service -type f

```

通常返回：

`/run/systemd/generator.late/mysqld.service`

2. 重载并立即启动

```bash

sudo systemctl daemon-reload

sudo systemctl restart mysqld # 注意服务名是 mysqld 不是 mysql

sudo systemctl status mysqld # 确认 active (running)

```

3. 转成永久开机单元（可选但强烈建议）

```bash

sudo cp /run/systemd/generator.late/mysqld.service /etc/systemd/system/

sudo systemctl enable mysqld

```

结果

- 面板「重启 MySQL」按钮正常

- 服务器重启后 MySQL 自启且路径正确 ...

sudo chown -R www:www /www/server/phpmyadmin/tmp

sudo chmod -R 755 /www/server/phpmyadmin/tmp

提示不存在则去找的实际的目录比如

sudo chown -R www:www /www/server/phpmyadmin/phpmyadmin_ecccf751e/tmp

sudo chmod -R 755 /www/server/phpmyadmin/phpmyadmin_ecccf751e/tmp

宝塔创建数据库默认要用不同的，否则提示已经存在，phpmyadmin进去后老是提示红色的，你看下phpmyadimin上的问题 ...