新版MySQL修改密码问题

转http://blog.csdn.net/u013066244/article/details/53008869

修改密码

登录成功后，我想修改密码，使用命令：

update user set password=password('root') where user='root'; 
1

结果总是提示Unknown column 'password' in 'field list'

原来新版本没有password这个字段了，改成authentication_string

把命令改成

update user set authentication_string=password('root') where user='root'; 
1

就可以啦

再一次重启后出现如下问题

Your password has expired. To log in you must change it using a client that supports expired passwords

解决办法：
进行MySQL的bin打开cmd

mysqladmin -uroot -p password

在Enter password：root，这里root是我的密码，也就是通过上面update更新密码。
New password:输入新密码
confirm password：输入确认密码。

这里讲个小知识：在my.ini配置文件中最后加上skip-grant-tables，可以是登录MySQL时，不进行权限认证。（要是没有my.ini，请拷贝my-default.ini，并改名字为my.ini）.
my.ini的配置信息：

[mysqld]# Remove leading # and set to the amount of RAM for the most important data# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.# innodb_buffer_pool_size = 128M# Remove leading # to turn on a very important data integrity option: logging# changes to the binary log between backups.# log_bin# These are commonly set, remove the # and set as required. basedir = D:\Program Files\mysql-5.7.16-winx64 datadir = D:\Program Files\mysql-5.7.16-winx64\data port = 3306 max_connections=200 bind-address = 0.0.0.0# server_id = .....# Remove leading # to set options mainly useful for reporting servers.# The server defaults are faster for transactions and fast SELECTs.# Adjust sizes as needed, experiment to find the optimal values.# join_buffer_size = 128M# sort_buffer_size = 2M# read_rnd_buffer_size = 2M sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES #skip-grant-tables
1

这篇讲解了MySQL ERROR 1045 (28000): Access denied for user ‘root’@’localhost’
(using password: NO)的真正原因。不过是在Linux环境中。

http://www.cnblogs.com/kerrycode/p/4368312.html