mariadb数据库

 1　　mariadb是mysql的一个分支，兼容mysql

 3　　systemctl start mariadb.service #启动MariaDB
 4　　systemctl stop mariadb.service #停止MariaDB
 5　　systemctl restart mariadb.service #重启MariaDB
 6　　systemctl enable mariadb.service #设置开机启动

　设置密码
 9　　SET password=PASSWORD('2084628520');

　　　
MariaDB [(none)]> show variables like 'char';　　//查找数据库的字符编码
Empty set (0.00 sec)

MariaDB [(none)]> show variables like '%char%';　　//查找数据库的字符编码，这里%char%是模糊查询的意思

+--------------------------+----------------------------+
| Variable_name | Value | 
+--------------------------+----------------------------+ 
| character_set_client | utf8 | 
| character_set_connection | utf8 | 
| character_set_database | latin1 | 
| character_set_filesystem | binary | 
| character_set_results | utf8 | 
| character_set_server | latin1 | 
| character_set_system | utf8 | 
| character_sets_dir | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+ 
8 rows in set (0.00 sec) 29 30

修改字符编码

vi /etc/my.cnf
1
在[mysqld]下添加

default-storage-engine = innodb
collation-server=utf8_general_ci
character-set-server = utf8
保存退出

 

编辑/etc/my.cnf.d/client.cnf文件

vi /etc/my.cnf.d/client.cnf

在[client]下添加：

default-character-set=utf8

保存并退出

编辑/etc/my.cnf.d/mysql-clients.cnf文件

vi /etc/my.cnf.d/mysql-clients.cnf

在[mysql]下添加

default-character-set =utf8
保存并退出

重启服务
systemctl restart mariadb