如何修改Mysql数据库的保存目录?
Jun 07, 2016 pm 06:08 PM打开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运行用户的全部访问权限。

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to optimize MySQL query performance in PHP?

How to use MySQL backup and restore in PHP?

How to insert data into a MySQL table using PHP?

How to fix mysql_native_password not loaded errors on MySQL 8.4

How to use MySQL stored procedures in PHP?

How to create a MySQL table using PHP?

Detailed tutorial on establishing a database connection using MySQLi in PHP

iOS 18 adds a new 'Recovered' album function to retrieve lost or damaged photos
