Liuye Notebook
0%

Mysql-Server-Trial

发表于 更新于 分类于 阅读次数： Valine：

阅读更多

1 编译安装

前置依赖：

编译：

1
2
3
4
5
6
7
8
9
10
11
12
13
git clone https://github.com/mysql/mysql-server.git --depth 1
cd mysql-server

mkdir build
cd build

cmake -DCMAKE_EXPORT_COMPILE_COMMANDS=ON \
    -DCMAKE_C_COMPILER=/usr/local/bin/gcc \
    -DCMAKE_CXX_COMPILER=/usr/local/bin/g++ \
    -DWITH_BOOST=/usr/local/boost \
    ..

make

编译之后，mysql-server/build/runtime_output_directory目录下会生成二进制mysqld

启动：

1
2
3
4
5
6
7
cd mysql-server/build/runtime_output_directory

# 初始化，会在 mysql-server/build 目录下生成 data 子目录
./mysqld --initialize-insecure

# 启动
./mysqld

测试：

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CREATE DATABASE IF NOT EXISTS test;
CREATE TABLE test.user (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    password VARCHAR(255) NOT NULL,
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO test.user (username, password, email) 
VALUES 
('alice', 'password123', 'alice@example.com'),
('bob', 'securepass456', 'bob@example.com'),
('charlie', 'mypassword789', 'charlie@example.com');

SELECT * FROM test.user;

2 Tips

  1. truncate: sql/my_decimal.h:my_decimal_round
  2. How to start via docker: 
    1
    2
    3
    4
    # with persistent storage
    docker run -dit -p 3306:3306 -e MYSQL_ROOT_PASSWORD='Abcd1234' -v <local_path>:/var/lib/mysql mysql:5.7.37 mysqld --lower_case_table_names=1
    # without persistent storage
    docker run -dit -p 3306:3306 -e MYSQL_ROOT_PASSWORD='Abcd1234' mysql:5.7.37 mysqld --lower_case_table_names=1

3 Install from Archives

MySQL Product Archives

1
2
3
4
5
6
wget https://downloads.mysql.com/archives/get/p/23/file/mysql-9.2.0-linux-glibc2.28-x86_64.tar.xz

tar xf mysql-9.2.0-linux-glibc2.28-x86_64.tar.xz -C /usr/local

# Unifiy path, otherwise if may fail on loading /usr/local/mysql/lib/plugin/mysql_native_password.so:
mv /usr/local/mysql-9.2.0-linux-glibc2.28-x86_64 /usr/local/mysql