1. 创建/etc/yum.repos.d/MariaDB.repo文件
添加如下:
[mariadb] name = MariaDB baseurl = https://mirrors.ustc.edu.cn/mariadb/yum/10.2/centos7-amd64 gpgkey=https://mirrors.ustc.edu.cn/mariadb/yum/RPM-GPG-KEY-MariaDB gpgcheck=1
2. 使用yum来安装
yum install MariaDB-server MariaDB-client
3. 启动服务
service mysql start
4. 设置ROOT密码
mysqladmin -u root password 123456
5. 登陆mysql
mysql -uroot -p123456
6. 授权root远程登录
root可从任何IP登陆,注意修改密码:'123456'
添加用户:
CREATE USER 'username'@'host' IDENTIFIED BY 'password';
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;