linux在线安装mysql-5.7.26——记录部署篇3

1. 在线下载mysql5.7压缩包

[root@localhost /]# wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

2. 解压mysql5.7压缩包

[root@localhost /]# tar -xvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

3. 移动mysql5.7压缩包

[root@localhost /]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/

4. 改名

[root@localhost /]# cd /usr/local/
[root@localhost local]# mv mysql-5.7.26-linux-glibc2.12-x86_64/ mysql-5.7.26

5. 创建mysql组和用户

[root@localhost local]# groupadd mysql
[root@localhost local]# useradd -r -g mysql mysql

6. 创建mysql data目录赋予权限

[root@localhost local]# mkdir -p  /data/mysql              #创建目录
[root@localhost local]# chown mysql:mysql -R /data/mysql   #赋予权限

7. 配置mysql配置文件(根据自己需求更改)

[root@localhost /]# vim /etc/my.cnf

[mysqld]
bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql-5.7.26
datadir=/data/mysql
socket=/tmp/mysql.sock
log-error=/data/mysql/mysql.err
pid-file=/data/mysql/mysql.pid
#character config
character_set_server=utf8mb4
symbolic-links=0
explicit_defaults_for_timestamp=true
lower_case_table_names = 1
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

8. 初始化

[root@localhost local]# cd /usr/local/mysql-5.7.26/bin/
[root@localhost bin]# ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-5.7.26/ --datadir=/data/mysql/ --user=mysql --initialize

9. 查看初始密码（root: 后的一串字符是密码）

[root@localhost bin]# cat /data/mysql/mysql.err

10. 将mysql.server放置到/etc/init.d/mysql中

[root@localhost bin]# cp /usr/local/mysql-5.7.26/support-files/mysql.server /etc/init.d/mysql

11. 启动mysql

[root@localhost bin]# service mysql start

12. 修改密码

[root@localhost bin]# ./mysql -u root -p   #bin目录下

mysql> SET PASSWORD = PASSWORD('123456');
mysql> ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
mysql> FLUSH PRIVILEGES;

13. 退出后重登mysql,执行如下（解决navicat连接不上mysql）

mysql> exit

[root@localhost bin]# ./mysql -u root -p   #bin目录下

mysql> use mysql         									#访问mysql库
mysql> update user set host = '%' where user = 'root';      #使root能再任何host访问
mysql> FLUSH PRIVILEGES;

14. 设置软连接

mysql> exit

[root@localhost bin]# ln -s  /usr/local/mysql-5.7.26/bin/mysql    /usr/bin

配置完后可在任意目录执行登录：mysql -u root -p 

15. 注意事项

记得开放3306端口哦