查看Mysql数据库文件位置
windows——
搜一搜你的系统盘,一般根目录下会有个my.ini的文件,是隐藏的,这就是mysql的配置文件,内容如下:
#This File was made using the WinMySQLadmin 1.0 Tool
#2002-1-4 10:51:53
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=E:/Apache Group/MySQL
#bind-address=10.15.2.96
datadir=E:/Apache Group/MySQL/data
#language=E:/Apache Group/MySQL/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=E:/Apache Group/MySQL/bin/mysqld-nt.exe
user=yufan
password=*******
Linux——
首先你可以使用以下的命令来寻找MySQL
[root@stuhome /]# find / -name "mysql" -print
一般来说mysql是放在/usr/local/mysql/下的。
然后在其bin目录下有个mysql_config文件,vi之,你会看见这么一句:
ldata='/usr/local/mysql/var'