mariadb安装与使用

CentOS下安装

yum -y install mariadb mariadb-server

开启

systemctl start mariadb.service

关闭

systemctl stop mariadb.service
mysqladmin -uroot -p shutdown

重新启动

systemctl restart mariadb

设置服务自启动

systemctl enable mariadb.service

连接

mysql -uroot -p

修改字符集

• vi /etc/my.cnf
  在[mysqld]标签下添加
  init_connect='SET collation_connection = utf8_unicode_ci'
  init_connect='SET NAMES utf8'
  character-set-server=utf8
  collation-server=utf8_unicode_ci
  skip-character-set-client-handshake
  文件/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

查看字符集

show variables like "%character%";show variables like "%collation%";

允许root用户在任何机器上登陆:

GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES