mysql下载安装配置 5.7.26

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;