Mariadb10.5安装使用
1、安装
cat >/etc/yum.repos.d/mariadb.repo<<EOF
[mariadb]
name = MariaDB
baseurl = https://mirrors.aliyun.com/mariadb/yum/10.5/centos7-amd64/
gpgkey = https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck =1
enabled = 1
EOF
yum install -y mariadb-server mariadb
systemctl enable --now mariadb
2、配置密码
1、设置服务器登录mariadb权限(二选 一)
系统内设置
mysqladmin -uroot password
#输入两次密码
MySQL内设置
set password=password('www.123.nyc');
实测设置了密码也是可以使用mysql命令不加密码直接登录的
解决方法:
通过上述方法设置好密码后再使用(MySQL内执行)
参考学习:https://blog.csdn.net/weixin_42688589/article/details/123224712
alter user 'root'@'localhost' identified by 'www.123.nyc'
2、创建库及访问权限
create database crawl;
grant all on crawl.* to 'oldboy'@'192.168.1.%' identified by 'www.123.nyc';