目录
查看安装系统环境
[root@localhost ~]# uname -a
[root@localhost ~]# cat /proc/version
官网获取MySQL压缩包
https://downloads.mysql.com/archives/community/
官网若不想去,可我的百度网盘自行提取MySQL版本5.7.32
链接:https://pan.baidu.com/s/1Y6RH2uBUbytKIbDZv-7cXA?pwd=pduf
提取码:pduf
若环境有MySQL,则先卸载
查看是否存在MySQL服务并根据查询到的进程号杀死进程
[root@localhost ~]# ps -ef|grep mysql
[root@localhost ~]# kill -9 4857 #如下图根据实际情况填写
[root@localhost ~]# kill -9 5124
查看和MySQL数据相关文件并删除
[root@localhost ~]# find / -name mysql
[root@localhost ~]# rm -rf /run/lock/subsys/mysql
[root@localhost ~]# rm -rf /etc/rc.d/init.d/mysql
[root@localhost ~]# rm -rf /data
删除MySQL用户及用户组
[root@localhost ~]# id mysql
[root@localhost ~]# userdel mysql
安装MySQL
将下载的安装包上传到服务器上
确认一下磁盘分布空间,确认安装位置
[root@localhost ~]# df -h
解压上传的安装包
[root@localhost ~]# tar -zxvf mysql-5.7.32-linux-glibc2.12-x86_64.tar.gz
将解压文件移动到/data/mysql文件下 确保/data文件夹存在,没有则新建
[root@localhost /]# mkdir data
[root@localhost /]# mv /root/mysql-5.7.32-linux-glibc2.12-x86_64 /data/mysql
新建MySQL用户组
[root@localhost mysql]# groupadd mysql
[root@localhost mysql]# useradd -r -g mysql mysql
修改MySQl目录拥有者
[root@localhost mysql]# chown -R mysql:mysql ./
[root@localhost mysql]# mkdir data
[root@localhost mysql]# chown -R mysql:mysql ./data
[root@localhost mysql]# mkdir tmp
[root@localhost mysql]# chown -R mysql:mysql tmp
初始化并记下MySQL生成的随机密码 qf5k89.,JzlO (以实际生成为准)
[root@localhost mysql]# ./bin/mysqld --initialize --user=mysql --basedir=/data/mysql --datadir=/data/mysql/data
在/etc/my.cnf文件中修改内容
[mysqld]
basedir=/data/mysql
datadir=/data/mysql/data
socket=/data/mysql/mysql.sock
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
character-set-server=utf8
default-storage-engine=INNODB
lower_case_table_names=1
collation-server=utf8_general_ci[client]
socket=/data/mysql/tmp/mysql.sock[mysqld_safe]
#log-error=/var/log/mariadb/mariadb.log
#pid-file=/var/run/mariadb/mariadb.pidbasedir=/data/mysql
datadir=/data/mysql/data
socket=/data/mysql/tmp/mysql.sock
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES!includedir /etc/my.cnf.d
启动MySQL
[root@localhost mysql]# ./bin/mysqld_safe&
登录MySQL并修改密码和开发远程连接 admin 为你需要修改的密码
[root@localhost mysql]# ./bin/mysql -u root -pqf5k89.,JzlO
mysql> set password=password('admin');
mysql> use mysql;
mysql> update user set host = '%' where user = 'root';
添加环境变量,之前先手动杀死MySQL进程
[root@localhost mysql]# export MYSQL_HOME=/data/mysql
[root@localhost mysql]# export PATH=$PATH:$MYSQL_HOME/bin
[root@localhost mysql]# cp /data/mysql/support-files/mysql.server /etc/init.d/mysql
[root@localhost mysql]# source /etc/profile
[root@localhost mysql]# service mysql start