阿里云 mariadb安装配置，阿里mariadb

阿里云 mariadb安装配置，阿里mariadb

yum -y install mariadb*


systemctl start mariadb.service
[root@localhost ~]# systemctl start mariadb.service
[root@localhost ~]# systemctl enable mariadb.service
ln -s '/usr/lib/systemd/system/mariadb.service' '/etc/systemd/system/multi-user.target.wants/mariadb.service'
[root@localhost ~]# mysql
修改数据库默认字符集vi client.cnf[client]default-character-set = utf8
vi server.cnf[mysqld]character_set_server=utf8




修改密码
 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY '123qwe123' WITH GRANT OPTION;


安全设置
 mysql_secure_installation

jdbc驱动替换成    <dependency>      <groupId>org.mariadb.jdbc</groupId>      <artifactId>mariadb-java-client</artifactId>      <version>1.3.4</version>    </dependency>

yum -y remove mariadb*