install mariadb on Centos 7
1. 安装
1.1. 检查是否已安装 mariadb
yum list installed | grep mariadb
1.2. 安装MariaDB
如果未安装,执行以下命令安装命令
yum -y install mariadb mariadb-server
1.3. 安装完成MariaDB,首先启动MariaDB
systemctl start mariadb
1.4. 设置开机启动
systemctl enable mariadb
2. 配置
2.1. 修改配置授权远程访问
vi /etc/my.cnf
bind-address = <some ip-address>
2.2. 创建远程访问用户,并授予访问权限
mysqlCREATE USER 'user1'@'internet_ip' IDENTIFIED BY 'the_password';
GRANT ALL ON *.* TO 'user1'@'internet_ip';
--or reset password if user exists
SET PASSWORD FOR 'user1'@'localhost' = PASSWORD('the_password');
2.3. 设置中文字符集
vi /etc/my.cnf
在[mysqld]标签下添加
#character
init_connect='SET collation_connection = utf8mb4_unicode_ci'
init_connect='SET NAMES utf8mb4'
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
skip-character-set-client-handshake
vi /etc/my.cnf.d/client.cnf
在[client]下添加
#character
default-character-set=utf8mb4
vi /etc/my.cnf.d/mysql-clients.cnf
在[mysql]中添加
#character
default-character-set=utf8mb4
2.4. 重启mariadb服务,使配置生效
systemctl restart mariadb
2.5. 查看版本
MariaDB [(none)]> \s
--------------
mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 5.5.68-MariaDB MariaDB Server
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb4
Conn. characterset: utf8mb4
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 1 day 20 hours 48 min 13 sec
2.6. 查看字符集是否生效
mysql> show variables like 'character%';
MariaDB [(none)]> show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
log for trouble shooting
/var/log/mariadb/mariadb.log
2.7. 设置数据库对大小写不敏感
进入 /etc/my.cnf.d ,编辑server.cnf
vi /etc/my.cnf.d/server.cnf
在[mysqld]下添加
lower_case_table_names = 1
3. 参考文档
转载请注明出处, 更多博文请访问https://www.cnblogs.com/guoapeng/
posted on 2019-11-27 16:13 eagle.supper 阅读(288) 评论(0) 编辑 收藏 举报