麒麟 V10 SP2 系统 二进制包安装MySQL 8.0.30

cat /etc/kylin-release 
nkvers

　rpm -qa | grep mariadb
　rpm -qa | grep mysql

yum install -y perl-Data-Dumper libaio libaio-devel
yum install -y ncurses ncurses-devel ncurses-base ncurses-libs
yum install -y openssl openssl-devel openssl-libs
yum install -y bzip2 bzip2-devel
yum install -y libtirpc libtirpc-devel
yum install -y readline readline-devel

cd /opt
tar xvf mysql-8.0.30-linux-glibc2.17-x86_64-minimal.tar.xz  -C /usr/local/
mv /usr/local/mysql-8.0.30-linux-glibc2.17-x86_64-minimal /usr/local/mysql-8.0.30

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

#创建MySQL数据目录
mkdir -p /data/mysql
#创建MySQL日志目录
mkdir -p /var/log/mysql
chown mysql:mysql -R /data/mysql
chown mysql:mysql -R  /var/log/mysql

ln -s /usr/local/mysql-8.0.30  /usr/local/mysql
chown  -R mysql.mysql mysql-8.0.30

echo 'MYSQL_HOME=/usr/local/mysql' >>  /etc/profile.d/mysql.sh
echo 'PATH=$PATH:$MYSQL_HOME/bin' >>  /etc/profile.d/mysql.sh
echo 'export PATH' >>  /etc/profile.d/mysql.sh
source  /etc/profile.d/mysql.sh

[server]
[mysqld]
#skip-grant-tables
datadir=/data/mysql
basedir=/usr/local/mysql
socket=/data/mysql/mysql.sock
log-error=/var/log/mysql/mysql.log
max_connections=1000
connect_timeout = 60
wait_timeout=600
interactive_timeout=600
lock_wait_timeout=3600
skip_name_resolve=1
skip_external_locking=1
open_files_limit=65535
explicit_defaults_for_timestamp=1
slow_query_log=1
slow_query_log_file=/var/log/mysql/slow.log
general-log=1
general-log-file=/var/log/mysql/sql_row.log
key_buffer_size=1M
read_buffer_size=4M
read_rnd_buffer_size=2M
table_open_cache=1024
table_definition_cache=1024
table_open_cache_instances=64
thread_cache_size=512
sort_buffer_size=16M
join_buffer_size=64M
bulk_insert_buffer_size=64M
tmp_table_size=64M
max_heap_table_size=776M
symbolic-links=0
max_allowed_packet =512M
bind-address =0.0.0.0
innodb_file_per_table=1
innodb_buffer_pool_size=1G
innodb_buffer_pool_instances=8
innodb_buffer_pool_load_at_startup=1
innodb_buffer_pool_dump_at_shutdown=1
innodb_log_file_size=1G
innodb_log_buffer_size=32M
innodb_log_files_in_group=2
innodb_flush_log_at_trx_commit=0
innodb_lock_wait_timeout=600
innodb_autoinc_lock_mode=2
innodb_doublewrite=OFF
innodb_thread_concurrency=16
innodb_flush_method=O_DIRECT
innodb_io_capacity=2000
innodb_io_capacity_max=4000
innodb_write_io_threads=32
innodb_read_io_threads=16
innodb_purge_threads=4
innodb_page_cleaners=4
innodb_open_files=65535
innodb_max_dirty_pages_pct=50
innodb_lru_scan_depth=4000
innodb_status_file=1
innodb_change_buffer_max_size=50
innodb_open_files=10000
open_files_limit=10000
[client]
socket=/data/mysql/mysql.sock

mysqld --defaults-file=/etc/my.cnf --user=mysql  --initialize

[Unit]
Description=MySQL Server
Documentation=man:mysqld(8)
Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html
After=network.target
After=syslog.target
[Install]
WantedBy=multi-user.target
[Service]
User=mysql
Group=mysql
Type=notify
# Disable service start and stop timeout logic of systemd for mysqld service.
TimeoutSec=0
# Execute pre and post scripts as root
PermissionsStartOnly=true
# Start main service
ExecStart=/usr/local/mysql/bin/mysqld $MYSQLD_OPTS
# Use this to switch malloc implementation
EnvironmentFile=-/etc/sysconfig/mysql
# Sets open_files_limit
LimitNOFILE = 10000
Restart=on-failure
RestartPreventExitStatus=1
# Set enviroment variable MYSQLD_PARENT_PID. This is required for restart.
Environment=MYSQLD_PARENT_PID=1
PrivateTmp=false

#启动mysqld服务
systemctl start mysql
#查看mysqld服务状态
systemctl status mysql
#开机启动mysqld服务
systemctl   enable  mysql

grep password /var/log/mysql/mysql.log

mysql -uroot -p

alter user 'root'@'localhost' identified by "123456";
flush privileges;

select host, user, plugin from mysql.user;

update mysql.user set host='%' where user='root';
#刷新权限
FLUSH PRIVILEGES;

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'password';
ALTER USER zabbix@'%' IDENTIFIED WITH mysql_native_password BY 'password';

#登录数据库
mysql -uroot -ppassword
#创建zabbix 数据库
mysql> create database zabbix character set utf8mb4 collate utf8mb4_bin;
#创建zabbix 用户
mysql>  create user 'zabbix'@'%' identified by 'password';
#授权localhost 访问
mysql> grant all privileges on zabbix.* to 'zabbix'@'%';
#刷新策略
flush privileges;
#退出
mysql> quit;