目录
数据库文件目录
/var/lib/mysql/
可通过以下sql命令查看:
mysql> show variables like 'datadir';
+---------------+-----------------+
| Variable_name | Value |
+---------------+-----------------+
| datadir | /var/lib/mysql/ |
+---------------+-----------------+
1 row in set (0.00 sec)
相关命令目录
/usr/bin/
mysqladmin、mysqlbinlog、mysqldump等命令
[root@shanghai01 bin]# cd /usr/bin
[root@shanghai01 bin]# find . -name "*mysql*"
./mysql_secure_installation
./mysql_upgrade
./mysql_migrate_keyring
./mysql_config_editor
./mysqlimport
./mysqlpump
./mysql
./mysqlslap
./mysqld_pre_systemd
./mysqlshow
./mysqlbinlog
./mysqldumpslow
./mysql_ssl_rsa_setup
./mysqlcheck
./mysqladmin
./mysqldump
./mysql_tzinfo_to_sql
/usr/sbin/
[root@shanghai01 bin]# cd /usr/sbin
[root@shanghai01 sbin]# find . -name "*mysql*"
./mysqld
./mysqld-debug
配置文件目录
/usr/share/mysql-8.0/
错误消息,字符集、安装文件和配置文件等
[root@shanghai01 mysql-8.0]# cd /usr/share/mysql-8.0
[root@shanghai01 mysql-8.0]# ll
total 1100
drwxr-xr-x 2 root root 4096 Apr 25 00:25 bulgarian
drwxr-xr-x 2 root root 4096 Apr 25 00:25 charsets
drwxr-xr-x 2 root root 4096 Apr 25 00:25 czech
drwxr-xr-x 2 root root 4096 Apr 25 00:25 danish
-rw-r--r-- 1 root root 25575 Dec 18 00:07 dictionary.txt
drwxr-xr-x 2 root root 4096 Apr 25 00:25 dutch
drwxr-xr-x 2 root root 4096 Apr 25 00:25 english
drwxr-xr-x 2 root root 4096 Apr 25 00:25 estonian
drwxr-xr-x 2 root root 4096 Apr 25 00:25 french
drwxr-xr-x 2 root root 4096 Apr 25 00:25 german
drwxr-xr-x 2 root root 4096 Apr 25 00:25 greek
drwxr-xr-x 2 root root