Linux安装MySql-8.0.28

#MySql-8.0.28安装手册

上传文件

使用WinSCP上传文件至home目录。

###解压文件

cd /home
tar -xzvf mysql-8.0.28-el7-x86_64.tar.gz

重命名文件

mv mysql-8.0.28-el7-x86_64 mysql-8.0.28

新建data、logs目录

data：数据库储存目录；
logs：存放mysql日志（如果有可不用新建）。

cd /home/mysql-8.0.28
mkdir data
mkdir logs

创建mysql用户组和用户并修改权限

如果登录mysql用户安装，跳过此步

cat /etc/group #查看用户组信息是否存在mysql用户组
groupadd mysql #新建mysql用户组

cat /etc/passwd|grep mysql #查看是否存在MySQL用户
useradd -r -g mysql mysql #新建mysql用户

修改mysql目录权限

chown -R mysql:mysql /home/mysql-8.0.28

配置my.cnf

vi /etc/my.cnf

内容如下

[client]
#客户端设置
port    = 3306
socket    = /home/mysql-8.0.28/data/mysql.sock
default-character-set = utf8
 
[mysqld]
user    = mysql
port    = 3306
socket    = /home/mysql-8.0.28/data/mysql.sock
server-id = 1
pid-file = /home/mysql-8.0.28/data/mysql.pid
default_authentication_plugin=mysql_native_password
#安装目录
basedir    = /home/mysql-8.0.28
#数据库存放目录
datadir    = /home/mysql-8.0.28/data/
#系统数据库编码设置，排序规则
character_set_server = utf8
collation_server = utf8_bin
# skip-grant-tables
# bind-address = 0.0.0.0
back_log = 1024
explicit_defaults_for_timestamp = ON
lower_case_table_names = 1
sql_mode = STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
 
max_connections = 512
max_connect_errors = 1000000
table_open_cache = 1024
max_allowed_packet = 2048M
thread_stack = 256K
thread_cache_size = 384
 
skip-external-locking
 
interactive_timeout = 600
wait_timeout = 28800
log_timestamps = SYSTEM
log-error = /home/mysql-8.0.28/logs/error.log
 
#默认使用InnoDB存储引擎
default_storage_engine = InnoDB
innodb_file_per_table=1
innodb_strict_mode = 0
innodb_buffer_pool_size = 512M
innodb_purge_threads = 1
innodb_log_buffer_size = 32M
innodb_log_file_size = 128M
innodb_lock_wait_timeout = 120
 
bulk_insert_buffer_size = 32M
myisam_sort_buffer_size = 8M
# MySQL重建索引时所允许的最大临时文件的大小
myisam_max_sort_file_size = 10G
myisam_repair_threads = 1

# 事务隔离级别，解决报错 java.sql.SQLException: could not retrieve transation read-only status server
transaction_isolation = READ-COMMITTED

初始化数据库

进入mysql-8.0.28的bin目录

cd /home/mysql-8.0.28/bin

./mysqld --initialize --user=mysql --basedir=/home/mysql/mysql-8.0.28 --datadir=/home/mysql/mysql-8.0.28/data --lower_case_table_names =1

生成临时密码（请记录）。
加入服务

cp /home/mysql-8.0.28/support-files/mysql.server  /etc/init.d/mysql

启动mysql

service mysql start（service mysql restart）

进入数据库

cd /home/mysql-8.0.28/bin
./mysql -u root -p

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY 'root_123';

为远程登录创建用户,并赋权

CREATE USER 'root'@'%' IDENTIFIED BY 'root_123';

GRANT ALL ON *.* TO 'root'@'%';

FLUSH PRIVILEGES;