1.mysql官网下载压缩包;
2.解压到自己想要的目录下;
3.复制根目录下的my-default.ini,改名为my.ini,my.ini用下面内容替换;
#################################################
[client]
port=3306
default-character-set=utf8
[mysqld]
port=3306
character_set_server=utf8
bind-address = 0.0.0.0
#解压根目录
basedir = D:\mysql-5.7.17-winx64
#解压根目录\data
datadir = D:\mysql-5.7.17-winx64\data
default-storage-engine=INNODB
#无密码登录(修改密码用)
#skip-grant-tables
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[WinMySQLAdmin]
D:\mysql-5.7.17-winx64\bin\mysqld.exe
################################################
4.我的电脑->属性->高级->环境变量
选择PATH,在其后面添加: 你的mysql bin文件夹的路径 (如:D:\mysql-5.7.17-winx64\bin )
PATH=.......;D:\mysql-5.7.17-winx64\bin (注意是追加,不是覆盖);
5.在mysql-5.7.17-winx64.zip压缩包里是没有data目录,cmd进入mysql解压目录bin子目录下,执行mysqld -initialize,使data目录初始化;
6.输入服务安装命令:mysqld -install
启动MYSQL服务:net start mysql
停止MYSQL服务:net stop mysql
移出mysql服务(需要重新安装时):mysqld -remove
*忘记密码,修改密码(新版的mysql数据库下的user表中已经没有Password字段了,而是将加密后的用户密码存储于authentication_string字段)
编辑mysql配置文件my.ini,在[mysqld]这个条目下加入
skip-grant-tables
保存退出后cmd重启mysql
mysql> mysql -u root -p; 可以直接不输入密码进入执行下面更新密码
update mysql.user set authentication_string=password('psw123') where user='root' and Host = 'localhost';
mysql> flush privileges;
mysql> quit;
*navicat连接错误:Your password has expired. To log in you mustchange it using a client that supports expired passwords.
>net start mysql 启动mysql
>mysql -uroot -p命令行登录进去,然后执行select * from mysql.users;
会有如下信息:ERROR 1820 (HY000): You must SET PASSWORD before executing this statement.
mysql> SET PASSWORD = PASSWORD('psw123');
然后再select * from mysql.users;会结果了,navicat重新连接mysql也可以了。