镜像下载、域名解析、时间同步请点击 阿里云开源镜像站
一、下载mysql8.0安装包
1、在local创建mysql文件夹
cd /usr/localmkdir mysqlcd mysql
2、使用wget下载mysql8.0的xz安装包
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.20-linux-glibc2.12-x86_64.tar.xz
二、解压mysql8.0安装包
1、解压
tar -xvJf mysql-8.0.21-linux-glibc2.12-x86_64.tar.xz
2、重命名解压后的mysql文件夹（名字太长了）
mv mysql-8.0.21-linux-glibc2.12-x86_64 mysql8.0
3、创建data存储文件
cd mysql8.0mkdir data
三、创建用户和用户组，并赋予权限
1、创建用户和用户组
groupadd mysqluseradd -g mysql mysql
2、给用户赋予权限
chown -R mysql.mysql /usr/local/mysql/mysql8.0
四、初始化mysql信息
1、切换到mysql8.0安装路径下
Tip：绝对路径：cd /usr/local/mysql/mysql8.0/bin
cd bin
2、初始化mysql基本信息
./mysqld —user=mysql —basedir=/usr/local/mysql/mysql8.0 —datadir=/usr/local/mysql/mysql8.0/data/ —initialize
3、获取到临时mysql密码
五、添加mysqld服务到系统
1、将mysqld服务添加到系统中
cd /usr/local/mysql/mysql8.0cp -a ./support-files/mysql.server /etc/init.d/mysql
2、授权以及添加服务
chmod +x /etc/init.d/mysqlchkconfig --add mysql
3、mysql5.7以后就没有my.cnf了，所以我们创建一个。（个人觉得方便一些）
sudo vim my.cnf
```Example MySQL config file for small systems.
This is for a system with little memory (<= 64M) where MySQL is only used
from time to time and it’s important that the mysqld daemon
doesn’t use much resources.
MySQL programs look for option files in a set of
locations which depend on the deployment platform.
You can copy this option file to one of those
locations. For information about these locations, see:
http://dev.mysql.com/doc/mysql/en/option-files.html
In this file, you can use all long options that a program supports.
If you want to know which options a program supports, run the program
with the “—help” option.
The following options will be passed to all MySQL clients
[client]
default-character-set=utf8
password = k0Ui&wV(Z3yt
port = 3306
socket = /tmp/mysql.sock
Here follows entries for some specific programs
The MySQL server
[mysqld]
配置mysql的文件夹 和 mysql data目录
basedir=/usr/local/mysql/mysql8.0
datadir=/usr/local/mysql/mysql8.0/data
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
port = 3306
socket = /tmp/mysql.sock
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 128K
Don’t listen on a TCP/IP port at all. This can be a security enhancement,
if all processes that need to connect to mysqld run on the same host.
All interaction with mysqld must be made via Unix sockets or named pipes.
Note that using this option without enabling named pipes on Windows
(using the “enable-named-pipe” option) will render mysqld useless!
skip-networking
server-id = 1
Uncomment the following if you want to log updates
log-bin=mysql-bin
binary logging format - mixed recommended
binlog_format=mixed
Causes updates to non-transactional engines using statement format to be
written directly to binary log. Before using this option make sure that
there are no dependencies between transactional and non-transactional
tables such as in the statement INSERT INTO t_myisam SELECT * FROM
t_innodb; otherwise, slaves may diverge from the master.
binlog_direct_non_transactional_updates=TRUE
Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /usr/local/mysql/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /usr/local/mysql/data
You can set .._buffer_pool_size up to 50 - 80 %
of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
Remove the next comment character if you are not familiar with SQL
safe-updates
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
```
*设置my.cnf权限
sudo chmod 664 /etc/my.cnf
4、启动mysql服务
service mysql start
如果出现下面报错
解决
将/var/lock/subsys/下mysql文件删除
5、查看mysql服务状态
service mysql status
6、将mysql命令添加到服务
ln -s /usr/local/mysql/mysql8.0/bin/mysql /usr/bin
六、登录mysql
1、登录 密码使用之前随机生成的密码
mysql mysql -uroot -p
2、修改管理员密码 其中123456是新的密码自己设置
ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
3、重新加载缓存，使密码生效
flush privileges；
4、退出mysql，用新密码尝试登录管理员
七、修改mysql配置，使其可以用工具远程登录
update user set host=’%’ where user=’root’;
flush privileges;
云服务器不能远程连接mysql，解决
如果是买的云服务器，例如：阿里云服务器的，请到设置mysql(3306)安全策略
总结
到此就已经完成了在Linux中mysql8.0的所有安装。希望对大家有所帮助。
本文转自：https://blog.csdn.net/qq_45554167/article/details/121907007
