fwx02的专栏

PostgreSQL：SELECT VERSION() AS VERSION MySQL：SELECT VERSION() AS VERSION DB2：SELECT SERVICE_LEVEL AS VERSION FROM TABLE (SYSPROC.ENV_GET_INST_INFO()) Oracle：SELECT BANNER AS VERSION FROM V$VERSION SQLite：SELECT SQLITE_VERSION() AS VERSION SQLServer：SE

1、停掉服务 2、导出数据库数据，删除数据库 3、新建新数据库字符集设置utf8mb4 -- UTF-8 Unicode 4、导入刚刚导出的数据 5、修改application-xxx.yml配置 spring: datasource: hikari: connection-init-sql: set names utf8mb4 ...

mysql_upgrade -uroot -p 注意加上 --force后才好使 mysql_upgrade -uroot -p --force

grant all privileges on shd_net to 'root@%' identified by 'sa' with grant option; 设置连接超时时间 show global variables like 'wait_timeout'; set global wait_timeout=86400; 设置最大连接数 show variables like...