Home > Database > Mysql Tutorial > 如何修改Mysql数据库的保存目录?

如何修改Mysql数据库的保存目录?

WBOY
Release: 2016-06-07 18:08:00
Original
1477 people have browsed it

打开mysql安装目录中的my.ini 修改 #*** INNODB Specific options *** innodb_data_home_dir=F:/MySQLDATA/ 重启mysql后,新建立的库会保存在这个f:\mysqldata目录中, 注意,这个目录必须有mysql运行用户的全部访问权限。

打开mysql安装目录中的my.ini

修改
#*** INNODB Specific options ***
innodb_data_home_dir="F:/MySQLDATA/"

重启mysql后,新建立的库会保存在这个f:\mysqldata目录中,
注意,这个目录必须有mysql运行用户的全部访问权限。
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template