之前在centos7上编译安装过mysql8，这次记录下在ubuntu22.04上编译安装的过程，编译软件版要求和约束路径都和centos一样，可以查看之前的笔记：https://sulao.cn/post/775

安装包存放/usr/local/src下，编译安装到/usr/local/对应软件目录下，例如mysql就是/usr/local/mysql目录下
/data/mysql目录是mysql数据存放目录，我全程是root账户编译的，自行sudo进行切换到root账户，mysql运行账户使用的mysql

apt update
apt install build-essential cmake pkg-config libncurses5-dev libssl-dev libaio-dev libreadline-dev libtirpc-dev -y

下载mysql-boost-8.0.42.tar.gz编译源码包

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-boost-8.0.42.tar.gz
tar -zxvf mysql-boost-8.0.42.tar.gz

添加管理mysql服务账户

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

创建mysql数据存储目录

mkdir -p /data/mysql

创建编译目录

mkdir -p /usr/local/mysql

进入源码目录，开始编译

cd mysql-8.0.42
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql/ -DDOWNLOAD_BOOST=1 -DWITH_BOOST=boost -DFORCE_INSOURCE_BUILD=1 -DENABLE_DOWNLOADS=1 -DCMAKE_C_COMPILER=/usr/bin/gcc -DCMAKE_CXX_COMPILER=/usr/bin/g++
make && make install

配置mysql配置使用my.cnf文件

[client]
port = 3306
socket = /data/mysql/mysql.sock
default-character-set = utf8mb4
[mysqld]
port = 3306
socket = /data/mysql/mysql.sock
basedir = /usr/local/mysql
datadir = /data/mysql
pid-file = /data/mysql/mysql.pid
server-id = 1
init-connect = 'SET NAMES utf8mb4'
character-set-server = utf8mb4
#skip_name_resolve
#skip-networking
back_log = 300
max_connections = 2000
max_connect_errors = 6000
open_files_limit = 65535
table_open_cache = 128
max_allowed_packet = 500M
binlog_cache_size = 1M
max_heap_table_size = 8M
tmp_table_size = 16M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
sort_buffer_size = 8M
join_buffer_size = 8M
key_buffer_size = 4M
thread_cache_size = 8
ft_min_word_len = 4
log_bin = mysql-bin
binlog_format = mixed
expire_logs_days = 7
binlog_expire_logs_seconds = 604800
log_error = /data/mysql/mysql-error.log
slow_query_log = 1
long_query_time = 1
slow_query_log_file = /data/mysql/mysql-slow.log
general_log = 1
general_log_file = /data/log/mysql/mysql.log
performance_schema = 0
#lower_case_table_names = 1
skip-external-locking
default_storage_engine = InnoDB
innodb_file_per_table = 1
innodb_open_files = 500
innodb_buffer_pool_size = 64M
innodb_write_io_threads = 4
innodb_read_io_threads = 4
innodb_thread_concurrency = 0
innodb_purge_threads = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 2M
innodb_log_file_size = 32M
innodb_log_files_in_group = 3
innodb_max_dirty_pages_pct = 90
innodb_lock_wait_timeout = 120
bulk_insert_buffer_size = 8M
interactive_timeout = 28800
wait_timeout = 28800
[mysqldump]
quick
max_allowed_packet = 500M
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
read_buffer = 4M
write_buffer = 4M

指定数据目录和运行目录并初始化mysql8

/usr/local/mysql/bin/mysqld --initialize --basedir=/usr/local/mysql --datadir=/data/mysql

这个步骤会产生一个mysql密码，我们需要将它记录下来
cat /data/mysql/mysql-error.log

重新赋权mysql存储目录

chown -R mysql:mysql /data/mysql

最后我们可以编写一个mysql的服务，方便我们使用systemctl控制它

cp ./support-files/mysql.server /usr/local/mysql/bin/mysql.server
vi /usr/local/mysql/bin/mysql.server
basedir = /usr/local/mysql #MySQL程序安装路径
datadir = /data/mysql #MySQl数据库存放目录

给服务脚本执行权限

chmod +x /usr/local/mysql/bin/mysql.server

编译mysql管理服务配置文件

vi /usr/lib/systemd/system/mysqld.service
[Unit]
Description=mysql project
After=mysqld.service

[Service]
Type=forking
User=mysql
Group=mysql
PIDFile=/data/mysql/mysql.pid
ExecStart=/usr/local/mysql/bin/mysql.server start
ExecReload=/usr/local/mysql/bin/mysql.server restart
ExecStop=/usr/local/mysql/bin/mysql.server stop
PrivateTmp=true

[Install]
WantedBy=multi-user.target

给管理服务配置脚本754权限

chmod 754 /usr/lib/systemd/system/mysqld.service
systemctl daemon-reload
systemctl start mysqld.service #启动mysql
systemctl enable mysqld.service #添加到开机启动

将mysql服务加入系统环境变量，在最后添加下面这一行

vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin

退出编辑，使其生效

source /etc/profile

登录修改默认密码，使用刚才mysql-error.log中记录的密码

mysql -u root -p
alter user "root"@"localhost" identified by "新密码";

授权用户远程访问

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

最后刷新权限

flush privileges;

最后我们再次确认下host是"%"说明可以远程登录了。

use mysql;
select host, user, authentication_string, plugin from user;