创建用户
groupadd mysql
useradd -g mysql mysql
删除原来的包
# rpm -qa|grep mysql
# rpm -qa|grep mari
mariadb-libs-5.5.68-1.el7.x86_64
# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
解压
cd /usr/local & mkdir mysql
cd mysql
# cp mysql-8.0.34-linux-glibc2.12-x86_64.tar.gz /home/mysql/
# cd /home/mysql/
chown mysql:mysql mysql-8.0.34-linux-glibc2.12-x86_64.tar.gz
chmod 775 mysql-8.0.34-linux-glibc2.12-x86_64.tar.gz
su - mysql
tar -xvf mysql-8.0.34-linux-glibc2.12-x86_64.tar.gz
mv mysql-8.0.34-linux-glibc2.12-x86_64 mysql834
创建通用目录
ln -s /home/mysql/mysqlbase /usr/local/mysql
cd /usr/local/mysql/mysql834
# ls -lrt
total 308
-rw-r--r-- 1 mysql mysql 666 Jun 22 19:07 README
-rw-r--r-- 1 mysql mysql 279815 Jun 22 19:07 LICENSE
drwxr-xr-x 2 mysql mysql 4096 Jun 22 20:25 support-files
drwxr-xr-x 28 mysql mysql 4096 Jun 22 20:25 share
drwxr-xr-x 4 mysql mysql 4096 Jun 22 20:25 man
drwxr-xr-x 6 mysql mysql 4096 Jun 22 20:25 lib
drwxr-xr-x 3 mysql mysql 4096 Jun 22 20:25 include
drwxr-xr-x 2 mysql mysql 4096 Jun 22 20:25 docs
drwxr-xr-x 2 mysql mysql 4096 Jun 22 20:25 bin
# mkdir /data
# chown mysql:mysql /data
# chmod 775 /data
su - mysql
配置root
vim /etc/profile
export PATH=$PATH:/usr/local/mysql/mysqlbase/bin:/usr/local/mysql/mysqlbase/lib
source /etc/profile
编写配置文件
mysql> prompt \R:\m:\s \U[\d]>
shell> export MYSQL_PS1="(\u@\h) [\d]> "
shell> mysql --prompt="(\u@\h) [\d]> "
prompt=(\\u@\\h) [\\d]>\\_
port=3306
default-character-set = utf8mb4
socket = /tmp/mysql.sock
[mysql]
prompt="\R:\m:\s [\d]> "
no-auto-rehash
max_allowed_packet = 256M
[mysqld]
server-id=1
port=3306
basedir=/usr/local/mysql/mysqlbase
datadir=/data
socket=/tmp/mysql.sock
log-error=/data/mysqld.log
pid-file=/data/mysqld.pid
user=mysql
character_set_server = utf8mb4
collation_server = utf8mb4_general_ci
default-storage-engine = InnoDB
autocommit = on
event_scheduler = ON
log_error = /home/mysql/error.log
lower_case_table_names = 1
back_log=2000
connect_timeout=15
skip_name_resolve=ON
max_connections=5000
table_definition_cache=2000
table_open_cache=10000
ssl=0
slow_query_log = ON
slow_query_log_file = /data/slow.log
# Innodb
innodb_buffer_pool_size = 10240M
innodb_buffer_pool_instances=8
innodb_log_file_size = 1024M --已经过期
innodb_log_buffer_size = 16M
innodb_lock_wait_timeout = 20
innodb_autoinc_lock_mode=2
innodb_read_io_threads = 5
innodb_write_io_threads = 5
innodb_thread_concurrency = 8
innodb_doublewrite=1
innodb_flush_log_at_trx_commit = 2
innodb_flush_method = 'O_DIRECT'
innodb-page-cleaners=8
innodb_purge_threads=4
innodb_lru_scan_depth=2048
innodb_io_capacity=8000
innodb_io_capacity_max=16000
innodb_adaptive_hash_index=OFF
innodb-change-buffering=none
innodb_flush_neighbors=0
innodb_max_dirty_pages_pct = 90
innodb_max_dirty_pages_pct_lwm = 10
innodb_file_per_table = ON
# Binlog
relay-log=relay-1
enforce-gtid-consistency
gtid-mode=on
binlog_cache_size = 1024M
#master-info-repository=TABLE
#relay-log-info-repository=TABLE
binlog-checksum=NONE
log-bin
sync_binlog=1
# Monitoring
innodb_monitor_enable='%'
performance_schema=ON
performance_schema_instrument='%synch%=on'
初始化数据库
./mysqld --user=mysql --basedir=/usr/local/mysql/mysqlbase --datadir=/data --initialize
./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.11' not found (required by ./mysqld)
./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by ./mysqld)
./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.22' not found (required by ./mysqld)
./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by ./mysqld)
./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by ./mysqld)
./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by ./mysqld)
./mysqld: /lib64/libm.so.6: version `GLIBC_2.27' not found (required by ./mysqld)
./mysqld: /lib64/libc.so.6: version `GLIBC_2.28' not found (required by ./mysqld)
./mysqld: /lib64/libc.so.6: version `GLIBC_2.25' not found (required by /home/mysql/mysql834/bin/../lib/private/libcrypto.so.3)
./mysqld: /lib64/libc.so.6: version `GLIBC_2.28' not found (required by /home/mysql/mysql834/bin/../lib/private/libprotobuf-lite.so.3.19.4)
./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.20' not found (required by /home/mysql/mysql834/bin/../lib/private/libprotobuf-lite.so.3.19.4)
./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.9' not found (required by /home/mysql/mysql834/bin/../lib/private/libprotobuf-lite.so.3.19.4)
./mysqld: /lib64/libstdc++.so.6: version `CXXABI_1.3.8' not found (required by /home/mysql/mysql834/bin/../lib/private/libprotobuf-lite.so.3.19.4)
./mysqld: /lib64/libstdc++.so.6: version `GLIBCXX_3.4.21' not found (required by /home/mysql/mysql834/bin/../lib/private/libprotobuf-lite.so.3.19.4)
自启动配置
/usr/local/mysql/mysqlbase下执行
cp -a ./support-files/mysql.server /etc/init.d/mysql
cp -a ./support-files/mysql.server /etc/init.d/mysqld
chown 777 /etc/my.cnf
chmod +x /etc/init.d/mysql
chmod +x /etc/init.d/mysqld
service mysqld status
service mysqld start
# service mysqld start
/etc/init.d/mysqld: line 239: my_print_defaults: command not found
Starting MySQL ERROR! Couldn't find MySQL server (/usr/local/mysql/bin/mysqld_safe)
basedir出错修改后restart后即可
# service mysqld restart
mysqld safe启动数据库
# ./mysqld_safe --user=mysql --basedir=/usr/local/mysql/mysqlbase --datadir=/data &
[1] 22115
# 2024-07-04T13:24:11.353388Z mysqld_safe Logging to '/home/mysql/error.log'.
root 22115 13926 0 15:45 pts/0 00:00:00 /bin/sh ./mysqld_safe --user=mysql --basedir=/usr/local/mysql/mysql833 --datadir=/data
mysql 22943 22115 41 15:45 pts/0 00:00:03 /usr/local/mysql/mysql833/bin/mysqld --basedir=/usr/local/mysql/mysql833 --datadir=/data --plugin-dir=/usr/local/mysql/mysql833/lib/plugin --user=mysql --log-error=/home/mysql/error.log --pid-file=/data/mysqld.pid --socket=/tmp/mysql.sock --port=3306
root 23003 13926 0 15:45 pts/0 00:00:00 grep --color=auto mysq
启动mysql改root密码
mysql -uroot -p
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'newpassword'
脚本调整
/data/mysql/bin/mysqld_safe --user=mysql --basedir=/data/mysql --datadir=/data/mysqldata &
/data/mysql/bin/mysql -uroot -p"Tjyd@_123$" << eof
shutdown;
eof
