MySQL5.7Windows安装

下载解压后cmd进入bin目录
mysqld -install
mysqld --initialize
net start mysql
mysql -uroot -p


第一次通过命令行窗口登录MySQL5.7时出现
ERROR 1045 (28000): Access denied for user 'root'@'localhost'（密码错误）

方法一：

到data目录下找到.err文件打开里面有一个随机生成的密码temporary password

5.7以前的用这种方法修改：UPDATE user SET password=PASSWORD('newpassword') WHERE user='root';

SET PASSWORD = PASSWORD('你的新密码');

方法二：

在bin目录下mysqld --skip-grant-tables

mysql -uroot -p回车就登陆上了然后修改密码。。

5.7以后的用这种方法修改：update user set authentication_string=password("root") where user="root";

方法三：

编辑配置文件
加入参数skip-grant-tables

[root@postgredb etc]# vi my.cnf

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[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
#
# 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
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-grant-tables*********************加上这一行****************
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

之后mysql -uroot -p回车就登陆上了然后修改密码。。