安装mariadb
1.安装mariadb的时候发现centos7中yum源本地比较低,就顺便升级了一下
- 在/etc/yum.repos.d/ 目录下创建 mariadb.repo 文件
- 加入如下配置(添加你想下载的版本信息)
[mariadb]
name = MariaDB
baseurl = https://mirrors.aliyun.com/mariadb/yum/10.4/centos7-amd64/
gpgkey=https://mirrors.aliyun.com/mariadb/yum/RPM-GPG-KEY-MariaDB
gpgcheck=1
- 更新下yum
yum -y update
- 查看 MariaDB 信息
yum list | grep mariadb
安装
- 执行命令
yum install MariaDB-server.x86_64
2.修改字符集
sudo vim /etc/my.conf
添加:default-character-set=utf8
3。设置随机启动
sudo chkconfig mysqld on
查看是否设置成功
4.启动mysql
sudo server msyql start
5.登录mysql
mysql -u root
6.查看mysql用户
select user , host from mysql.user;
7.删除匿名用户
select user , host from mysql.user;
8.防火墙设置
sudo vim /etc/sysconfig/iptables
添加:
9.重启防火墙
sudo service iptables restart
10.查看用户权限
select * from mysql.user /G
11.权限设置
grant select ,delete, create on mall.* to mall@’%’ identified by ‘mall’ with grant option;
12.设root密码
set password from root@localhost='123';
set password for root@127.0.01=password('123');