centos 7.5安装maridb

https://blog.csdn.net/junehappylove/article/details/78690743
在目录下 /etc/yum.repos.d/ 创建文件： MariaDB.repo

启动服务

systemctl start mariadb

允许自动启动配置

systemctl enable mariadb

配置字符集

第一次配置

mysql_secure_installation

第一步要求修改root密码

初始化参数，基本上选择‘Y’就行了

重新启动服务

systemctl restart mariadb

配置外网访问

[root@unmeteoTest~]# mysql -u root -p

MariaDB [(none)]>use mysql

MariaDB [mysql]>GRANT ALL PRIVILEGES ON . to ‘root’@’%’ identified by ‘Unimet@db’;

MariaDB [mysql]>select user,password,host from user;

MariaDB [mysql]>\q

[root@unmeteoTest~]# service mariadb restart