我设置的my.ini,有须要的能够直接粘贴复制使用,后期请自行从新根据各自的项目进行从新配置php
# 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 installed复制代码
5.运行 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)为新生成的随机密码html
此时使用“net start mysql”成功启动msyql复制代码
net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
复制代码
登陆成功后能够经过随机的帐号密码对数据库进行登陆mysql
mysql -u root -p
Enter password: (输入生成的随机密码)
#登陆后从新修改密码
set password=password('123456');
#到此在phpstudy下从新升级mysql完成
最后记得删除以前老的mysql版本
mysqld -remove
而后再phpstudy中从新安装服务就能够了复制代码