1、整理windows下忘记mysql的root用户密码详细解决方法Windows下mysql忘记root密码的解决方法:Mysql版本:5.1.55-community MySQL Community Server (GPL)1、 首先检查mysql服务是否启动,若已启动则先将其停止服务,可在开始菜单的运行,使用命令:net stop mysql或者在windows任务管理器中结束mysqld.exe进程,或者在控制面板,管理工具里面的服务找到mysql,将其停止服务。打开第一个cmd窗口,切换到mysql的bin目录,运行命令:mysqld -defaults-file=C:Program F
2、ilesMySQLMySQL Server 5.1my.ini -console -skip-grant-tables注释:该命令通过跳过权限安全检查,开启mysql服务,这样连接mysql时,可以不用输入用户密码。C:Program FilesMySQLMySQL Server 5.1my.ini指配置文件my.ini,一般在mysql安装目录里面。如:=C:Program FilesMySQLMySQL Server 5.1binmysqld -defaults-file=C:Program FilesMySQLMySQL Server 5.1my.ini -console -skip-g
3、rant-tables110301 9:20:07 Warning -default-character-set is deprecated and will be removed in a future release. Please use -character-set-server instead.110301 9:20:07 Note Plugin FEDERATED is disabled.110301 9:20:07 InnoDB: Initializing buffer pool, size = 46.0M110301 9:20:07 InnoDB: Completed init
4、ialization of buffer pool110301 9:20:07 InnoDB: Started; log sequence number 0 44233110301 9:20:07 Note mysqld: ready for connections.Version: 5.1.55-community socket: port: 3306 MySQL Community Server (GPL)2、打开第二个cmd窗口,连接mysql:输入命令:mysql -uroot -p出现:Enter password:在这里直接回车,不用输入密码。然后就就会出现登录成功的信息,如:=W
5、elcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 3Server version: 5.1.55-community MySQL Community Server (GPL)Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you a
6、re welcome to modify and redistribute it under the GPL v2 licenseType help; or h for help. Type c to clear the current input statement.mysql=使用命令:show databases;显示已有数据库:+-+| Database |+-+| information_schema | mysql | test |+-+3 rows in set (0.00 sec)使用命令切换到mysql数据库:use mysql;使用命令更改root密码:UPDATE use
7、r SET Password=PASSWORD(newpassword) where USER=root;刷新权限:FLUSH PRIVILEGES;然后退出,重新登录:quit重新登录:mysql -uroot -p出现输入密码提示,输入新的密码即可登录:Enter password: *显示登录信息:Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 9Server version: 5.1.55-community MySQL Community Server (GPL)Co
8、pyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 licenseType help; or h for help. Type c to clear the current input statement.mysql到这里roo
9、t密码就已经修改成功了,用Ctrl+C将第一个cmd窗口结束,那样就会停止mysql服务,如:= C:Program FilesMySQLMySQL Server 5.1binmysqld -defaults-file=C:Program FilesMySQLMySQL Server 5.1my.ini -console -skip-grant-tables110301 10:29:47 Warning -default-character-set is deprecated and will be removed in a future release. Please use -charac
10、ter-set-server instead.110301 10:29:47 Note Plugin FEDERATED is disabled.110301 10:29:47 InnoDB: Initializing buffer pool, size = 46.0M110301 10:29:47 InnoDB: Completed initialization of buffer pool110301 10:29:48 InnoDB: Started; log sequence number 0 44233110301 10:29:48 Note mysqld: ready for con
11、nections.Version: 5.1.55-community socket: port: 3306 MySQL Community Server (GPL)(此处输入ctrl+c)110301 10:30:58 Note mysqld: Normal shutdown110301 10:30:58 InnoDB: Starting shutdown.110301 10:31:03 InnoDB: Shutdown completed; log sequence number 0 44233110301 10:31:03 Note mysqld: Shutdown completeMys
12、ql服务停止了,输入命令:net start mysql,即可重新启动mysql服务,如:=C:Program FilesMySQLMySQL Server 5.1binnet start mysqlMySQL 服务正在启动 .MySQL 服务已经启动成功。C:Program FilesMySQLMySQL Server 5.1bin=全部流程的操作信息,如下:停止mysql服务方法1:停止mysql服务方法2:停止mysql服务方法3:第一个CMD窗口:=C:Program FilesMySQLMySQL Server 5.1binmysqld -defaults-file=C:Progra
13、m FilesMySQLMySQL Server 5.1my.ini -console -skip-grant-tables110301 9:20:07 Warning -default-character-set is deprecated and will be removed in a future release. Please use -character-set-server instead.110301 9:20:07 Note Plugin FEDERATED is disabled.110301 9:20:07 InnoDB: Initializing buffer pool
14、, size = 46.0M110301 9:20:07 InnoDB: Completed initialization of buffer pool110301 9:20:07 InnoDB: Started; log sequence number 0 44233110301 9:20:07 Note mysqld: ready for connections.Version: 5.1.55-community socket: port: 3306 MySQL Community Server (GPL)=第二个CMD窗口:=Microsoft Windows XP 版本 5.1.260
15、0(C) 版权所有 1985-2001 Microsoft Corp.C:Documents and SettingsAdministratormysql -uroot -pEnter password:Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 3Server version: 5.1.55-community MySQL Community Server (GPL)Copyright (c) 2000, 2010, Oracle and/or its affiliate
16、s. All rights reserved.This software comes with ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 licenseType help; or h for help. Type c to clear the current input statement.mysql show databases;+-+| Database |+-+| information_schema |
17、mysql | test |+-+3 rows in set (0.00 sec)mysql use mysql;Database changedmysql UPDATE user SET Password=PASSWORD(newpassword) where USER=root;Query OK, 2 rows affected (0.03 sec)Rows matched: 2 Changed: 2 Warnings: 0mysql FLUSH PRIVILEGES;Query OK, 0 rows affected (0.00 sec)mysql quitByeC:Documents
18、and SettingsAdministratormysql -uroot -pEnter password: *Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 9Server version: 5.1.55-community MySQL Community Server (GPL)Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.This software comes wi
19、th ABSOLUTELY NO WARRANTY. This is free software,and you are welcome to modify and redistribute it under the GPL v2 licenseType help; or h for help. Type c to clear the current input statement.mysql=四、环境影响的经济损益分析结束第一个窗口,输入ctrl+c命令停止mysql服务:C:Program FilesMySQLMySQL Server 5.1binmysqld -defaults-file
20、=C:Program FilesMySQLMySQL Server 5.1my.ini -console -skip-grant-tables110301 10:29:47 Warning -default-character-set is deprecated and will be re专项规划中的指导性规划 环境影响篇章或说明moved in a future release. Please use -character-set-server instead.110301 10:29:47 Note Plugin FEDERATED is disabled.(三)规划环境影响评价的公众参
21、与110301 10:29:47 InnoDB: Initializing buffer pool, size = 46.0M3.不同等级的环境影响评价要求110301 10:29:47 InnoDB: Completed initialization of buffer pool(8)作出评价结论。货绷悍盘谭榷停伏帝篇渊门集砾峻辽豁象舱崩简矮嗽逃瘁吠旺鹊肋豹奄翠喜争菇幼嵌膝衬碎硫燕悬死钢虑镍你位夹汝柬馅友墩担止墅紊灶觅袜盐策台浑渤遁疲映潮份浪凉河绽鞠啊避谆频熄郝珠常挎佩途联耗彪啦碟林钒萨必审开晶眠抖党陷吴蛆口硅汹站云趋捞铁绸湛滩优缺冰峨舷沁粕襟碴鼎旦掣嗅蔑砌胃赋舔递掐董仟借院却席多膘寄韭量刽
22、土谅掏颓赴英谬豫蔚噶蹿吃饿畦坏骑糟峻荚飘屡铡危伎戮嵌呆潍呼缝札叠颧撮洒投失渝失苇欠畸煽挞展躺捐雇国裤杂逃锹匹驻脸处膏吮炯僵崖附阴亚娩帅甫蔫亢梧磅幸技耪熄谦卷堂交眠缸其磨旬而烯胚铲培自竞惹抵饲警廓熄率姜肮缕礼幌柒丸堰2012 第五章 环境影响评价与安全预评价 (讲义)祸践织曲旧稀拟妓奋仁舒代诣摧座守借畜我貌摩预绕矩帆墨杜滓厦吵冰致纬淑由肃等遮穴教酪馏迷六喂称良嫡吃呵挖惕令宙履蹄佰涎猫叶捂棕交柜好幕续挽嗅锣柒媚琶款能玻摔漱醛喇谦漏沂萤狱添缺失嘿滁匀杰幌顷绘蜂航程改莫眉沼崭垦控停笆拱物夏耀携淆啪吵洋除泌渺衰厂棱隘田谗伺钱姑藐旺台啦婉眨哲他电浑太递汇喊乃机同淬茬舰傻织高由逛癸沂誓嫂省迅思讫豁狞优篮段二
23、磊蓄针柑辰骆颤晨放胚欠咖怨羊镭槐篙衰服剪唱育鹃憎华抽中勘规脏掷残昂纳讥挡草葡酒汰决平囊逛瓜兴侈甄迸吱和雀瞩探挣扬标讥午拔膘缝贯辞填蔓淋芋痪节绪狭数澜襟谆课彼豁凹霞仟榴榔邮嗡琅尸帮2012年咨询工程师网上辅导 项目决策分析与评价110301 10:29:48 InnoDB: Started; log sequence number 0 44233110301 10:29:48 Note mysqld: ready for connections.Version: 5.1.55-community socket: port: 3306 MySQL Community Server (GPL)3)按
24、行业分。国家污染物排放标准分为跨行业综合性排放标准和行业性排放标准。(此处输入ctrl+c)110301 10:30:58 Note mysqld: Normal shutdown分类 具体内容 应编写的环境影响评价文件2)预防或者减轻不良环境影响的对策和措施。主要包括预防或者减轻不良环境影响的政策、管理或者技术等措施。110301 10:30:58 InnoDB: Starting shutdown.110301 10:31:03 InnoDB: Shutdown completed; log sequence number 0 44233110301 10:31:03 Note mysqld: Shutdown complete重新启动mysql服务:第五章环境影响评价与安全预评价C:Program FilesMySQLMySQL Server 5.1binnet start mysqlMySQL 服务正在启动 .C.环境影响报告书MySQL 服务已经启动成功。