操作系统： Ubuntu 22.04

操作用户：root

1 安装 MySQL 8 {#1-%E5%AE%89%E8%A3%85-mysql-8}

使用 root 用户安装，切换至 root

sudo -s

1.1 下载 MySQL 8 {#1.1-%E4%B8%8B%E8%BD%BD-mysql-8}

wget https://cdn.mysql.com/archives/mysql-8.1/mysql-8.1.0-linux-glibc2.28-x86_64.tar

1.2 安装依赖 {#1.2-%E5%AE%89%E8%A3%85%E4%BE%9D%E8%B5%96}

apt-get -y install libaio1 libaio-dev libtinfo5

1.3 创建 MySQL 用户指定默认组 {#1.3-%E5%88%9B%E5%BB%BA-mysql-%E7%94%A8%E6%88%B7%E6%8C%87%E5%AE%9A%E9%BB%98%E8%AE%A4%E7%BB%84}

groupadd mysql
`useradd -g mysql mysql -s /usr/sbin/nologin`

1.4 解压、更改文件夹权限 {#1.4-%E8%A7%A3%E5%8E%8B%E3%80%81%E6%9B%B4%E6%94%B9%E6%96%87%E4%BB%B6%E5%A4%B9%E6%9D%83%E9%99%90}

cp mysql-8.1.0-linux-glibc2.28-x86_64.tar /opt cd /opt tar -xf mysql-8.1.0-linux-glibc2.28-x86_64.tar tar -xf mysql-8.1.0-linux-glibc2.28-x86_64.tar.xz mv mysql-8.1.0-linux-glibc2.28-x86_64/ mysql mkdir /opt/mysql/data mkdir /opt/mysql/logs

chown -R mysql:mysql /opt/mysql

1.5 创建配置文件 my.cnf {#1.5-%E5%88%9B%E5%BB%BA%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6-my.cnf}

cat >> /etc/my.cnf << EOF
[mysqld]
datadir=/opt/mysql/data
basedir=/opt/mysql
pid-file=/opt/mysql/mysql.pid
socket=/tmp/mysql.sock
log-error=/opt/mysql/logs/error.log
default-storage-engine=INNODB
character_set_server=utf8
lower_case_table_names=1
table_open_cache=128
max_connections=2000
max_connect_errors=6000
innodb_file_per_table=1
innodb_buffer_pool_size=1G
max_allowed_packet=64M
transaction_isolation=READ-COMMITTED
innodb_flush_method=O_DIRECT
innodb_lock_wait_timeout=1800
innodb_flush_log_at_trx_commit=0
sync_binlog=0
group_concat_max_len=1024000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
skip-name-resolve
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
EOF

1.6 添加环境变量 {#1.6-%E6%B7%BB%E5%8A%A0%E7%8E%AF%E5%A2%83%E5%8F%98%E9%87%8F}

vim /etc/profile //全局添加 export PATH=$PATH:/opt/mysql/bin vim .bashrc // 当前用户

添加 export PATH=$PATH:/opt/mysql/bin

1.7 初始化 MySQL {#1.7-%E5%88%9D%E5%A7%8B%E5%8C%96-mysql}

/opt/mysql/bin/mysqld --initialize --user mysql --basedir=/opt/mysql --datadir=/opt/mysql/data 初始化完成后密码保存在 /usr/local/mysql/logs/error.log

注意记录密码

1.8 准备启动 MySQL {#1.8-%E5%87%86%E5%A4%87%E5%90%AF%E5%8A%A8-mysql}

cp /opt/mysql/support-files/mysql.server /etc/init.d/ sudo /etc/init.d/mysql.server status sudo /etc/init.d/mysql.server stop

sudo /etc/init.d/mysql.server start

1.9 启动 MySQL 并修改初始密码 {#1.9-%E5%90%AF%E5%8A%A8-mysql-%E5%B9%B6%E4%BF%AE%E6%94%B9%E5%88%9D%E5%A7%8B%E5%AF%86%E7%A0%81}

mysql -uroot -p ＃初始密码可在 /opt/mysql/logs/error.log 中 ALTER USER USER() IDENTIFIED BY 'Password123@mysql'; 启用 root 远程登陆 update mysql.user set Host='%' where User='root'; GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION; flush privileges; 创建DataEase库 CREATE DATABASE dataease DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci; exit 验证密码

mysql -uroot -pPassword123@mysql -h192.168.1.142

1.10 设置开机自启 {#1.10-%E8%AE%BE%E7%BD%AE%E5%BC%80%E6%9C%BA%E8%87%AA%E5%90%AF}

update-rc.d mysql.server defaults

2 安装 DataEase v2 {#2-%E5%AE%89%E8%A3%85-dataease-v2}

2.1 下载安装包 {#2.1-%E4%B8%8B%E8%BD%BD%E5%AE%89%E8%A3%85%E5%8C%85}

在 DataEase 官网 dataease.io下载 DataEase v2.x 版本，并上传至服务器 /opt 目录；

2.2 解压安装包 {#2.2-%E8%A7%A3%E5%8E%8B%E5%AE%89%E8%A3%85%E5%8C%85}

tar -zxvf dataease-offline-installer-v2.2.0.tar.gz
`cd dataease-offline-installer-v2.2.0`

2.3 修改配置文件 {#2.3-%E4%BF%AE%E6%94%B9%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6}

vi install.conf 数据库配置是否使用外部数据库 DE_EXTERNAL_MYSQL=true 数据库地址 DE_MYSQL_HOST=192.168.1.142 数据库端口 DE_MYSQL_PORT=3306 DataEase 数据库库名 DE_MYSQL_DB=dataease 数据库用户名 DE_MYSQL_USER=root 数据库密码

DE_MYSQL_PASSWORD=Password123@mysql

修改位置如下图所示：