mysql5.7linux安装完整版100%成功

以下安装教程为傻瓜式安装

解压文件：tar -xvf mysql-5.7.37-linux-glibc2.12-x86_64.tar.gz
复制文件：mv mysql-5.7.37-linux-glibc2.12-x86_64/ /usr/local/mysql
1
2

以下操作直接复制粘贴即可完成linux安装mysql5.7，修改用户名和密码为root和root，外加上外部连接访问

[root@Fan mysq]# cd /usr/local/
[root@Fan local]# ls
[root@Fan local]# groupadd mysql
[root@Fan local]# useradd -r -g mysql mysql
[root@Fan local]# mkdir -p /data/mysql
[root@Fan local]# chown mysql:mysql -R /data/mysql
[root@Fan data]# vim /etc/my.cnf

编辑文件内容为：直接复制粘贴
[mysqld]
#bind-address=0.0.0.0
port=3306
user=mysql
basedir=/usr/local/mysql  #这里特别注意我之前把mysql-5.7.37写成了mysql导致后面无法启动
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

[root@Fan mysql]# cd /usr/local/mysql/bin/
[root@Fan bin]# ls
[root@Fan mysql]# cd  /usr/local/mysql
[root@Fan mysql]# ls
[root@Fan mysql]# mkdir logs
[root@Fan mysql]# ls
[root@Fan mysql]# echo "" > /usr/local/mysql/logs/mysqld.log
[root@Fan mysql]# ls
[root@Fan mysql]# chown -R mysql:mysql /usr/local/mysql/logs/mysqld.log
[root@Fan mysql]# mkdir -p /data/mysql
[root@Fan mysql]# chown mysql:mysql -R /data/mysql
[root@Fan mysql]# cd /usr/local/mysql/
[root@Fan mysql]# ls
[root@Fan mysql]# cd /usr/local/mysql/bin/
-- [root@localhost bin]# chmod +x mysqld
[root@Fan bin]# ./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql/ --datadir=/data/mysql/ --user=mysql --initialize
[root@Fan bin]# cat /data/mysql/mysql.err
[root@Fan bin]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@Fan bin]# service mysql start
[root@Fan bin]# ps -ef|grep mysql
[root@Fan bin]# ls
[root@Fan bin]# ./mysql -u root -p
mysql> ALTER user 'root'@'localhost' IDENTIFIED BY 'root';
mysql> use mysql
mysql> update user set host = '%' where user = 'root';
    -> \q
[root@Fan bin]# hostname -i
[root@Fan bin]# service iptables stop
[root@Fan bin]# service iptables status
[root@Fan bin]# netstat -an|grep 3306
[root@Fan bin]# firewall-cmd --zone=public --add-port=3306/tcp --permanent
[root@Fan bin]# /etc/init.d/mysql restart
[root@Fan bin]# firewall-cmd --reload
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56