linux安装-centOS6.5安装mysql5.7

2018-09-12

查看旧版本mysql

rpm -qa | grep -i mysql
输出
mysql-libs.x86_64 5.1.73-7.el6 @anaconda-CentOS-201605220104.x86_64/6.8

2.删除旧版本mysql

1	yum -y remove mysql-libs.x86_64

3.下载mysql

1	wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz

4.解压到/usr/local目录下因为support-files/mysql.server默认位置是/usr/local/mysql不好手动修改

1
2
3

mv mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz /usr/local/
tar -zxf mysql-5.7.17-linux-glibc2.5-x86_64.tar.gz
mv mysql-5.7.17-linux-glibc2.5-x86_64 mysql

5.创建存储数据的文件

1	mkdir /usr/local/mysql/data

6.创建mysql用户组

groupadd mysql
useradd mysql -g mysql
#分配/usr/local/mysql的目录文件权限
chown -R mysql:mysql mysql/
chmod -R 755 mysql/

7.初始化最后一行有密码

[root@bogon mysql]# ./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
2018-09-11T14:00:17.425754Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-09-11T14:00:17.814679Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-09-11T14:00:17.914437Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-09-11T14:00:17.998804Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 03b513fc-b5cb-11e8-b6c7-000c294fe2b8.
2018-09-11T14:00:18.003809Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-09-11T14:00:18.023285Z 1 [Note] A temporary password is generated for root@localhost: uqDvZ=kdz5gb

8.启动

1	./support-files/mysql.server start

9.挂软连接为了更方便使用mysql命令

1	ln -s /usr/local/mysql/bin/mysql /usr/bin

10.修改密码

1 2	mysql -uroot -pg%,jpMJbX1pZ alter user 'root'@'localhost' identified by 'userPassword';

11.添加可访问权限

1
2
3

use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;

12.添加启动服务

1 2	ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql chkconfig mysql on

13.如果使用客户端软件连接mysql服务出现2003错误码那就执行以下防火墙开启3306端口号

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT
然后保存：
/etc/rc.d/init.d/iptables save
重启防火墙
service iptables restart

14.配置文件是/usr/local/mysql/support-files/my-default.cnf