mariadb的安装及配置

 

一、安装

yum install MariaDB-server

二、查看安装路径

rpm -qa | grep MariaDB
rpm -ql MariaDB-server-10.2.14-1.el7.centos.x86_64

三、启动

systemctl start mariadb

四、查看数据库版本与运行状态

mysqladmin version status
systemctl status mariadb

五、停止

systemctl stop mariadb

 六、初始化

mysql_secure_installation

七、查看当前用户

mysql -u root -p -e 'select user,host from mysql.user';

八、创建用户并Grant权限

mysql -u root -p -e "create user 'uc'@'%' identified by 'password'"
mysql -uroot -p -e"grant all on *.* to 'uc'@'%'"
mysqladmin -uroot -p flush-privileges