Linux普通用户安装MySql5.7.13详细步骤及解释

Linux普通用户安装MySql5.7.13详细步骤及解释

1、下载mysql安装包：

BDY地址：https://pan.baidu.com/s/1KMBqitwtFmHzKc7r92cilA

提取码：elrm

2、解压

解压mysql5.7到指定的目录

tar -zxf mysql-5.7.13-linux-glibc2.5-x86_64.tar.gz -C .

3、创建目录

在解压后的mysql目录里面执行：

mkdir -p ./{data,log,tmp,var,conf}

4、配置文件 my.cnf

[mysqld]
port                               = 3306
basedir                            = /home/hadoop/mysql
datadir                            = /home/hadoop/mysql/data
tmpdir                             = /home/hadoop/mysql/tmp
socket                             = /home/hadoop/mysql/var/mysql.sock
pid-file                           = /home/hadoop/mysql/var/mysql.pid
slow_query_log_file                = /home/hadoop/mysql/log/slow.log
log_error                          = /home/hadoop/mysql/log/error.log
sql_mode                           = STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION
explicit_defaults_for_timestamp    = off
innodb_buffer_pool_size            = 1G
max_connections                    = 32000
max_connect_errors                 = 2000
max_allowed_packet                 = 30M
-- 打开binlog功能
log-bin=mysql-bin
server-id=1
binlog_format=MIXED
[mysql]
default-character-set = utf8
socket                             = /home/hadoop/mysql/var/mysql.sock

[client]
default-character-set = utf8
socket                = /home/hadoop/mysql/var/mysql.sock

[mysqld_safe]
log-error             = /home/hadoop/mysql/log/mariadb.log
pid-file              = /home/hadoop/mysql/var/mariadb.pid

5、一些环境配置，如不需要可忽略此步骤。

ln -s mysql /usr/local/mysql #建立软连接

scp -r $install_dir/mysql/support-files/mysql.server /etc/init.d/mysqld

yum -y install libaio libaio-devel #安装必要的包

mv /etc/my.cnf /etc/my.cnf.bak #备份原有全局配置

6、初始化mysql数据

bin/mysqld --defaults-file=/home/hadoop/mysql/conf/my.cnf --initialize --user='hadoop'

7、启动mysql

bin/mysqld_safe --defaults-file=/home/hadoop/mysql/conf/my.cnf &

8、添加环境变量

vi .bash_profile
PATH=$PATH:/home/hadoop/mysql/bin

9、登录mysql 密码在log/error.log中查看

grep password error.log
bin/mysql -uroot --socket=./var/mysql.sock -p

10、修改root密码

set password=password('abc123');

11、新建用户 授权

– 允许test用户对所有库所有表的权限

grant all privileges on *.* to test@"%" identified by "test2020" with grant option;

– 刷新

flush privileges;

– 退出

quit;