本文mysql的安装环境为win7 64位，mysql版本为MySQL5.7
问题描述：在命令行输入 mysql -u root -p 登录mysql，返回”Can't connect to MySQL server on localhost (10061)”错误
问题原因：在一番谷歌后，查到问题原因是mysql没有启动。
解决方法：1、将mysql加入到Windows的服务中。切换到mysql安装目录下的bin文件夹，命令行运行"mysqld --install"
C:\Program Files\MySQL\MySQL Server 5.7\bin> mysqld --install
Service successfully installed.
此时若使用“net start mysql”成功启动msyql，则无须执行下面步骤
2、初始化mysql数据库，输入“mysqld --initialize --user=root --console”。下面红色文字为初始化后的root 密码
C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --initialize --user=root --console
--29T01::.309833Z [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see doc
umentation for more details).
--29T01::.659968Z [Warning] InnoDB: New log files created, LSN= --29T01::.154996Z [Warning] InnoDB: Creating foreign key constraintsystem tables.
--29T01::.362008Z [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating
a new UUID: 043563f4-9d78-11e6-a8c8-606dc79c383c.
--29T01::.388009Z [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
--29T01::.401010Z [Note] A temporary password is generated for root@localhost: u).ig.Gd.7hW
3、此时使用“net start mysql”成功启动msyql
4、使用生成的密码登录mysql，通过“set password=password('123456')”修改密码。此处将root密码设置为123456
mysql> set password=password('');
Query OK, rows affected, warning (0.00 sec)