企业版：Enterprise  , 互联网行业一般不选择.

社区版本：选择
            源码包 编译安装：  source code    .tar.gz   
            通用二进制 


公司用什么版本数据库? 具体什么小版本号?
5.6.20 5.6.34 5.6.36  5.6.38  5.6.40    
5.7.18  5.7.20  5.7.22 5.7.39

[root@localhost application]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
     Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
     Active: inactive (dead)
       Docs: man:firewalld(1)


[root@localhost application]# getenforce
Disabled


[root@localhost application]# yum remove mariadb
No match for argument: mariadb
No packages marked for removal.
Dependencies resolved.
Nothing to do.
Complete!

[root@db01 ~]# mkdir -p /home/application/mysql

[root@db01 app]# mv mysql-5.7.39-linux-glibc2.12-x86_64 /home/application/mysql/app
[root@db01 app]# ls -l /home/application/mysql/app
total 36
drwxr-xr-x  2 root root   4096 Mar  4 14:55 bin
-rw-r--r--  1 7161 31415 17987 Sep 13  2017 COPYING
drwxr-xr-x  2 root root     55 Mar  4 14:55 docs
drwxr-xr-x  3 root root   4096 Mar  4 14:55 include
drwxr-xr-x  5 root root    229 Mar  4 14:55 lib
drwxr-xr-x  4 root root     30 Mar  4 14:55 man
-rw-r--r--  1 7161 31415  2478 Sep 13  2017 README
drwxr-xr-x 28 root root   4096 Mar  4 14:55 share
drwxr-xr-x  2 root root     90 Mar  4 14:55 support-files

[root@db01 ~]# vim /etc/profile #加入一行
export PATH=$PATH:/home/application/mysql/app/bin

[root@db01 bin]# source /etc/profile

useradd -s /sbin/nologin mysql -M

mkdir -p /home/application/mysql/data

chown -Rf mysql.mysql /home/application/mysql/app
chown -Rf mysql.mysql /home/application/mysql/data

报错原因: Linux系统中缺少libaio-devel 软件包
解决:
yum install -y libaio-devel

vim /etc/my.cnf

[mysqld]
user=mysql
basedir=/home/application/mysql/app
datadir=/home/application/mysql/data
character_set_server=utf8
collation-server=utf8_general_ci


#只能用IP地址检查客户端的登录，不用主机名,跳过域名解析
skip-name-resolve=1

#日志时间
log_timestamps=SYSTEM



#binlog配置
server_id=17
log-bin=mysql-bin
max_binlog_size = 100M
binlog_format=row
log_slave_updates
expire_logs_days=7





port=3306
socket=/tmp/mysql.sock
max_connections=1000
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
max_allowed_packet=300M

[mysql]
socket=/tmp/mysql.sock
default-character-set=utf8

vim /etc/systemd/system/mysqld.service
[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
ExecStart=/home/application/mysql/app/bin/mysqld --defaults-file=/etc/my.cnf
LimitNOFILE = 65535

systemctl  start/stop/restart/status   mysqld

#修改密码，

[root@db01 ~]# mysqladmin -uroot -p password openeuler@2023

Enter password: 直接回车

mysqladmin: [Warning] Using a password on the command line interface can be insecure. Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.

mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory

yum install libaio
yum install ncurses-compat-libs