mysql数据库文件夹指向自定义的位置

mysql数据库文件夹指向自定义的位置

mysql数据库文件夹指向自定义的位置

修改 ​​C:\ProgramData\MySQL\MySQL Server 5.6​​​ 下面的​​my.ini​​文件

[mysqld]# The next three options are mutually exclusive to SERVER_PORT below.# skip-networking# enable-named-pipe# The Pipe the MySQL Server will use# socket=mysql# The TCP/IP Port the MySQL Server will listen onport=3306# Path to installation directory. All paths are usually resolved relative to this.basedir="C:\Program Files\MySQL\MySQL Server 5.6\"# Path to the database rootdatadir="E:\Database\data"###修改该位置为你的数据库地址# The default character set that will be used when a new schema or table is# created and no character set is definedcharacter-set-server=utf8# The default storage engine that will be used when create new tables whendefault-storage-engine=INNODB# Set the SQL mode to strictsql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"# Enable Windows Authentication# plugin-load=authentication_windows.dll

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。