win mysql

来源：互联网发布：车万翔老师的python课编辑：程序博客网时间：2024/05/17 20:30

On Windows, MySQL programs read startup options from the following files, in the specified order (top files are read first, later files take precedence).

File NamePurpose%PROGRAMDATA%\MySQL\MySQL Server 5.7\my.ini,%PROGRAMDATA%\MySQL\MySQL Server 5.7\my.cnfGlobal options%WINDIR%\my.ini,%WINDIR%\my.cnfGlobal optionsC:\my.ini, C:\my.cnfGlobal optionsINSTALLDIR\my.ini,INSTALLDIR\my.cnfGlobal optionsdefaults-extra-fileThe file specified with --defaults-extra-file=file_name,if any%APPDATA%\MySQL\.mylogin.cnfLogin path options

In table items, %PROGRAMDATA% represents the file system directory that contains application data for all users on the host. This path defaults toC:\ProgramData on Microsoft Windows Vista and greater, andC:\Documents and Settings\All Users\Application Data on older versions of Microsoft Windows.

%WINDIR% represents the location of your Windows directory. This is commonlyC:\WINDOWS. You can determine its exact location from the value of theWINDIR environment variable using the following command:

转自mysql帮助文档，要修改存储路径，但是按照网上总是找不到my.ini所在位置，原来是%PROGRAMDATA%目录，而不是MYSQL安装目录

0 0