mariaDB

yum -y install mariadb mariadb-server
systemctl start mariadb
systemctl enable mariadb

初始化设置

mysql_secure_installation

首先是设置密码

?

1 2 3 4 5 6 7 8 9 10

Enter current password for root (enter for none): #<–初次运行直接回车 #设置密码 Set root password? [Y/n]  #<– 是否设置root用户密码，输入y并回车或直接回车 New password:             #<– 设置root用户的密码 Re-enter new password:    #<– 再输入一次你设置的密码 #其他配置 Remove anonymous users? [Y/n]        #<– 是否删除匿名用户，回车 Disallow root login remotely? [Y/n]  #<–是否禁止root远程登录,回车, Remove test database and access to it? [Y/n]  #<– 是否删除test数据库，回车 Reload privilege tables now? [Y/n]            #<– 是否重新加载权限表，回车

初始化MariaDB完成，接下来测试登录

mysql -uroot -ppassword

安装完成

可能遇到的问题：

一：

1、问题描述

“Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.”

2、解决方法：

rm -f /var/lib/mysql/ib_logfile
systemctl restart mysqld.service

 配置MariaDB的字符集

1、文件/etc/my.cnf

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

2、文件/etc/my.cnf.d/client.cnf

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

在[client]中添加

default-character-set=utf8

3、文件/etc/my.cnf.d/mysql-clients.cnf

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

在[mysql]中添加

default-character-set=utf8

4、全部配置完成，重启mariadb

systemctl restart mariadb

之后进入MariaDB查看字符集

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33

[root@localhost ~]# mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 14 Server version: 5.5.56-MariaDB MariaDB Server   Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.   MariaDB [(none)]> show variables like "%character%";show variables like "%collation%"; +--------------------------+----------------------------+ | 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.01 sec)   +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | utf8_general_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec)

关闭防火墙

systemctl stop firewalld.service #停止firewall
systemctl disable firewalld.service #禁止firewall开机启动

设置远程登陆

grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;

测试
mysql -h 10.50.200.169 -u root -p

注意：

上面操作要成功，必须保证防火墙关闭或者添加端口3306例外；

前面环境中我直接把防火墙关了，但是目前大网络环境下，人们越来越重视安全问题，直接关防火墙是极为不推荐的！

[root@hadoop ~]# firewall-cmd --zone=public --add-port=8080/tcp --permanent
success
[root@hadoop ~]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
success
[root@hadoop ~]# firewall-cmd --reload
success

把端口3306添加到防火墙例外，然后必须reload一下；过一会可以从其他客户端连接一下，这样就OK了！

在提醒一下，生产环境不要暴露root用户，禁止使用root远程登陆，禁止关闭防火墙！！！