问题描述      修改mysql5.7安装目录下my-default.ini发现不起作用:

MySQL的版本是5.7,操作系统是window8.1。MySQL安装在 C:\Program Files 下。最近需要在MySQL安装目录下的 my-default.ini 配置文件里面加上一个新的配置项:

event_scheduler = 1 #或者ON 


编辑文件后保存,总是无法保存,提示“拒绝访问”。
后来停止 MySQL 的服务,依然无法保存修改。
再后来把my-default.ini 复制到D盘,修改后保存。删除 C:\Program Files
下原来的配置文件。用管理员身份打开命令行,使用 copy 命令复制到  C:\Program Files
下原来的位置。虽然解决了配置文件无法保存的问题,但是重启 MySQL 服务后,show variables 命令可以看到参数并没有更改过来。

发现my-default.ini内容确实已经修改,但是不起作用

解决方法  修改C:\ProgramData\MySQL\MySQL Server 5.7 下的 my.ini 配置文件

1,停止 MySQL 服务。

2,打开文件浏览器。文件 -> 更改文件夹和搜索选项 -> “查看”选项卡 -> 把所有隐藏文件和文件夹的选项都去掉。

3,这时可以看到隐藏文件夹 C:\ProgramData\MySQL\MySQL Server 5.7 。在这个文件夹里面有个 my.ini 配置文件。MySQL 默认读取的是这个配置文件。

4,把 myini 拷贝到其他盘,比如D盘。

5,修改 D:\my.ini 并且保存。注意:event_scheduler = 1 #或者ON 应该放到 [mysqld] 这个配置段底下。可以先搜索一下这个参数,如果系统已经有了,直接更改数字即可。

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAL8AAAA0CAIAAABU/35KAAADOElEQVR4nO2d2XEkIRBE8Wn9Wz/Wj7VmTFgZwX4oNNGCyjporkb5Qh8NA1UJ5ECPWkf6+OL1ev3++y8T4ibRPaQZwz0ppeKCNJMurNbSB7pnEsUEnjGfP9Q984fzs9yTKhaq7M644Tjn7Yz51Pae6MaDZq2uvBY919E4UZGoWARXQnnm59ox1H5burkngZ0Z1efvSyK2R9eeOCG1un5TWyjvMdbJ49yD6pUF0BtE4+joqT15dbfp29IxBup53yM2VuLohquXJxpHl6pUOt0TnR9TwOPoed8T7Rt1TzSOR15dr+dtnhP/cB7E4vseZ7TmOGZ8cYdDNZ49yczobP8IeroHbeN1vbnno8poHFOwmfe9EYovhVI3S90WPuf6hsdP5M2Z7kkAswuKM1Lsg4m559ef7b7IQuznXNf333Kv1F/n3Uw8CO9T0k+We0XZe+ie+WzqHn8uJJVMYDv3eHJdGyCpZALbuce592S6ZwPoHtJOzD0i9XGDitfK4gyq65VDTQxO98wnvPfkLLz7leVH9fX+obtHiS9KJRPo5h7kmAzOoKzape6FGiCpZALD3VOcOHTPSfR0j3gGIRNkuuf5DHePUszZ20vJgqSSCTR+5rou4fsCrXrRsX5V3Evq9kp2RSoZR+enpJ42fTvyKelCuv2EhtnA7NvWnSzkzJ8OI3Oge0g7dA9ph+65xYa36jMlnememx/BPN03/KA3X9Ji94wb6s3Izu5buecTumd95OXuCf060RxJQi7FPbX0a7EeFWpvNvYvFeoixhfrRZ0ovqi56KLrrOWFhtzAuMhCLuQeNE31CpntPc1sob7fYzfzesblqUf6dZ0obEdOc49YLxY1oaCls34T94hSRVKFv6M/y01a/n7PewcuRIvte7mnSGFG0PdCv84G9+jzNppd3AP7APcojZ1FP2h1zUQ320f3HudLHdnRPdFZi86+OWYljngd1VMEMeuRbKfOcWzhngxOCkWieBwoxWulLRQcB55EqCgqSV87q9i9uNDjiBk9g21jTpZvGY/8XjOZw17uSYC1qghiL/eQZ0H3kHboHtJOn/+Rw5uVJ3J/mbq5R7w41UZnjOv+KP4DqSQNSzmlr0gAAAAASUVORK5CYII=" alt="" />

6,以管理员身份删除原来安装目录下的 my.ini 。

7,打开开始菜单,在命令行菜单项上,右键 -> 管理员运行。执行命令:

copy "D:\my.ini" "C:\ProgramData\MySQL\MySQL Server 5.7"

第七,打开 MySQL 服务。

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAbIAAABsCAIAAACAUqCgAAAM60lEQVR4nO2d28GkIAyFrcuCqMdqKOa3hC1i9sFbAgkELzNGz/ey/zoMhASPAXXo/i38/f11AAAAIIsAAMCALAIAAAOyCAAAjO/KYoiflXHoz66+H8bPJ4azq72MfhhNflD7dbE/a/Wn9p/s/6l1R/Hcy0G/hVj79tXjhLbyiHj9JlvshxGyeIIs0gLXDXe1/otlMXNPP4wffubVFcEDl8sibejAOKn43zqcHQBZdMBdZVEqdqb/+fneD+M49Nu/XRfi16J9qYd9yGLd/8+4SHUdZNEFb5XF7QTsOnISzn98URQhi53F/zxenqGyODltiNMCxJQxL39wB2zupasWzOPrB+MwxDQWSXh2DHCx3dnSJddnVm8Hl8P9MGbNFgObDartAK19a3bx3Grs8gG1nplQrGf9MDNRGu6kKtKEGq8iaf2K/XykhMiakO1pYIlXP4zjELLg5fUX4iXbI48f5jKr43Q/8xAv+Zc6bjW/kcEwLLKY+z/XLcs4kcdtxf8qq5CYSt+DVBYXd4xjnARxHPrMwev/tesUjY+04iAO2AbXKe3ytQ9iBLMhxPnvEIm2L38VbQhM4Imu9iH0W5mlELdHEP+sH8V6tqmLzZ9zzaT83lmOlmUk9ZFWuac0e3aY8fl8PnFIT0q9v0q8xPLq+GnNs1Q/y8tverua37LBsVMWLX7Yxq3u/xJPkMVFL5brwnY5Y5dZGpK8w9z7wohSBtl0dbLO1uR2yeFAr6LCnYHlNAlxjHGcO1yONs0wlcxSU2OJkkyl9fB1bl6rlM0Jfti9KN4mi3kartmzjzVdYQmdWL8SL6W8Nn4KHlAtFP2sXBHUdrV+cQ9y+1tk0eYHwdzE/4/DJovpqSVP/FhA9sji9m2Lu/N2BfkQzprtgymZ6IcxhumSWEkWWe+TfIhPtUQ5k7uafG6opyqLfJ6WzuNyv1VpkUXhyla2p5FJ3eYUZgpHoX4xXlp5bfwUPFA2tDw+eUlN5hQ7+RrUPlk0+iEzNvV/i1d8YJXF9e+QLRR26+fyNO+CbFFptzS8hGxxCuowZYghjkOoJYtzrbMfZKHSszyxrmx1olqPUGs5CxBpShwbJ9FZ8/vnzYIl49Bvmd96kqr11+LFKz9RFkmdcpZab7exfDbtb8sWtfqTjwT/Fz3gEbMszj4c6dUhDEIKthalSx/nri1q7arDSxubJDHth3EcTSEOcVrmJuMm7fsRWdTqUTq5Hst0KG9ZjVeNRlnMRVe2p5ntmpxkK6X6hXgp5Quy2OQu3c8skoZ2lX6ll8xcRudJx75xoo5b1f8l2s7te9Agi5MP9Ylj7u/paKhmi8LNiCJau6VhTScMYtpQ1TBmvTCLXStfk972SbRez/yIgJxOS7LFZ0hrXJV41XvcJItdnvoL9rTBjViqEwMsPAWeNSiUL40fXr48Top+Tmauy3lmazdfB5hzZXrNnKu13HIx+UH8cuZ/Fe+yWCu7c6l89/wDgBvDxc8qmW/E3wqkXRYPra5AFgF4Jx7Pf4ssLpfFnYLv0S0AgPeCHxYDAAAGZBEAABiQRQAAYEAWAQCAIcjiQx9cfyze4+XdfvA8IIvu8R4v7/aD52GUxeTR/PVzHP/tce/x0uwH4JdQWfwI+Ho4/U3IL1n4iZd3+8GDwSTaPd7j5d1+8Dwgi+7xHi/v9oPnAVl0j/d4ebcfPA88twgAAAzIIgAAMCCLAADAEGXxV6s91v1FSj+qLj8b92wui9eX/InVRXAvniWLtMCLTrTL43WxPyGL4F4ckEVJnFp3ZdkHZJFzebwgi+BVHMoWpY0vv/GaAmSRc3m8IIvgVRybRCfn2XaW8Xdg061r1yUrvkuc8PpXsR66+xm3q7LDmWkLR7oru7K9HOnsvDHfst2fvOPdVZeMq+JFGxA32l4rTbf/a+svZBHci4Nri+l+76twhdDnRfgmikKqkm8QWqqHbPZc3nCVn8j1vdy5nfS7oj39svlviJ9xjMsGpn3X2u5erooXbcAmi/v6C1kE9+LoLRcuDlJ6QM6U6i2V0paraT3iZs+kLD3CS1Q3dk3slMtvRqytZftrN7a7l6vixY5ZZHFnfyGL4F4cvhO9nAnpd/gPpIhyJleW3xSo1VOVxeRnraqPmwj1MxFI7FFlsbXdvVwVL9qARRb39heyCO7F8Qd0pvNsiMmiFZur7ZVFUz1CreVssYoqi7I91mzxMq6KF21AlcUT1gkgi+BenPDcIl/p67qOy1uI+7PFUj3sbkH5NGZftvZIk8XcHl0WG9vdy1XxYl+RLzNzkln68tn2A3A1ZzzOLSwZstuR06mz3KRtmkTr9cy3fuWJWuVO9P5JtGhP0GWxrd29XBUv9nF+C2vWQ/1ONCbRwCe3esvlu8g/D+3xB6K9x8u7/eBpvFgWn4P3eHm3HzwN/IIOAAAwIIsAAMCALAIAAAOyCAAADMgiAAAwBFnEfUFfeI+Xd/vB84Asusd7vLzbD56HURaTHwFQXuHA8W8f9x4vzX4AfgmVxY+Av1c+3oL8ko6feHm3HzwYTKLd4z1e3u0HzwOy6B7v8fJuP3gekEX3eI+Xd/vB88BziwAAwIAsAgAAA7IIAACMV//eYvXXwsvUd7ajD6Fc6FHv8fJuP3gakMUrZZE2BFlU8W4/eBp3l8VLBeWFskheN0l2/iM9CfG7j1XfaLwB0EEWXyWLrL9089Jpsk93foYsghdzXBbZpnHrkWyfOOn12GSr4e2TGDrx7bC6VexL8mZ120dyu2q/+OFp68F1R1RpO3nZAXr9Sz1rJ4ziZIyXtEXfttHrh6kkZBG8mIOyqOydHtjm7P0wSps6b+UXhRB2k27Ls9T8TdgDtNiu0i/6d79tVt0uixY/2MXJFq9sb/vNqhDnfVBbWz4HyCK4F8dkkZ9pyX7KRNkEVaHlE9GiutImi7L6CYogFme6oB4X9o9ulkWbH8zYZTHfhHtJzGPYrIQsgndzSBaTn4ui87BNF0nmqJVP1vj2yyJvZa1RW0PU2i3ZKd2oaJVFox9aenxCttitUYMsgndzZraYfTYOPT/FSlnbabJI6pSz1Hq7jeWzaX9btqjVb+aMtUUyo48RsghezcG1xRD1GwMhTrcl6Mdy+YIsNtzu7bowJNLD88WsHr1dpV/kC3PGl8rofPOitrZo8oOZPXei08sGc/iXf/cQsgjuxal3oj88Byrf57BNopPy9pdKspaTmWsMLe3m6wDj0CdrqUu17XeivzOJTlvlywFJxyGL4MXc/blFAflnnd/8w873jlcd7/aDp+FQFkGK93h5tx88DfyCDgAAMCCLAADAgCwCAAADsggAAAzIIgAAMARZxH1BX3iPl3f7wfOALLrHe7y82w+eh1EWk1dEpB9PxPEfHPceL81+AH4JlcWPwHtfHbk78ss+fuLl3X7wYDCJdo/3eHm3HzwPyKJ7vMfLu/3geUAW3eM9Xt7tB88Dzy0CAAADsggAAAzIIgAAMFzI4t4d8YDMd/wpbxThkRDTZy3Bs5FlcffGUtfgXhZf509BErfnFG1KqZVvreck3I9B0EAii+QZ23cPgZOE7J3+zDc2JO40eVYr31rPqXx/kxvwI7gs9n1xA9EXcc5J90p/Cq7ju37VN3PUyrfWczY3y/rBVciTaONpvFw+15wo3YWYHZ73Zk9rKLVDXxDLdzjemqifHOxVs2wTeVaN8Fba0VPB5M+Sf/g7xemW1Kn/Vf/s8Cc5OJhEQZCO5FBVXLTyrfV0TXHPj+eRhy6+g+OySOWEna/Z3vUhks2Ul79Mg0za+J3JbVP2kfaA7A0tzdZOwObPgn/6EPqtFJ1HSv6v+sfsz6wxUy9SXyfdrwZMK99aT3vcqyuI389QwQ84LotCOeGq/olhTYdCHGMc542aTWNMOo23BupDVTOU95PW8wtZtPmHnNEl/xf9Y/VnPmk15by3kcXWuNd7+KrlkPdyyiQ6Jf36Mu6mdKgfxhim1MaYLIqncfMa0zo7WssmP3dFJ02/kMWif/jUvpwnV/1j9GfiBHPOm9r0w0l01xL3I/MO8CQukUUlW5zSoWHKgEIch2BMFs+RRfLdbH5f68JBGvwp+ieb531PFluzRdFzN7jlYop7tYdYW3wHl8iiOganlGc55cbR+hsBB2UxDELquv5H/m6hUtILI9apl+Yfagwx+WpZzJbgzKMiLVZ6sEZatDznAZ32uAvPW9a6Bh4Il0Xpp0ELw6A06cjvRHddvoRv1JajshgLHdLuPLLjrHq7LDb6U/cPu226CtTlsshuRAdzdiZeBTZfCFPshvJqPbIdx+JechN4Li5e/rsd6z3jV9Ewaa1kXQ4JsXZJA88BstjOi5bdl+fRux250nOkEZL4NiCLoACbUUIYwEuALAIAAAOyCAAADMgiAAAwIIsAAMCALAIAAAOyCAAAlP+4mmJBtcumLAAAAABJRU5ErkJggg==" alt="" />

思考

  win8 限制只能用管理员权限对文件和文件夹做修改。因此用这个命令行来解决问题。同时 MySQL 默认读取 C:\ProgramData\MySQL\MySQL Server 5.7 下的 my.ini 配置文件,因此修改全局参数只能修改这个my.ini文件。

最新文章

  1. Sonar安装配置
  2. 内省(introspector)------>JavaBean
  3. JS与一般处理程序之间传值乱码
  4. Altium Designer 15 --- PCB 3D View
  5. 帝国CMS灵动标签e:loop
  6. LINUX下安装TeamViewer
  7. sharepoint 模糊搜索
  8. [LeetCode#253] Meeting Rooms II
  9. Krypton Factor 困难的串-Uva 129(回溯)
  10. 安装atlas后执行hive命令报错
  11. 一道B树的题目---先记一下, 还没看到B树
  12. Nginx+Keepalived双机热备
  13. 【运维】Dell R710如何做Raid0与Raid5
  14. How the heck does async/await work in Python 3.5
  15. 记hangfire后台任务运行一段时间后不运行了。
  16. core net 2 nuget的数据源包
  17. python递归、collections系列以及文件操作进阶
  18. codeforces 879c
  19. fedora下安装运行keil uVision 4 (MDK v4.7)
  20. Java基础十--接口

热门文章

  1. awk截取指定字段
  2. 自动化运维工具——ansible系列命令
  3. PHP实现消息推送
  4. JZOJ 4421. aplusb
  5. MTCNN学习进展
  6. Face The Right Way POJ - 3276 (开关问题)
  7. 6 json和ajax传递api数据
  8. React-表单操作
  9. Python框架之Django学习笔记(十一)
  10. 【POI 2010】反对称 Antisymmetry