简单安装配置mariadb

前言

记录mariadb的安装配置方法

安装

[root@lab101 bacula]# yum install mariadb-server
[root@lab101 bacula]# systemctl start mariadb
[root@lab101 bacula]# systemctl enable mariadb
Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/lib/systemd/system/mariadb.service.

##配置

设置密码

[root@lab101 bacula]# mysql_secure_installation

测试登陆

[root@lab101 bacula]# mysql -u root -p

配置访问权限

允许所有机器以root用户名密码123456访问

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;