linux安装mysql5.7

1. 下载mysql安装包：https://dev.mysql.com/downloads/mysql/5.6.html
2. 下载后上传到linux服务器，解压到/usr/local/mysql

   cp mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz /usr/local
   cd /usr/local
   tar -xf mysql-5.7.27-linux-glibc2.12-x86_64.tar.gz
   mv mysql-5.7.27-linux-glibc2.12-x86_64 mysql
   

3. 创建一个目录：/usr/local/mysql/data

   mkdir /usr/local/mysql/data
   

4. 新建mysql用户、mysql用户组：

   groupadd mysql
   useradd -r -g mysql mysql
   

5. 将/usr/local/mysql的所有者及所属组改为mysql：

   chown -R mysql:mysql mysql/
   chmod -R 755 mysql/
   

6. 编译安装初始化mysql，记住密码：

   /usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql
   

7. 启动mysql

   /usr/local/mysql/support-files/mysql.server start
   

8. 添加软链接，新建/etc/init.d/mysql 指向 /usr/local/mysql/support-files/mysql.server

   ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
   

9. 添加软链接

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

10. 登录mysql，输入第6步生成的密码

    mysql -u root -p
    

11. 修改密码为123456，并开放远程

    msql>alter user 'root'@'localhost' identified by '123456';
    mysql>use mysql;
    msyql>update user set user.Host='%' where user.User='root';
    mysql>flush privileges;
    mysql>quit
    

12. 编辑my.cnf，添加配置文件

    [mysqld]
    port = 3306
    sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
    

13. mysql启动和停止

    启动mysql：service mysql start
    重启mysql: service mysql restart
    停止mysql: stop