MySQL57在CentOS7上的安装

1、时间：2015-11-07 作者：dusuanyun系统版本：CentOS-7-x86_64-DVD-1503-01.iso 安装后不要升级！(我试过升级后安装MySQL不能启动）网络环境：虚拟机桥接，可以连接外网：安装方式：手动网络安装-仓库的方式需要的文件：如下图。PDF文件为官方指导文件。1.将文件置于CentOS的Root家目录：rootMySQL # ll总用量 16-rw-. 1 root root 1665 11月 7 10:49 anaconda-ks.cfg2.开始安装：按照提示一步步安装即可rootMySQL # rpm -ivh mysql57-community-rel

2、ease-el7-7.noarch.rpm rootMySQL # yum install mysql-community-server3.查看支持当前系统的可以安装MySQL的其他组件：rootMySQL # yum -disablerepo=* -enablerepo=mysql*-community* list available4.查看安装后的MySQL的服务是否已经启动：rootMySQL # service mysqld statusRedirecting to /bin/systemctl status mysqld.servicemysqld.service - MySQL S

3、erver Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled) Active: inactive (dead)5.没有启动，则启动MySQL服务：rootMySQL # service mysqld startRedirecting to /bin/systemctl start mysqld.service检查是否正常启动，rootMySQL # service mysqld statusRedirecting to /bin/systemctl status mysqld.servicemysqld.servic

4、e - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled) Active: active (running) since 六 2015-11-07 11:24:02 CST; 14s ago Process: 3157 ExecStart=/usr/sbin/mysqld -daemonize $MYSQLD_OPTS (code=exited, status=0/SUCCESS)6. 查看安装MySQL后自动产生的随机Root密码：此Root密码是数据库的不是CentOS系统的rootMy

5、SQL # grep temporary password /var/log/mysqld.log2015-11-07T03:23:44.719982Z 1 Note A temporary password is generated for rootlocalhost: JfHhiPk,n2Pw7. 用随机密码登录MySQL并修改Root密码：rootMySQL # mysql -u root -pJfHhiPk,n2Pwmysql use mysqlERROR 1820 (HY000): You must reset your password using ALTER USER state

6、ment before executing this statement.密码必须满足复杂性的策略mysql SET PASSWORD FOR rootlocalhost= pw57mysql;ERROR 1819 (HY000): Your password does not satisfy the current policy requirementsmysql SET PASSWORD FOR rootlocalhost= PW57-mysql;Query OK, 0 rows affected (0.00 sec)mysql exitBye8.用新的密码登录，修改MySQL表支持非本机

7、连接：rootMySQL # mysql -u root -pPW57-mysqlmysql use mysqlReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql select host, user from user; -修改前+-+-+| host | user |+-+-+| localhost | mysql.sys | localhost

8、| root |+-+-+2 rows in set (0.00 sec)mysql update user set host = % where user = root; -修改Query OK, 1 row affected (0.00 sec)Rows matched: 1 Changed: 1 Warnings: 0mysql select host, user from user; -修改后+-+-+| host | user |+-+-+| % | root | localhost | mysql.sys |+-+-+2 rows in set (0.00 sec)mysql fl

9、ush privileges; -刷新，让修改立即生效！Query OK, 0 rows affected (0.00 sec)mysql Bye9.检查CentOS的防火墙设置：因为发现其他机器可以ping通，连数据库却不通。rootMySQL # service iptables statusRedirecting to /bin/systemctl status iptables.serviceiptables.service Loaded: not-found (Reason: No such file or directory) -CentOS7好像不用iptables这玩意了 Ac

10、tive: inactive (dead)rootMySQL # service firewalld statusRedirecting to /bin/systemctl status firewalld.servicefirewalld.service - firewalld - dynamic firewall daemon Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled) Active: active (running) since 六 2015-11-07 11:11:43 CST; 38min a

11、go -看到是运行状态 Main PID: 624 (firewalld) CGroup: /system.slice/firewalld.service 624 /usr/bin/python -Es /usr/sbin/firewalld -nofork -nopid11月 07 11:11:43 MySQL systemd1: Started firewalld - dynamic firewall daemon.rootMySQL # service firewalld stopRedirecting to /bin/systemctl stop firewalld.servicero

12、otMySQL # service firewalld statusRedirecting to /bin/systemctl status firewalld.servicefirewalld.service - firewalld - dynamic firewall daemon Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled) Active: inactive (dead) since 六 2015-11-07 11:53:03 CST; 3s ago Main PID: 624 (code=exit

13、ed, status=0/SUCCESS)11月 07 11:11:43 MySQL systemd1: Started firewalld - dynamic firewall daemon.11月 07 11:53:02 MySQL systemd1: Stopping firewalld - dynamic firewall daemon.11月 07 11:53:03 MySQL systemd1: Stopped firewalld - dynamic firewall daemon.rootMySQL # chkconfig -list |grep mysql注意：该输出结果只显示

14、 SysV 服务，并不包含原生 systemd 服务。SysV 配置数据可能被原生 systemd 配置覆盖。 如果您想列出 systemd 服务,请执行 systemctl list-unit-files。 欲查看对特定 target 启用的服务请执行 systemctl list-dependencies target。10.查看MySQL服务是否启用（开机自动启动）：rootMySQL # systemctl list-unit-files |grep mysqlmysqld.service enabled rootMySQL # 11. 防火墙：永久关闭：我是测试环境，为了偷懒懒得再去设置它，直接关闭。否则重启后外面又不能连接了。当然正是环境开始要开的，并且配置外部可以连进来。ro