ubuntu安装mysql8.0

下载
https://dev.mysql.com/downloads/mysql/

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.28-linux-glibc2.17-x86_64-minimal.tar.xz

解压

xz -d mysql-8.0.28-linux-glibc2.17-x86_64-minimal.tar.xz
tar -xvf mysql-8.0.28-linux-glibc2.17-x86_64-minimal.tar

移动路径并更名

mv mysql-8.0.28-linux-glibc2.17-x86_64-minimal/ /data/mysql

设置mysql文件夹所属组和用户

chgrp -R root /data/mysql/
chown -R root /data/mysql/

修改脚本

cd /data/mysql/support-files/
vim mysql.server

修改2个参数

basedir=/data/mysql
datadir=/data/mysql/data

创建配置文件

cd /data/mysql/
touch my.cnf

#将basedir设置为安装路径
basedir=/data/mysql
#将datadir设置为数据目录路径
datadir=/data/mysql/data

#禁用binlog
skip-log-bin

#SQL模式
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION


#缓存配置根据情况设置mysql优化
#max_allowed_packet=256M
#max_connections=5000
#innodb_buffer_pool_size=
#innodb_buffer_pool_instances=
#key_buffer_size=
#tmp_table_size=
#max_heap_table_size=
#read_buffer_size=
#read_rnd_buffer_size=

初始化

cd /data/mysql/
./bin/mysqld --initialize --user=root

红框为root的初始密码
启动

cd /data/mysql/support-files/
./mysql.server start --user=root

进入mysql
设置指定别名

alias mysql=/data/mysql/bin/mysql

mysql -uroot -p

出现错误信息
error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

分析：缺少 libncurses.so.5
解决方案

已经成功进入mysql
修改root默认密码

alter user 'root'@'localhost' identified by '123456';

执行完在执行

flush privileges;

需要开启远程访问的话
进入mysql

use mysql;

update user set host='%' where user='root';

FLUSH PRIVILEGES;

防火墙需要开放3306端口
已经全部配置完成，可以进行验证