1、安装环境
系统版本 | 内存 | 处理器内核总数 | 硬盘 | MariaDB版本 |
---|---|---|---|---|
CentOS Linux release 7.2.1511 (Core) | 1G | 2 | 40G | 5.5.65 |
2、卸载MariaDB
yum remove mariadb-server -y
3、安装MariaDb
yum install mariadb-server -y
4、配置MariaDB
-
安装完成后首先要把MariaDB服务开启,并设置为开机启动
# 开启服务 systemctl start mariadb # 设置为开机自启动服务 systemctl enable mariadb
-
首次安装需要进行数据库的配置,命令都和mysql的一样
mysql_secure_installation #如果包关于sock(2)相关的错,先卸载mariadb,然后删除/etc/my.cnf和/etc/my.cnf.d以及报错相关mysql的路径
-
配置时出现的各个选项
Enter current password for root (enter for none): #第一次进入还没有设置密码则直接回车 Set root password? [Y/n] #设置密码,y New password: #新密码 Re-enter new password: #再次输入密码 Remove anonymous users? [Y/n] #移除匿名用户, y Disallow root login remotely? [Y/n] #拒绝root远程登录,n,不管y/n,都会拒绝root远程登录 Remove test database and access to it? [Y/n] #删除test数据库,y:删除。n:不删除 Reload privilege tables now? [Y/n] #y重新加载权限表
-
测试登录
mysql -u root -p #输入密码root
如下图所示,表示登录成功:
5、设置字符集为utf-8
- 注意:当没有对应的文件直接编辑创建即可
-
/etc/my.cnf 文件,在[mysqld] 标签下添加
vim /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 文件,在 [client] 标签下添加
vim /etc/my.cnf.d/client.cnf [client] default-character-set=utf8
-
/etc/my.cnf.d/mysql-clients.cnf 文件,在 [mysql] 标签下添加
vim /etc/my.cnf.d/mysql-clients.cnf [mysql] default-character-set=utf8
-
重启服务
systemctl restart mariadb
-
登录mariadb查看字符集
show variables like "%character%";show variables like "%collation%";
6、远程连接MariaDB数据库
-
关闭防火墙
①关闭防火墙 (暂时关闭,重启失效)
systemctl stop firewalld
②永久关闭
systemctl disable firewalld
③在不关闭防火墙的情况下,允许某端口的外来链接。步骤如下,开启3306端口,重启防火墙
# 查看3306端口是否开启 firewall-cmd --query-port=3306/tcp # 开启3306端口 firewall-cmd --zone=public --add-port=3306/tcp --permanent # 重启防火墙 firewall-cmd --reload # 查看3306端口是否开启 firewall-cmd --query-port=3306/tcp
如下图所示:
-
先查看mysql数据库中的user表
MariaDB [(none)]> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [mysql]> select host, user from user; +-----------+------+ | host | user | +-----------+------+ | 127.0.0.1 | root | | ::1 | root | | localhost | root | +-----------+------+ 3 rows in set (0.00 sec) MariaDB [mysql]>
-
将host为localhost数据改为%
MariaDB [mysql]> update user set host='%' where host='localhost'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 MariaDB [mysql]> select host, user from user; +-----------+------+ | host | user | +-----------+------+ | % | root | | 127.0.0.1 | root | | ::1 | root | +-----------+------+ 3 rows in set (0.00 sec) MariaDB [mysql]>
-
刷新权限表
flush privileges;
-
使用navicat 软件远程连接mariadb(选择MySQL也行)