前言：由于项目需求，本地开发环境使用了phpstudy 的默认集成环境，但是由于其自带的mysql只是5.5的版本。在laravel 应用中显得尤为不足，而且这段时间需要学习laracms 其本身要求的数据库就需要达到5.7没办法只能升级。看了网上很多的教程和方法，前期总是很好的，但是每次重启的时候都会报无法连接本地的错误。
Can't connect to MySQL server on localhost (10061)
于是只能是慢慢地摸索和找方法，终于找到了解决方式，并为此记录下来。分享给有需要的朋友。
1.备份原来的MySQL文件夹phpstudy\PHPTutorial\MySQL重命名为MySQL5.5 2.将下载的mysql5.7压缩文件解压缩，并放在phpstudy\PHPTutorial\文件夹下，命名为MySQL； 3.将目录下的my-default.ini修改为my.ini (这里本人尝试过把原有的ini文件直接放进去,但是在启动的时候就是不停地报错。)
我设置的my.ini,有需要的可以直接粘贴复制使用，后期请自行重新根据各自的项目进行重新配置
# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
[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
# These are commonly set, remove the # and set as required.
basedir="D:/phpstudy/PHPTutorial/MySQL/"
datadir="D:/phpstudy/PHPTutorial/MySQL/data/"
port=3306
# server_id = .....
# 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
#skip-grant-tables
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=512
explicit_defaults_for_timestamp=true
4.以管理员身份运行cmd进入phpstudy\PHPTutorial\MySQL\bin目录；
运行 mysqld --install #此命令用于安装mysql运行后显示：Service successfully installed5.运行 mysqld --initialize --user=root --console
运行后显示:
2018-11-26T05:30:06.207044Z 0 [Warning] InnoDB: New log files created, LSN=45790
2018-11-26T05:30:06.310050Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2018-11-26T05:30:06.340052Z 0 [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: 5524df0e-f13c-11e8-8811-1c6f65e86efe.
2018-11-26T05:30:06.343052Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2018-11-26T05:30:06.359053Z 1 [Note] A temporary password is generated for root@localhost: :5OVJr5WO<Ws其中（:5OVJr5WO<Ws）为新生成的随机密码
此时使用“net start mysql”成功启动msyqlnet start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
登录成功后可以通过随机的账号密码对数据库进行登录
mysql -u root -p
Enter password: （输入生成的随机密码）
#登录后重新修改密码
set password=password('123456');
#到此在phpstudy下重新升级mysql完成
最后记得删除之前老的mysql版本
mysqld -remove
然后再phpstudy中重新安装服务就可以了