Linux安装mysql数据库

1. 下载安装包：
   https://downloads.mysql.com/archives/community/

2. tar xzvf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz

3. mv mysql-5.7.32-linux-glibc2.12-x86_64 /usr/local/mysql

4. mkdir /usr/local/mysql/data

5. 创建组：groupadd mysql

6. 创建用户：useradd -r -g mysql mysql

7. 更改mysql目录下所有的目录及文件夹所属的用户组和用户，以及权限：
   chown -R mysql:mysql /usr/local/mysql
   chmod -R 755 /usr/local/mysql

8. 编译安装并初始化mysql,记住日志末尾的数据库管理员临时密码
   cd /usr/local/mysql/bin
   ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

9. vim /etc/my.cnf

[mysqld]
datadir=/usr/local/mysql/data
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
symbolic-links=0
max_connections=600
innodb_file_per_table=1
lower_case_table_names=1
character_set_server=utf8

11. 启动mysql服务器：/usr/local/mysql/support-files/mysql.server start
12. 添加软连接（需重启服务）
    ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
    ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
    service mysql restart
13. 登陆mysql：mysql -u root -p
    注：密码为第9步生成的密码
14. 修改登陆密码：set password for root@localhost = password(‘123456’);
15. 开放远程连接：
    mysql>use mysql;
    msyql>update user set user.Host=’%’ where user.User=‘root’;
    mysql>flush privileges;
    firewall-cmd --zone=public --add-port=80/tcp --permanent
    firewall-cmd --reload
16. 设置开机启动权限：
    cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
    chmod +x /etc/init.d/mysqld
    chkconfig --add mysqld