Mysql查看系统变量值
- 查看安装目录
ERROR 1193 (HY000): Unknown system variable 'base_dir'
mysql> select @@basedir;
+------------------------------------------+
| @@basedir |
+------------------------------------------+
| D:\Program Files\MySQL\MySQL Server 5.7\ |
+------------------------------------------+
1 row in set (0.00 sec)
- 查看数据目录
mysql> select @@datadir;
+-----------------------------------------------+
| @@datadir |
+-----------------------------------------------+
| D:\Program Files\MySQL\MySQL Server 5.7\data\ |
+-----------------------------------------------+
1 row in set (0.00 sec)