aliyunesc 安装mysql

更新缓存

yum clean cache
yum makecache

查看系统中是否已安装mysql

yum list installed | grep mysql

卸载系统自带的mysql及其依赖（防止冲突）

yum -y remove mysql-libs.x86_64

下载wget命令

yum install wget -y

给centos添加rpm源，并且选择比较新的源

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm

安装上一步下载的rpm

yum install mysql-community-release-el6-5.noarch.rpm -y

安装成功后，会在/etc/yum.repo.d/下面新增两个文件

• mysql-community.repo
• mysql-community-source.repo

修改mysql-community.repo文件

vi mysql-community.repo

使用yum安装mysql

yum install mysql-community-server -y
配置文件在 /etc/my.cnf

查看版本

mysql -V

启动mysql服务

service mysqld start

查看是否启动

service mysqld status

查看mysql是否开机启动

systemctl list-unit-files | grep mysql*
mysqld.service enabled
mysqld@.service disabled

设置mysql开机启动

systemctl enable mysqld.service

查看临时密码

grep 'password' /var/log/mysqld.log

登录msyql

mysql -u root -p
PASSWORD: 临时密码

设置密码策略，修改密码, 设置外网ip访问，刷新配置

set global validate_password_policy=0;
set global validate_password_length=4;
alter user ‘root’@‘localhost’ identified by ‘123456’;
grant all privileges on . to ‘root’@‘%’ identified by ‘123456’ with grant option;
flush privileges;