Win7系统之家 - 专注分享最好的电脑系统软件!免费安全下载 Win7系统之家首页 | Win7激活工具 | 热门专题
Win7系统之家> > 系统教程 > Win10系统教程 >

Win10系统MySQL免安装版配置详解

更新时间:2026-08-21 17:49:16 | 编辑:罪名 | 信息来源:互联网
MySQL是提供安装版和免安装的绿色版的,那么MySQL免安装版下载到电脑上之后要如何配置呢?下面小编就和大家分享下Win10系统中MYSQL免安装版的配置过程。



步骤如下:

1、下载MySQL之后解压,然后把文件夹名改名mysql,小编是放在E:\pcy_development\Mysql\;


2、配置环境变量

找到–高级系统变量–环境变量–系统变量-- 找到path–编辑–在最后面加上 ;E:\pcy_development\bin (这是我的mysql的bin目录,请设置自己电脑上相应的目录); 然后确定保存;


3、检查mysql目录下有没有data目录;

如果有data目录,忽略下面操作

如果没有,win+r 打开运行,输入cmd进入命令窗;

进入mysql所在盘符。比如:d:

然后cd到mysql的bin目录,执行如下语句: mysqld --initialize-insecure --user=mysql ;data目录就生成成功了
如果报此错误:
mysqld: Could not create or access the registry key needed for the MySQL application
to log to the Windows EventLog. Run the application with sufficient
privileges once to create the key, add the key manually, or turn off
logging for that application.
请试下以管理员身份运行:


同样cd到mysql的bin目录,执行如下语句: mysqld --initialize-insecure --user=mysql ;data目录就生成了。


4、配置mysql目录内的 my.ini (没有就新建个)
basedir = E:\pcy_development\mysql
datadir = E:\pcy_development\mysql\data
port = 3306

注意:basedir 和datadir是我本地mysql的目录,请设置自己电脑上相应的目录;

注意:新建一个my.ini文件请注意把.txt改为.ini如果看不到.txt后缀,请点击查看把文件扩展名勾选上

然后在里面填入:
[mysqld]
character-set-server=utf8
bind-address = 0.0.0.0
port = 3306
basedir=E:\pcy_development\mysql
datadir=E:\pcy_development\mysql\data
max_connections=2000
default-storage-engine=INNODB
[mysql]
default-character-set=utf8
[mysql.server]
default-character-set=utf8
[client]
default-character-set=utf8

5、安装;

在bin目录下,继续输入:mysqld --install

提示service successfully installed安装成功;


7,停止和启动mysql

启动:net start mysql

停止:net stop mysql


8,进入mysql以及修改密码

在mysql目录下,编辑 my.ini

在[mysqld]下添加一行 skip-grant-tables 暂时取消密码;

1,重启mysql,;注意是重启MySQL不是开启mysql,关掉mysql再开启MySQL叫重启。

2,输入 mysql -uroot -p 按回车,如果提示输入密码,直接回车即可;

, 3,登陆成功后,输入 update mysql.user set authentication_string=password(‘123456’) where user=‘root’ and Host = ‘localhost’; 将密码先修改为123456;

4,输入 flush privileges; 刷新保存;注意进入MySQL后每个命令后面要加上分号;

5,删除 my.ini 中刚刚添加的 skip-grant-tables 保存;

6,exit;或quit; 退出mysql;

7,重启mysql;

8,使用新密码登陆: mysql -uroot -p123456 回车即可登陆成功;


好了,以上就是Win10系统下mysql所有配置过程了。大家学会了吗。
返回顶部


Win7系统之家发布的系统镜像及软件均来至互联网,仅供学习和研究使用,不得用于任何商业用途并请在下载后24小时内删除,如果满意请联系版权方购买。
如果您发现本站侵害了您的版权,请立即联系我们,本站将第一时间进行相关处理。投诉邮箱1524578900@qq.com
版权声明|联系我们 Copyright © Win7系统之家 All Rights Reserved 鲁ICP备2021038877号-4

1.1589
基本信息
SQL
$_GET
$_POST
$_COOKIE
包含文件
自动加载
  1. 模型: /www/wwwroot/www.pjwan.com/lecms/model/
  2. 视图: /www/wwwroot/www.pjwan.com/view/ww7/w10_show.htm
  3. 控制器: /www/wwwroot/www.pjwan.com/lecms/control/show_control.class.php
  4. 日志目录: /www/wwwroot/www.pjwan.com/log/
  5. 当前页面: /www/wwwroot/www.pjwan.com/index.php
  6. 当前时间: 2026-08-21 17:49:15
  7. 当前网协: 216.73.216.186
  8. 请求路径: /win10jc/18571.html
  9. 运行时间: 1.1589
  10. 内存开销: 1.32 MB
  1. #0 [time:0.0003s] SELECT * FROM le_runtime WHERE k='cfg' LIMIT 1
  2. #1 [time:0.0003s] SELECT * FROM le_runtime WHERE k='cate_127' LIMIT 1
  3. #2 [time:0.0003s] SELECT * FROM le_cms_article WHERE id=18571 LIMIT 1
  4. #3 [time:0.0003s] SELECT * FROM le_user WHERE uid=2 LIMIT 1
  5. #4 [time:0.0002s] SELECT * FROM le_cms_article_data WHERE id=18571 LIMIT 1
  6. #5 [time:0.0002s] SELECT * FROM le_cms_article_views WHERE id=18571 LIMIT 1
  7. #6 [time:0.0003s] UPDATE LOW_PRIORITY le_cms_article_views SET views=views+1 WHERE id=18571 LIMIT 1
  8. #7 [time:0.0002s] SELECT id FROM le_cms_article WHERE id<18571 ORDER BY id DESC LIMIT 0,1
  9. #8 [time:0.0002s] SELECT * FROM le_cms_article WHERE id=18570
  10. #9 [time:0.0002s] SELECT id FROM le_cms_article WHERE id>18571 ORDER BY id ASC LIMIT 0,1
  11. #10 [time:0.0002s] SELECT * FROM le_cms_article WHERE id=18572
  12. #11 [time:0.0002s] SELECT * FROM le_kv WHERE k='navigate' LIMIT 1
  13. #12 [time:0.0003s] SELECT tagid,id FROM le_cms_article_tag_data WHERE tagid=61 ORDER BY id DESC LIMIT 0,11
  14. #13 [time:0.0005s] SELECT * FROM le_cms_article_tag_data WHERE tagid=61 AND id=99752 OR tagid=61 AND id=99733 OR tagid=61 AND id=97767 OR tagid=61 AND id=97078 OR tagid=61 AND id=97056 OR tagid=61 AND id=97030 OR tagid=61 AND id=96806 OR tagid=61 AND id=96804 OR tagid=61 AND id=96785 OR tagid=61 AND id=96140 OR tagid=61 AND id=95765
  15. #14 [time:0.0006s] SELECT * FROM le_cms_article WHERE id=99752 OR id=99733 OR id=97767 OR id=97078 OR id=97056 OR id=97030 OR id=96806 OR id=96804 OR id=96785 OR id=96140
  16. #15 [time:0.0004s] SELECT cid FROM le_category ORDER BY orderby ASC ,cid ASC
  17. #16 [time:0.0021s] SELECT * FROM le_category WHERE cid=1 OR cid=2 OR cid=3 OR cid=4 OR cid=5 OR cid=6 OR cid=7 OR cid=8 OR cid=9 OR cid=10 OR cid=11 OR cid=12 OR cid=13 OR cid=14 OR cid=15 OR cid=16 OR cid=17 OR cid=18 OR cid=19 OR cid=20 OR cid=21 OR cid=22 OR cid=23 OR cid=24 OR cid=25 OR cid=26 OR cid=27 OR cid=28 OR cid=29 OR cid=30 OR cid=31 OR cid=32 OR cid=33 OR cid=34 OR cid=35 OR cid=36 OR cid=37 OR cid=38 OR cid=39 OR cid=40 OR cid=41 OR cid=42 OR cid=43 OR cid=44 OR cid=45 OR cid=46 OR cid=47 OR cid=48 OR cid=49 OR cid=50 OR cid=51 OR cid=52 OR cid=53 OR cid=54 OR cid=55 OR cid=56 OR cid=57 OR cid=58 OR cid=59 OR cid=60 OR cid=61 OR cid=62 OR cid=63 OR cid=64 OR cid=65 OR cid=66 OR cid=67 OR cid=68 OR cid=69 OR cid=70 OR cid=71 OR cid=72 OR cid=73 OR cid=74 OR cid=75 OR cid=76 OR cid=77 OR cid=78 OR cid=79 OR cid=80 OR cid=81 OR cid=82 OR cid=83 OR cid=84 OR cid=85 OR cid=86 OR cid=87 OR cid=88 OR cid=89 OR cid=90 OR cid=91 OR cid=92 OR cid=93 OR cid=94 OR cid=95 OR cid=96 OR cid=97 OR cid=98 OR cid=99 OR cid=100 OR cid=101 OR cid=102 OR cid=103 OR cid=104 OR cid=105 OR cid=106 OR cid=107 OR cid=108 OR cid=109 OR cid=110 OR cid=111 OR cid=112 OR cid=113 OR cid=114 OR cid=115 OR cid=116 OR cid=117 OR cid=118 OR cid=119 OR cid=120 OR cid=121 OR cid=122 OR cid=123 OR cid=124 OR cid=125 OR cid=126 OR cid=127 OR cid=128
  18. #17 [time:0.0003s] SELECT id FROM le_cms_article_views WHERE cid=127 ORDER BY views DESC LIMIT 0,10
  19. #18 [time:0.0003s] SELECT * FROM le_cms_article_views WHERE id=20203 OR id=46928 OR id=46933 OR id=46920 OR id=46931 OR id=46927 OR id=46925 OR id=46926 OR id=45860 OR id=45636
  20. #19 [time:0.0006s] SELECT * FROM le_cms_article WHERE id=20203 OR id=46928 OR id=46933 OR id=46920 OR id=46931 OR id=46927 OR id=46925 OR id=46926 OR id=45860 OR id=45636
  21. #20 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cate_85' LIMIT 1
  22. #21 [time:0.0006s] SELECT id FROM le_cms_win WHERE (cid=86 OR cid=87 OR cid=88 OR cid=89 OR cid=90 OR cid=91 OR cid=92 OR cid=93 OR cid=94 OR cid=95 OR cid=96 OR cid=97 OR cid=98 OR cid=99 OR cid=100) ORDER BY id DESC LIMIT 0,10
  23. #22 [time:0.0006s] SELECT * FROM le_cms_win WHERE id=1027 OR id=1026 OR id=1025 OR id=1024 OR id=1023 OR id=1022 OR id=1021 OR id=1020 OR id=1019 OR id=1018
  24. #23 [time:0.0002s] SELECT * FROM le_runtime WHERE k='cate_64' LIMIT 1
  25. #24 [time:0.0006s] SELECT id FROM le_cms_article WHERE (cid=65 OR cid=66 OR cid=67 OR cid=68 OR cid=125 OR cid=126 OR cid=127 OR cid=128) ORDER BY id DESC LIMIT 0,10
  26. #25 [time:0.0006s] SELECT * FROM le_cms_article WHERE id=103563 OR id=103562 OR id=103561 OR id=103560 OR id=103559 OR id=103558 OR id=103557 OR id=103556 OR id=103555 OR id=103554
  1. #control => show
  2. #action => index
  3. #cid => 127
  4. #id => 18571
  5. #mid => 2
    1. #acw_tc => 0819529a17873057531966654e9df936f5495c7a85cd7b88f3b09825e8
    2. #cdn_sec_tc => 0819529a17873057531966654e9df936f5495c7a85cd7b88f3b09825e8
    3. #PHPSESSID => j3uh0cf561husabqqk1qunobil
    1. #0 /www/wwwroot/www.pjwan.com/index.php
    2. #1 /www/wwwroot/www.pjwan.com/lecms/xiunophp/xiunophp.php
    3. #2 /www/wwwroot/www.pjwan.com/lecms/config/config.inc.php
    4. #3 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/base.func.php
    5. #4 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/core.class.php
    6. #5 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/debug.class.php
    7. #6 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/log.class.php
    8. #7 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/model.class.php
    9. #8 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/view.class.php
    10. #9 /www/wwwroot/www.pjwan.com/lecms/xiunophp/lib/control.class.php
    11. #10 /www/wwwroot/www.pjwan.com/lecms/xiunophp/db/db.interface.php
    12. #11 /www/wwwroot/www.pjwan.com/lecms/xiunophp/db/db_pdo_mysql.class.php
    13. #12 /www/wwwroot/www.pjwan.com/lecms/xiunophp/cache/cache.interface.php
    14. #13 /www/wwwroot/www.pjwan.com/lecms/xiunophp/cache/cache_memcache.class.php
    15. #14 /www/wwwroot/www.pjwan.com/lecms/xiunophp/ext/network/Network__interface.php
    16. #15 /www/wwwroot/www.pjwan.com/lecms/config/plugin.inc.php
    17. #16 /www/wwwroot/www.pjwan.com/lecms/plugin/editor_sd/conf.php
    18. #17 /www/wwwroot/www.pjwan.com/lecms/plugin/editor_tinymce/conf.php
    19. #18 /www/wwwroot/www.pjwan.com/lecms/plugin/editor_um/conf.php
    20. #19 /www/wwwroot/www.pjwan.com/lecms/plugin/le_adminer/conf.php
    21. #20 /www/wwwroot/www.pjwan.com/lecms/plugin/le_baidu_zz/conf.php
    22. #21 /www/wwwroot/www.pjwan.com/lecms/plugin/le_category_filter/conf.php
    23. #22 /www/wwwroot/www.pjwan.com/lecms/plugin/le_content_tag_url/conf.php
    24. #23 /www/wwwroot/www.pjwan.com/lecms/plugin/le_data_table_split/conf.php
    25. #24 /www/wwwroot/www.pjwan.com/lecms/plugin/le_drafts/conf.php
    26. #25 /www/wwwroot/www.pjwan.com/lecms/plugin/le_feedback/conf.php
    27. #26 /www/wwwroot/www.pjwan.com/lecms/plugin/le_homepage_feign/conf.php
    28. #27 /www/wwwroot/www.pjwan.com/lecms/plugin/le_html_cache/conf.php
    29. #28 /www/wwwroot/www.pjwan.com/lecms/plugin/le_links/conf.php
    30. #29 /www/wwwroot/www.pjwan.com/lecms/plugin/le_minganci_do/conf.php
    31. #30 /www/wwwroot/www.pjwan.com/lecms/plugin/le_rand404content/conf.php
    32. #31 /www/wwwroot/www.pjwan.com/lecms/plugin/le_rand_author/conf.php
    33. #32 /www/wwwroot/www.pjwan.com/lecms/plugin/le_rand_pic_cid/conf.php
    34. #33 /www/wwwroot/www.pjwan.com/lecms/plugin/le_sharejs/conf.php
    35. #34 /www/wwwroot/www.pjwan.com/lecms/plugin/le_slide/conf.php
    36. #35 /www/wwwroot/www.pjwan.com/lecms/plugin/le_special_pro/conf.php
    37. #36 /www/wwwroot/www.pjwan.com/lecms/plugin/le_spider/conf.php
    38. #37 /www/wwwroot/www.pjwan.com/lecms/plugin/le_super_sitemap/conf.php
    39. #38 /www/wwwroot/www.pjwan.com/lecms/plugin/le_title_pic/conf.php
    40. #39 /www/wwwroot/www.pjwan.com/lecms/plugin/le_use_del_id/conf.php
    41. #40 /www/wwwroot/www.pjwan.com/lecms/plugin/le_webp_oss/conf.php
    42. #41 /www/wwwroot/www.pjwan.com/lecms/plugin/le_website_group/conf.php
    43. #42 /www/wwwroot/www.pjwan.com/lecms/plugin/le_zhanqunsitemaps_pro_v303/conf.php
    44. #43 /www/wwwroot/www.pjwan.com/lecms/plugin/lu_huochetou/conf.php
    45. #44 /www/wwwroot/www.pjwan.com/lecms/plugin/models_filed/conf.php
    46. #45 /www/wwwroot/www.pjwan.com/lecms/plugin/qrcode/conf.php
    47. #46 /www/wwwroot/www.pjwan.com/lecms/plugin/sy_mobile/conf.php
    48. #47 /www/wwwroot/www.pjwan.com/runcache/misc.func.php
    49. #48 /www/wwwroot/www.pjwan.com/runcache/core_lang/zh-cn.php
    50. #49 /www/wwwroot/www.pjwan.com/runcache/lang/zh-cn.php
    51. #50 /www/wwwroot/www.pjwan.com/runcache/lecms_control/parseurl_control.class.php
    52. #51 /www/wwwroot/www.pjwan.com/runcache/lecms_model/runtime_model.class.php
    53. #52 /www/wwwroot/www.pjwan.com/runcache/lecms_control/show_control.class.php
    54. #53 /www/wwwroot/www.pjwan.com/runcache/lecms_control/base_control.class.php
    55. #54 /www/wwwroot/www.pjwan.com/runcache/lecms_model/urls_model.class.php
    56. #55 /www/wwwroot/www.pjwan.com/runcache/lecms_model/category_model.class.php
    57. #56 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_model.class.php
    58. #57 /www/wwwroot/www.pjwan.com/runcache/lecms_view/ww7,w10_show.htm.php
    59. #58 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_data_model.class.php
    60. #59 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_tag_model.class.php
    61. #60 /www/wwwroot/www.pjwan.com/runcache/lecms_model/user_model.class.php
    62. #61 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_views_model.class.php
    63. #62 /www/wwwroot/www.pjwan.com/runcache/lecms_model/kv_model.class.php
    64. #63 /www/wwwroot/www.pjwan.com/runcache/lecms_model/cms_content_tag_data_model.class.php
    65. #64 /www/wwwroot/www.pjwan.com/lecms/xiunophp/tpl/sys_trace.php