GreatSQL单机环境安装

groupadd mysql
useradd -g mysql mysql
mkdir -p /opt/mysql/data/{data,logs,tmp}
chown -R mysql:mysql /opt/mysql/

# /etc/my.cnf
[client]
port=3306
socket=/opt/mysql/data/tmp/mysql.3306.sock


[mysql]
prompt="\u@mysqldb \R:\m:\s [\d]> "
no-auto-rehash
loose-skip-binary-as-hex


[mysqld]
user=mysql
port=3306
basedir=/opt/mysql/GreatSQL
datadir=/opt/mysql/data/data
socket=/opt/mysql/data/tmp/mysql.3306.sock
pid-file=/opt/mysql/data/tmp/mysql.3306.pid
character-set-server=utf8mb4
lower_case_table_names=1
innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:5G
default_authentication_plugin=mysql_native_password


slow_query_log=1
log_timestamps=SYSTEM
slow_query_log_file=/opt/mysql/data/logs/slow.log
log-error=/opt/mysql/data/logs/mysql.error.log
long_query_time=1
log_queries_not_using_indexes =1
log_throttle_queries_not_using_indexes=60
min_examined_row_limit = 100
log_slow_admin_statements = 1
server-id=15910
log-bin=/opt/mysql/data/logs/mysql-binlog


[mysqld_safe]
log-error=/opt/mysql/data/logs/mysql.error.log
pid-file=/opt/mysql/data/tmp/mysql.3306.pid


[mysqldump]
quick
max_allowed_packet = 64M

yum -y install jemalloc jemalloc-devel

[root@bisal software]# ldconfig -p | grep libjemalloc
        libjemalloc.so.1 (libc6,x86-64) => /lib64/libjemalloc.so.1
        libjemalloc.so (libc6,x86-64) => /lib64/libjemalloc.so

./mysqld --defaults-file=/opt/mysql/GreatSQL/my.cnf --basedir=/opt/mysql/GreatSQL --datadir=/opt/mysql/data/data --initialize
2022-04-03T09:46:56.502250+08:00 0 [System] [MY-013169] [Server] /opt/mysql/GreatSQL/bin/mysqld (mysqld 8.0.25-15) initializing of server in progress as process 22877
2022-04-03T09:46:56.535114+08:00 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-04-03T09:46:58.300456+08:00 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.

root@localhost is created with an empty password ! Please consider switching off the --initialize-insecure option.

mysql.server start

[mysql@bisal bin]$ mysql -uroot -p'FAucEoQJ0-;9'
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 8.0.25-15


Copyright (c) 2021-2021 GreatDB Software Co., Ltd
Copyright (c) 2009-2021 Percona LLC and/or its affiliates
Copyright (c) 2000, 2021, Oracle and/or its affiliates.


Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.


Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.

mysql> set password='root';
Query OK, 0 rows affected (0.03 sec)
mysql> alter user current_user() identified by 'root';
Query OK, 0 rows affected (0.01 sec)