MYSQL 5.7.33 LINUX TAR安装

MYSQL 5.7.33 LINUX TAR安装

系统约定
Mysql目录安装位置：/usr/local/mysql
数据库保存位置：/usr/local/mysql/data
日志保存位置：/usr/local/mysql/logs

下载mysql
在官网：http://dev.mysql.com/downloads/mysql/ 中，选择以下版本的mysql下载：
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz

解压
tar -xvf mysql-5.7.33-linux-glibc2.12-x86_64.tar.gz
修改目录
mv mysql-5.7.33-linux-glibc2.12-x86_64 mysql
cd /usr/local/mysql
创建目录 data
mkdir data
mkdir logs

添加用户/组mysql
groupadd mysql
用户没有登录权限
useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql

进入cd /usr/local/mysql 当前目录的所属组合拥有者
chown -R mysql .
chgrp -R mysql .

进入mysql目录
cd /usr/local/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
执行完一定要记住密码

进入到support-files/ 目录
cd support-files/
cp mysql.server /etc/init.d/mysql
修改配置文件
vim /etc/init.d/mysql
修改这俩行
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

添加配置文件
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=utf8
# 取消密码验证
#skip-grant-tables
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
[mysqld_safe]
log-error=/usr/local/mysql/data/mysql.log
pid-file=/usr/local/mysql/data/mysql.pid

启动mysql
/etc/init.d/mysql start

创建软连接
ln -s /usr/local/mysql/bin/mysql /usr/bin
mysql -hlocalhost -uroot -p
输入上边记住的密码 回车
set password=password(‘root’);

授权外网访问
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘访问密码’;
flush privileges;

客户端 远程连接