powertools 里面有rpcgen：
dnf install --enablerepo=powertools rpcgen[root@212d1d5f5e2b mysql-5.7.44]# rm CMakeCache.txt && cmake . -DBUILD_CONFIG=mysql_release -DWITH_BOOST=/root/boost_1_59_0 -DCMAKE_INSTALL_PREFIX=/usr/local分类目录归档：MySQL
[Warning] Could not increase number of max_open_files to more than 1024 (request: 10811)
解决方法：
修改服务
vim /usr/lib/systemd/system/mariadb.service
#在[service]下面加
[Service]
LimitNOFILE=infinityAccess denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation
root@% 无法修改 root@localhost 密码
解决办法：（自己给自己授权）
grant system_user on *.* to 'root';https://blog.csdn.net/weixin_42330311/article/details/104728396
DbMySQLQuery.resultFieldStringValueByName(): MySQL_ResultSet::isNull: invalid value of ‘columnLabel’
The proposed solution “[3 Feb 16:10] Adam Latchem” worked for me, in the context of MySQL Workbench connecting to a MariaDB database. The fix (for definiteness) is to edit the file C:\Program Files\MySQL\MySQL Workbench 8.0 CE\modules\wb_admin_connections.py at line 346, to change it from
("DB", mforms.StringColumnType, "DB", 100),
to
("db", mforms.StringColumnType, "DB", 100),
(note change of case in first argument).
此操作解决MySQL Workbench Client Connections 空白问题…
performance_schema = off
MySQL 8 关闭 performance_schema = off，可以瞬间节省200~300M左右内存
查询MySQL全局和会话时区（time_zone）当前值
SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;