mysql查看datadir

show variables like '%data%';
+---------------------------------------+-------------------------------+
| Variable_name                         | Value                         |
+---------------------------------------+-------------------------------+
| audit_log_exclude_databases           |                               |
| audit_log_include_databases           |                               |
| binlog_row_metadata                   | MINIMAL                       |
| character_set_database                | utf8mb4                       |
| clone_max_data_bandwidth              | 100                           |
| collation_database                    | utf8mb4_0900_ai_ci            |
| datadir                               | /var/lib/mysql/data/mydata/   |
| innodb_data_file_path                 | ibdata1:128M:autoextend       |
| innodb_data_home_dir                  | /var/lib/mysql/data/innodb_ts |
| innodb_stats_on_metadata              | OFF                           |
| innodb_temp_data_file_path            | ibtmp1:12M:autoextend         |
| innodb_use_fdatasync                  | OFF                           |
| max_length_for_sort_data              | 16384                         |
| myisam_data_pointer_size              | 6                             |
| performance_schema_max_metadata_locks | -1                            |
| resultset_metadata                    | FULL                          |
| skip_show_database                    | OFF                           |
| updatable_views_with_limit            | YES                           |
+---------------------------------------+-------------------------------+
18 rows in set (0.00 sec)

du -sh /var/lib/mysql/data/mydata/ 

• mysql show 命令详解

ps -ef|grep mysql
grep data /etc/mysql/my.cnf