作者:wayne251312 | 来源:互联网 | 2023-07-20 22:58
安装前准备:确保你的CentOS6.10使用的镜像url是可被访问的!!(可参考文章:https:blog.csdn.netqq_39946015articledetails111
安装前准备:
确保你的CentOS6.10使用的镜像url是可被访问的!!(可参考文章:https://blog.csdn.net/qq_39946015/article/details/111086184)
如何不能被访问,则要把源站点配置改为国内清华大学站点https://mirrors.tuna.tsinghua.edu.cn/centos-vault
修改yum源站点配置:
vi /etc/yum.repos.d/CentOS-Base.repo
对照清华大学镜像站中的目录修改后如下:(键盘按"insert"键进入编辑,编辑完之后,键盘按"esc"退出编辑,然后输入":wq"保存退出。
[base]
name=CentOS-$releasever - Base
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os&infra=$infra
#baseurl=http://mirror.centos.org/centos/$releasever/os/$basearch/
baseurl=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/os/x86_64/
gpgcheck=1
#gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/os/x86_64/RPM-GPG-KEY-CentOS-6
#released updates
[updates]
name=CentOS-$releasever - Updates
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates&infra=$infra
#baseurl=http://mirror.centos.org/centos/$releasever/updates/$basearch/
baseurl=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/updates/x86_64/
gpgcheck=1
#gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/os/x86_64/RPM-GPG-KEY-CentOS-6
#additional packages that may be useful
[extras]
name=CentOS-$releasever - Extras
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras&infra=$infra
#baseurl=http://mirror.centos.org/centos/$releasever/extras/$basearch/
baseurl=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/extras/x86_64/
gpgcheck=1
#gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/os/x86_64/RPM-GPG-KEY-CentOS-6
#additional packages that extend functionality of existing packages
[centosplus]
name=CentOS-$releasever - Plus
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus&infra=$infra
#baseurl=http://mirror.centos.org/centos/$releasever/centosplus/$basearch/
baseurl=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/centosplus/x86_64/
gpgcheck=1
enabled=0
#gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/os/x86_64/RPM-GPG-KEY-CentOS-6
#contrib - packages by Centos Users
[contrib]
name=CentOS-$releasever - Contrib
#mirrorlist=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=contrib&infra=$infra
#baseurl=http://mirror.centos.org/centos/$releasever/contrib/$basearch/
baseurl=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/contrib/x86_64/
gpgcheck=1
enabled=0
#gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6
gpgkey=https://mirrors.tuna.tsinghua.edu.cn/centos-vault/6.8/os/x86_64/RPM-GPG-KEY-CentOS-6
验证 执行:yum install vim
yum install vim
1、检查是否安装有mysql (安装mysql可参考文章:https://www.cnblogs.com/hhz-97/p/12657505.html)
rpm -qa | grep mysql
如果有的话使用 yum remove 【包名】将其删除干净:
yum remove
2、下载yum Repository
wget -c http://dev.mysql.com/get/mysql57-community-release-el6-10.noarch.rpm
3、本地安装下载下来的rpm包
yum localinstall mysql57-community-release-el6-10.noarch.rpm
查看可用安装包:
yum repolist enabled | grep mysql
4、安装前安装gcc所有包,防止报错
yum install gcc*
5、安装mysql
yum install -y mysql-community-server
6、启动mysql
service mysqld start
查看状态:
service mysqld status
加入开机启动:
chkconfig mysqld on
7、配置数据库
在 /etc/my.cnf 配置文件,写入以下配置:
vim /etc/my.cnf
按键盘“insert”键,进入编辑
# 修改字符编码为utf8
character_set_server = utf8
init_cOnnect= 'SET NAMES utf8'
# 数据库是否区分大小写,0:区分大小写,1:不区分大小写
lower_case_table_names=1
编辑完后,按键盘“esc”键,并输入:wq,保存退出
重启数据库,让配置文件生效:
service mysqld restart
8、查看初始密码
grep 'temporary password' /var/log/mysqld.log
修改root账号初始密码为“123456”:
alter user 'root'@'localhost' identified by '123456';
注意:MySQL5.7默认对用户密码有密码强度要求,必须包含数字、小写字母、大写字母 、特殊字符,长度至少8位
所以可以使用语句set global validate_password_policy=LOW;设置密码安全级别最低,这样就可以用数字作为密码了。可以参考:https://www.jianshu.com/p/5779aa264840
set global validate_password_policy=LOW;
刷新权限:flush privileges;
flush privileges;
9、退出可以使用新密码登录