Centos7 下安装mariadb及其基本操作

直接用yum安装

# yum install mariadb-server -y

启动服务

#systemctl start mariadb

使用mysql_secure_installation命令进行配置

# mysql_secure_installation

首先是设置密码，会提示先输入密码

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 -p

password

 

配置MariaDB的字符集

修改文件/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

启动MariaDB服务。
systemctl start mariadb #启动服务
systemctl enable mariadb #设置开机启动
systemctl restart mariadb #重新启动
systemctl stop mariadb.service #停止MariaDB

进入MariaDB查看字符集

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

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

+----------------------+-----------------+
| Variable_name | Value |
+----------------------+-----------------+
| collation_connection | utf8_unicode_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
+----------------------+-----------------+
rows in set (0.00 sec)

 如果还有不是你设置的字符集的，用命令设置：

> set character_set_database=utf8;

创建用户:
create user testuser@localhost identified by 'test1234';
用户授权:
grant all on *.* to testuser@localhost identified by 'test1234';
外网登陆:
grant all privileges on *.* to testuser@'%' identified by 'test1234';
授予可以授权权限
grant all privileges on *.* to testuser@'%' identified by 'test1234' with grant option;