1.下载mysql,下载地址:https://downloads.mysql.com/archives/community/
2.cmd进入bin目录下,执行 mysqld --initialize-insecure
3.然后执行 mysqld -install
4.启动服务net start mysql
5.登录数据库 mysql -uroot
6.设置密码SET PASSWORD FOR 'root'@'localhost' = PASSWORD('123456');
错误记录:
1.
D:\software\mysql\mysql-5.7.17-winx64\mysql-5.7.17-winx64\bin>mysqld --initialize
2017-12-13T07:08:35.613357Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-12-13T07:08:35.615357Z 0 [ERROR] -- --initialize specified but the data directory has files in it. Aborting..
2017-12-13T07:08:35.616357Z 0 [ERROR] Aborting
原因:data文件夹已经存在
解决:删除data文件夹
2.Navicat连接数据库
Can't connect to MySQL server on 'localhost'(10038)
原因:Mysql服务未启动
解决:启动Mysql服务
3.Navicat连接数据库
ERROR 1130: Host ‘192.168.1.3’ is not allowed to connect to this MySQL server
ERROR 1130: Host ‘192.168.1.3’ is not allowed to connect to this MySQL server
原因:帐号不允许从远程登陆,只能在localhost。
解决:在localhost的那台电脑,登入mysql后,更改 “mysql” 数据库里的 “user” 表里的 “host” 项,从"localhost"改称"%"
mysql -u root -p
mysql>use mysql;
mysql>update user set host = ‘%’ where user = ‘root’;
mysql>select host, user from user;