Linux安装Mysql5,7完整教程

Linux安装Mysql5.7完整教程

1. 下载Mysql5.7压缩包，点击下载

2. 解压tar -xvf mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz

3. 移动到/usr/local/mysql下 mv mysql-5.7.28-linux-glibc2.12-x86_64 /usr/local/mysql

4. 新建data目录用来存储mysql数据mkdir /usr/local/mysql/data

5. 新建mysql用户组、mysql用户并将/usr/local/mysql的所有者及所属组改为mysql

   groupadd mysql
   useradd mysql -g mysql
   chown -R mysql.mysql /usr/local/mysql
   

6. 修改默认配置文件vim /etc/my.cnf

   [mysqld]
   datadir=/usr/local/mysql/data
   basedir=/usr/local/mysql
   socket=/tmp/mysql.sock
   user=mysql
   port=3306
   character-set-server=utf8mb4
   # 禁用符号链接
   symbolic-links=0
   # 取消密码验证
   #skip-grant-tables
   [mysqld_safe]
   log-error=/var/log/mysqld.log
   pid-file=/var/run/mysqld/mysqld.pid
   

7. 初始化默认配置

   /usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data --initialize
   

   注意：

   1. 如果是重新初始化，需要清空/usr/local/mysql/data/下的文件。
   2. 执行成功后备份日志最后的打印的初始化登录密码如：A temporary password is generated for root@localhost: lsqko?;lp0hI
   3. 如果执行报如下错误：error while loading shared libraries: libnuma.so.1: cannot open shared object file: No such file or directory，则先执行yum -y install numactl.x86_64,然后继续执行上面的语句

8. 将mysql加入系统服务

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

9. 设置开机自启

   chkconfig mysql on
   

10. 开启数据库服务

    service mysql start
    

11. 修改密码

    /usr/local/mysql/bin/mysql -u root -p
    mysql> SET PASSWORD = PASSWORD('你的密码');
    mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
    mysql> flush privileges;
    mysql> exit;
    

12. 允许远程连接

    /usr/local/mysql/bin/mysql -u root -p
    mysql> use mysql;
    mysql> update user set host='%' where user = 'root';
    mysql> flush privileges;
    mysql> exit;
    

好了，到此安装完成！