下载
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端口
已经全部配置完成,可以进行验证