CentOS7安装MariaDB和管理相关命令详解

MariaDB安装指南

安装MariaDB

通过yum仓库进行安装

yum -y install mariadb-server #安装mariadb服务端
systemctl start mariadb #启动mariadb
systemctl enable mariasb #设置mariadb为开机启动

其他相关命令

systemctl stop mariadb #关闭MariaDB
systemctl restart mariasb #重启mariadb
systemctl status mariadb #查看MariaDB运行状态
systemctl disable mariadb #禁止mariadb开机启动
netstat -antlupe|grep mysql #查看数据库接口信息

初始化服务

安装完成后需要进行初始化

mysql_secruer_installation #开始初始化命令
Enter current password for root(enter for none): #初次进入密码为空,直接回车
New password: #输入要为root用户设置的数据库密码
Re-enter new password: 再次输入密码
Remove anonymous users?[Y/n]: #是否删除匿名账户
Disallow root login remotely?[Y/n]: #是否禁止root用户从远程登录
Remove test database andaccess to it?[Y/n]: #是否删除test数据库
Reload privilege tables now[Y/n]: #是否现在刷新授权表

/etc/my.cnf配置文件

这是原始配置文件信息

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

在mysqld配置项下添加相关配置 (非必须)

init_connect='SET collation_connection = utf8_unicode_ci'  #设置字符集共5行
init_connect='SET NAMES utf8' 
character-set-server=utf8 
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake

#skip-grant #忘记密码时去掉该行注释可以免密登录
mysql> show variables like "%character%";show variables like "%collation%"; #查看mariadb字符集

登录MariaDB

mysql -u root -p #登录root账户
Enter password: #键入密码

MariaDB系统命令

MariaDB [(none)]> select user(); #查看当前登录用户
mysqladmin -u (用户名) -p password (新密码) #修改密码
Enter password: #键入旧密码