CentOS8 YUM部署 MySQL8.0 – 朱小帅 – 开发运维技术文档

CentOS8 YUM部署 MySQL8.0

|

2020-3-21 20:06

|

682

|

0

部署

[zhuxiaoshuai@mysql ~]#  yum install -y wget 
[zhuxiaoshuai@mysql ~]#  yum update #更新
[zhuxiaoshuai@mysql ~]#  wget https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm # Mysql 官网下载 RPM 包
[zhuxiaoshuai@mysql ~]#  yum localinstall mysql80-community-release-el8-1.noarch.rpm 
[zhuxiaoshuai@mysql ~]#  yum install mysql-server -y 
[zhuxiaoshuai@mysql ~]#  mysqladmin --version
[zhuxiaoshuai@mysql ~]#  systemctl start mysqld && systemctl enable mysqld
[zhuxiaoshuai@mysql ~]#  ps -ef | grep mysql

相关命令

[zhuxiaoshuai@mysql ~]#  cd /usr/bin/
[zhuxiaoshuai@mysql bin]#  find my*

myisamchk
myisam_ftdump
myisamlog
myisampack
my_print_defaults
mysql
mysqladmin
mysqlbinlog
mysqlcheck
mysql_config_editor
mysqld_pre_systemd
mysqldump
mysqldumpslow
mysqlimport
mysqlpump
mysql_secure_installation
mysqlshow
mysqlslap
mysql_ssl_rsa_setup
mysql_tzinfo_to_sql
mysql_upgrade

配置文件目录

[zhuxiaoshuai@mysql ~]#   ll /usr/share/mysql

total 928
drwxr-xr-x. 2 root root     24 Mar 16 15:11 bulgarian
drwxr-xr-x. 2 root root   4096 Mar 16 15:11 charsets
drwxr-xr-x. 2 root root     24 Mar 16 15:11 czech
drwxr-xr-x. 2 root root     24 Mar 16 15:11 danish
-rw-r--r--. 1 root root  25575 Jun 25  2019 dictionary.txt
drwxr-xr-x. 2 root root     24 Mar 16 15:11 dutch
drwxr-xr-x. 2 root root     24 Mar 16 15:11 english
-rw-r--r--. 1 root root 901883 Jun 25  2019 errmsg-utf8.txt
drwxr-xr-x. 2 root root     24 Mar 16 15:11 estonian
drwxr-xr-x. 2 root root     24 Mar 16 15:11 french
drwxr-xr-x. 2 root root     24 Mar 16 15:11 german
drwxr-xr-x. 2 root root     24 Mar 16 15:11 greek
drwxr-xr-x. 2 root root     24 Mar 16 15:11 hungarian
-rw-r--r--. 1 root root   3999 Jun 25  2019 innodb_memcached_config.sql
-rw-r--r--. 1 root root   2237 Oct  8 21:24 install_rewriter.sql
drwxr-xr-x. 2 root root     24 Mar 16 15:11 italian
drwxr-xr-x. 2 root root     24 Mar 16 15:11 japanese
drwxr-xr-x. 2 root root     24 Mar 16 15:11 korean
drwxr-xr-x. 2 root root     24 Mar 16 15:11 norwegian
drwxr-xr-x. 2 root root     24 Mar 16 15:11 norwegian-ny
drwxr-xr-x. 2 root root     24 Mar 16 15:11 polish
drwxr-xr-x. 2 root root     24 Mar 16 15:11 portuguese
drwxr-xr-x. 2 root root     24 Mar 16 15:11 romanian
drwxr-xr-x. 2 root root     24 Mar 16 15:11 russian
drwxr-xr-x. 2 root root     24 Mar 16 15:11 serbian
drwxr-xr-x. 2 root root     24 Mar 16 15:11 slovak
drwxr-xr-x. 2 root root     24 Mar 16 15:11 spanish
drwxr-xr-x. 2 root root     24 Mar 16 15:11 swedish
drwxr-xr-x. 2 root root     24 Mar 16 15:11 ukrainian
-rw-r--r--. 1 root root   1263 Oct  8 21:24 uninstall_rewriter.sql

数据库文件存放目录

[zhuxiaoshuai@mysql ~]#   ll -h /var/lib/mysql

total 164M
-rw-r-----. 1 mysql mysql   56 Mar 16 15:14  auto.cnf
-rw-r-----. 1 mysql mysql  155 Mar 16 15:14  binlog.000001
-rw-r-----. 1 mysql mysql   16 Mar 16 15:14  binlog.index
-rw-------. 1 mysql mysql 1.7K Mar 16 15:14  ca-key.pem
-rw-r--r--. 1 mysql mysql 1.1K Mar 16 15:14  ca.pem
-rw-r--r--. 1 mysql mysql 1.1K Mar 16 15:14  client-cert.pem
-rw-------. 1 mysql mysql 1.7K Mar 16 15:14  client-key.pem
-rw-r-----. 1 mysql mysql 5.3K Mar 16 15:14  ib_buffer_pool
-rw-r-----. 1 mysql mysql  12M Mar 16 15:14  ibdata1
-rw-r-----. 1 mysql mysql  48M Mar 16 15:14  ib_logfile0
-rw-r-----. 1 mysql mysql  48M Mar 16 15:13  ib_logfile1
-rw-r-----. 1 mysql mysql  12M Mar 16 15:14  ibtmp1
drwxr-x---. 2 mysql mysql  187 Mar 16 15:14 '#innodb_temp'
drwxr-x---. 2 mysql mysql  143 Mar 16 15:14  mysql
-rw-r-----. 1 mysql mysql  23M Mar 16 15:14  mysql.ibd
srwxrwxrwx. 1 mysql mysql    0 Mar 16 15:14  mysql.sock
-rw-------. 1 mysql mysql    5 Mar 16 15:14  mysql.sock.lock
-rw-r--r--. 1 mysql mysql    7 Mar 16 15:14  mysql_upgrade_info
srwxrwxrwx. 1 mysql mysql    0 Mar 16 15:14  mysqlx.sock
-rw-------. 1 mysql mysql    6 Mar 16 15:14  mysqlx.sock.lock
drwxr-x---. 2 mysql mysql 8.0K Mar 16 15:14  performance_schema
-rw-------. 1 mysql mysql 1.7K Mar 16 15:14  private_key.pem
-rw-r--r--. 1 mysql mysql  452 Mar 16 15:14  public_key.pem
-rw-r--r--. 1 mysql mysql 1.1K Mar 16 15:14  server-cert.pem
-rw-------. 1 mysql mysql 1.7K Mar 16 15:14  server-key.pem
drwxr-x---. 2 mysql mysql   28 Mar 16 15:14  sys
-rw-r-----. 1 mysql mysql  10M Mar 16 15:14  undo_001
-rw-r-----. 1 mysql mysql  10M Mar 16 15:14  undo_002

/etc/my.cnf.d #mysql的启动配置文件

client.cnf #mysql客户端配置文件

mysql-server.cnf #mysql守护进程配置文件

mysql-default-authentication-plugin.cnf #默认权限授权配置文件备注：可复制一份到/etc下，修改成my.cnf