【MySQL】目录结构

1. MySQL 8的主要目录结构

输入find / -name mysql，可查看与mysql相关的目录：

/usr/lib64/mysql
/usr/bin/mysql
/etc/logrotate.d/mysql
/etc/selinux/targeted/active/modules/100/mysql
/var/lib/mysql
/var/lib/mysql/mysql

1.1 数据库文件的存放路径：/var/lib/mysql/

mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| datadir       | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.01 sec)

1.2 命令相关目录/usr/bin、/usr/sbin

[root@iZ2ze57vwreom2c3lj7y9eZ ~]# ls /usr/bin | grep mysql
mysql
mysqladmin
mysqlbinlog
mysqlcheck
mysql_config_editor
mysqld_pre_systemd
mysqldump
mysqldumpslow
mysqlimport
mysql_migrate_keyring
mysqlpump
mysql_secure_installation
mysqlshow
mysqlslap
mysql_ssl_rsa_setup
mysql_tzinfo_to_sql
mysql_upgrade
[root@iZ2ze57vwreom2c3lj7y9eZ ~