MySQL命令查询:show global variables like "%datadir%";mysql> show global variables like "%datadir%";
+---------------+-------------------+
| Variable_name | Value |
+---------------+-------------------+
| datadir | /usr/local/mysql/ |
+---------------+-------------------+
1 row in set (0.00 sec)
从配置文件查看: cat /etc/my.cnf[root@localhost themes]# cat /etc/my.cnf
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8
[mysqld]
bind-address=0.0.0.0
port=3306
datadir=/usr/local/mysql
socket=/var/lib/mysql/mysql.sock
character-set-server=utf8
default_storage_engine=InnoDB
datadir=/usr/local/mysql,为数据存储目录。