复制根目录下的my-default.ini,改名为my.ini,my.ini用下面内容替换
#以下是复制内容,这行可不复制
[client]
port=3306
default-character-set=utf8
#客户端字符类型,与服务端一致就行,建议utf8
[mysqld]
port=3306
character_set_server=utf8
#服务端字符类型,建议utf8
basedir=D:\wamp\mysql
#解压根目录
datadir=D:\wamp\mysql\data
#解压根目录\data
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\wamp\mysql\bin\mysqld.exe
#解压根目录\bin\mysqld.exe
#以上是复制内容,这行可不复制
mysql 5.7.10重置root密码:
1.my.nin文件里在 [mysqld]下增加“skip-grant-tables”
2.cmd:net start mysql
->mysql
->use mysql;
->UPDATE user SET authentication_string=PASSWORD("NEWPASSWORD")WHERE User='root';
->FLUSH PRIVILEGES;
->quit;
3.登陆时,将my.min文件里的“skip-grant-tables”删除
登陆mysql -u用户 -p密码;
如果登陆进去报错1820,
登陆mysql -u -p 进去:输入mysql>SET PASSWORD = PASSWORD('123456');
创建用户:
create user hzx;
update user set authentication_string=password("123456") whereuser="hzx";
grant all on hzx.* to 'hzx'@'localhost';
create user text;
update user set authentication_string=password("123456") whereuser="text";
grant all on text.* to 'text'@'localhost';
3.刷新数据库 (一定要记得刷新)
mysql>flush privileges;
quit
mysql -uhzx -p
123456
成功!
遇到错误:
ERROR 1862 (HY000): Your password hasexpired. To log in you must
change it using a client that supports expired passwords.
原因是:
MySQL 5.6 introduces password-expirationcapability, to enable database administrators to expire account passwords andrequire users to reset their password.
所以只需重新修改下密码即可,修改方式如下:
以root权限登录mysql:(这里我的账户是root,密码也是root)
mysql -uroot -proot
然后更改密码:
SET PASSWORD = PASSWORD('root');
OK,可以正常使用了。