1.cmd下关闭数据库
运行->cmd -> 输入net stop MySQL
2.在c盘下,建立文件mysql-init.txt内容如下
[sql] view plain copy
- UPDATE mysql.user SET Password=PASSWORD('root') WHERE User='root';
- FLUSH PRIVILEGES;
3.cmd下找到mysql的配置路径下的bin目录执行命令格式如下 请将%myInfoDir% 替换为mysql配置文件的路径
[plain] view plain copy
- mysqld.exe --defaults-file="%myInfoDir%/my.ini" --init-file=C:/mysql-init.txt --console
样例如下:
[html] view plain copy
- mysqld.exe --defaults-file="C:/Program Files/MySQL/MySQL Server 5.5/my.ini" --init-file=C:/mysql-init.txt --console
4.当命令行窗口出现"Version: '5.5.*' socket: '' port: 3306 MySQL Community Server (GPL)"信息时,关闭命令行窗口
一键更改密码的bat如下:
[plain] view plain copy
- @echo off
- @rem 官方教程:http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html
- net stop mysql
- @rem 得到mysql的bin目录
- set /P mysql_path=请输入你的mysql的bin目录(如 C:/Program Files/MySQL/MySQL Server 5.5/bin):
- if /i "%mysql_path%"=="" set mysql_path=C:/Program Files/MySQL/MySQL Server 5.5/bin
- @rem 得到mysql安装到的盘符
- set rootDir=%mysql_path:~0,1%
- @rem 得到bin目录上层目录,用于读取my.ini
- set myInfoDir=%mysql_path:~0, -4%
- echo UPDATE mysql.user SET Password=PASSWORD('123') WHERE User='root'; > C:/mysql-init.txt
- echo FLUSH PRIVILEGES; >> C:/mysql-init.txt
- @rem 进入mysql bin目录
- cd "%mysql_path%"
- %rootDir%:
- echo --------------
- echo --------------
- echo mysql密码更改为123,请重启mysql服务(cmd下输入 net start mysql)
- echo ------------------
- echo --------------
- @rem --console 指示将信息输出到控制台,而不是日志文件
- mysqld.exe --defaults-file="%myInfoDir%/my.ini" --init-file=C:/mysql-init.txt --console
- pause
执行完毕请重启mysql服务,默认密码为123
修复 table error crashed 的bat 代码
[plain] view plain copy
- net stop mysql
- D:
- cd D:\Program Files (x86)\MySQL\MySQL Server 5.5\bin
- set datadir="D:/Data/MySQL/MySQL Server 5.5/data/netinnet_exam/*.MYI"
- myisamchk.exe -e %datadir%
- myisamchk.exe -r %datadir%
- net start mysql