以下安装教程为傻瓜式安装
下载地址:https://mirrors.aliyun.com/mysql/MySQL-5.7/ |
解压文件: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
以下操作直接复制粘贴即可完成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