https://blog.csdn.net/haixwang/article/details/80285986
MySQL中的配置看官网
Configure MySQL or MariaDB Server
- Configure my.cnf (only as necessary).
- Ensure bind-address=0.0.0.0 (or is commented out if the default).
- Ensure default-storage-engine=innodb (which is the default in 5.5 and higher: mysql -V).
- Ensure sql_mode=STRICT_ALL_TABLES to avoid columns being truncated during migration.
[mysqld] ... bind-address=0.0.0.0 default-storage-engine=innodb sql_mode=STRICT_ALL_TABLES
- CentOS/RHEL/SLES: /etc/my.cnf
-
Ubuntu/Debian: /etc/mysql/my.cnf
- Restart the database server.
Note: See the Start Commands table above and replace with "restart".
- Enable the server to automatically start on boot: