1、下载MYSQL从官网下载MySQL安装包,下载地址:https://www.mysql.com/downloads/2、检查机器是否安装了mysql检查是否安装了MySQL组件rpm-qa|grep-imysql示例:rpm-evMySQL-client-5.6.34-1.rhel5.x86_64;查找并删除mysql对应的文件夹信息find/-namemysql例子:rm-rf/var/lib/mysql3、开始安装mysql5.7使用df-h查看磁盘上合适的安装目录。这里我选择/home解压mysql安装包tar-zxvfmysql-5.7.17-linux-glibc2.5-x86_64.tar.gz并将解压后的目录重命名为mysqlmvmysql-5.7.17-linux-glibc2.5-x86_64mysql添加系统用户和用户组groupaddmysqluseradd-r-gmysqlmysql创建数据目录datacdmysqlmkdirdata修改MySQL目录权限chown-Rmysql:mysql/home/mysqlinstallation命令yum-yinstalllibaio-devel./bin/mysqld--initialize--user=mysql--basedir=/home/mysql--datadir=/home/mysql/datacp-a./support-files/my-default.cnf/etc/my.cnfcp-a./support-files/mysql.server/etc/init.d/mysqld修改配置文件#修改配置目录vi/etc/my.cnf注意我是设置slave所以server--id=2配置环境#修改环境变量配置文件vi/etc/profile#添加mysql全局变量,使servicemysqldstart可以在任何地方使用#centos7usesystemctlstart/stop/statud/restartmysqlexportPATH=$PATH:/usr/local/mysql/bin#立即生效source/etc/profile#启动mysqlservicemysqld启动遇到问题。这是因为mysqld_safe默认会从/usr/local/mysql/bin目录下搜索启动脚本mysqld。解决方法#创建软链接ln-s/home/mysql/bin/mysqld/usr/local/mysql/bin/mysqld启动成功#mysql进入mysql命令行mysql-uroot-p安装时会生成默认密码注意save#切换到mysql库,查询Mysql用户usemysql;遇到问题的解决办法alteruser'root'@'localhost'identifiedby'123456';#Queryusertableselect*fromuser;#修改root密码#Addremotepermissionsforrootgrantallprivilegeson*.*to'root'@'%'identifiedby'root'withgrantoption;#Refreshprivilegesflushprivileges;addbootchkconfig--addmysqld我这里是测试机,直接关闭防火墙,如果有防火墙记得配置3306端口规则!
