大佬教程收集整理的这篇文章主要介绍了Mariadb的安装及相关配置,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
配置向导: https://downloads.mariadb.org/mariadb/repositorIEs
可以选择合适的操作系统和想要安装的Mariadb版本,然后自动生成源配置。
# tee /etc/yum.repos.d/Mariadb.repo << EOF
copy入以下源配置,
# MariaDB 10.3 CentOS repository List - created 2018-08-29 02:43 UTC # http://downloads.mariadb.org/mariadb/repositorIEs/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
SHOW VARIABLES liKE 'character_set_%'; SHOW VARIABLES liKE 'collation_%';
查看某个数据库的字符集
show create database DBbase; show create table DBtable;
在[MysqL]中添加
default-character-set=utf8mb4
在[MysqLd]中添加
init_connect='SET collation_connection = utf8mb4_unicode_ci' init_connect='SET nameS utf8mb4' character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci skip-character-set-clIEnt-handshake
systemctl restart mariadb
show variables like "%character%";
and
show variables like "%collation%";@H_202_10@mariaDB [(nonE)]> show variables like "%character%"; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_clIEnt | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | character_set_system | utf8mb4 | | character_sets_dir | /usr/share/MysqL/charsets/ | +--------------------------+----------------------------+ 8 rows in set (0.001 seC) MariaDB [(nonE)]> show variables like "%collation%"; +----------------------+-----------------+ | Variable_name | Value | +----------------------+-----------------+ | collation_connection | utf8mb4_unicode_ci | | collation_database | utf8mb4_unicode_ci | | collation_server | utf8mb4_unicode_ci | +----------------------+-----------------+ 3 rows in set (0.001 seC)
重写MysqL5InnoDBDialect#gettableTypeString()
public class MysqL5InnoDBDialectUtf8mb4 extends MysqL5InnoDBDialect { @OverrIDe public String gettableTypeString() { return "ENGINE=InnoDB DEFAulT CHARSET=utf8mb4 ColLATE utf8mb4_unicode_ci"; } }
配置hibernate.dialect
spring: jpa: propertIEs: hibernate: dialect: com.xxx.MysqL5InnoDBDialectUtf8mb4
数据库配置:
@Configuration public class DruIDConfig { @Value("${spring.datasource.druID.connection-init-sqls") private List connectionInitsqls; @Bean public DruIDDatasource datasource() { DruIDDatasource datasource = new DruIDDatasource(); datasource.setConnectionInitsqls(connectionInitsqls); return datasource; } }
application.yml
spring: datasource: druID: connection-init-sqls: ["SET nameS utf8mb4 ColLATE utf8mb4_unicode_ci"]
最后按上述设置Spring Data Jpa 生成的表、字段就会是utf8mb4,utf8mb4_unicode_ci
还是需要设置characterEnCoding=utf8mb4,不然会出现中文乱码
以上是大佬教程为你收集整理的Mariadb的安装及相关配置全部内容,希望文章能够帮你解决Mariadb的安装及相关配置所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。