Ubuntu 22.04 二进制安装 MySQL 8.0.31，安装MysqlWorkbench 及Test_db

二进制安装MySQL

​

1. 下载 MySQL 安装包

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz

2. 安装依赖包

sudo apt-get install libaio1 libaio-dev

3. 创建 MySQL HOME 目录

sudo mkdir -p /home/mysql

4. 创建MySQL 用户，组并指定默认路径

sudo groupadd mysql
sudo useradd -r -d /home/mysql -g mysql mysql

5. 更改 MySQL 目录的权限

sudo chown -R mysql:mysql /home/mysql

6. 将下载好的 MySQL 安装包移动支 /usr/local 下， 并解压

sudo cp mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz /usr/local/
cd /usr/local
sudo tar -xvf mysql-8.0.31-linux-glibc2.12-x86_64.tar.xz

7. 重命名文件夹，并更改文件夹权限

mv mysql-8.0.31-linux-glibc2.12-x86_64 mysql
sudo chown -R mysql:mysql /usr/local/mysql
# tree -d -L 1 mysql

8. 创建 data 目录和 log 目录 ，并修改权限

sudo mkdir /usr/local/mysql/data
sudo mkdir /usr/local/mysql/logs

sudo chown mysql:mysql /usr/local/mysql/data/
sudo chown mysql:mysql /usr/local/mysql/logs/

9. 创建配置文件my.cnf 并保存

sudo vim /etc/my.cnf
[mysqld]
server-id=1
port=3306
user=mysql
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
socket=/tmp/mysql.sock
pid-file=/usr/local/mysql/mysql.pid
character-set-server=utf8mb4
innodb_log_file_size=1G
default-storage-engine=INNODB
default_authentication_plugin=mysql_native_password
log-error=/usr/local/mysql/logs/error.log
#skip-grant-tables=1

[client]
port=3306
default-character-set=utf8
socket=/tmp/mysql.sock

10. 初始化 MySQL

sudo /usr/local/mysql/bin/mysqld --initialize --user mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
# 由于在 my.cnf 中已经指定了 log error 的路径，因此初始化的过程中所有的输出包括密码都保存在了指定的路径和log文件中
# /usr/local/mysql/logs/error.log 

11. 准备启动脚本并启动 MySQL

sudo cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
# 可查看 /etc/init.d/mysql.server 中的配置内容 datadir和basedir 是否和实际匹配

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

12. 启动 MySQL 并修改初始密码

mysql -uroot -p     ＃ 初始密码可在 /usr/local/mysql/logs/error.log 中找到， 如果在my.cnf中没指定error.log 路径则在初始化的过程中会出现

ALTER USER USER() IDENTIFIED BY '123456';
flush privileges;

13 . 更新 MySQL 启动路径

sudo vim /etc/profile    //全局
export PATH=$PATH:/usr/local/mysql/bin

sudo vim .bashrc        // 当前用户
export PATH=$PATH:/usr/local/mysql/bin

​

安装 MySQL Workbench

1. 下载 MySQL Workbench deb 安装包

2. 下载完成后， 执行安装

sudo dpkg -i mysql-workbench-community_8.0.31-1ubuntu22.04_amd64.deb 
＃ 如果安装过程中有报错缺少依赖，按提示 fix 即可

sudo apt-get update
sudo apt-get upgrade
sudo dpkg -i mysql-workbench-community_8.0.31-1ubuntu22.04_amd64.deb

安装 MySQL Test_db

下载 mysql test_db-master.zip 解压并进入目录 :  ​​https://github.com/datacharmer/test_db​​

unzip test_db-master.zip
cd cd test_db-master/

安装 test_db

Student@ian-Server:~$ mysql < employees.sql -uroot -p
Student@ian-Server:~$ mysql < test_employees_md5.sql -uroot -p
Enter password: 
INFO
TESTING INSTALLATION
table_name  expected_records  expected_crc
departments  9  d1af5e170d2d1591d776d5638d71fc5f
dept_emp  331603  ccf6fe516f990bdaa49713fc478701b7
dept_manager  24  8720e2f0853ac9096b689c14664f847e
employees  300024  4ec56ab5ba37218d187cf6ab09ce1aa1
salaries  2844047  fd220654e95aea1b169624ffe3fca934
titles  443308  bfa016c472df68e70a03facafa1bc0a8
table_name  found_records    found_crc
departments  9  d1af5e170d2d1591d776d5638d71fc5f
dept_emp  331603  ccf6fe516f990bdaa49713fc478701b7
dept_manager  24  8720e2f0853ac9096b689c14664f847e
employees  300024  4ec56ab5ba37218d187cf6ab09ce1aa1
salaries  2844047  fd220654e95aea1b169624ffe3fca934
titles  443308  bfa016c472df68e70a03facafa1bc0a8
table_name  records_match  crc_match
departments  OK  ok
dept_emp  OK  ok
dept_manager  OK  ok
employees  OK  ok
salaries  OK  ok
titles  OK  ok
computation_time
00:04:07
summary  result
CRC  OK
count  OK