mysql启动报错：本地计算机上的mysql服务启动后停止,某些服务在未由其他服务或程序使用时将自动停止

新电脑上安装mysql报错。PS压缩包。注意以下cmd操作全部在对应的/bin目录下操作的

1. 解压后直接配置path
2. 修改my-default.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.
   
   [mysql]
   default-character-set=utf8 
   # 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 = .....
   # datadir = .....
   # port = .....
   # server_id = .....
   
   # 设置mysql客户端默认字符集
   
   [mysqld]
   #设置3306端口
   port = 3306 
   # 设置mysql的安装目录
   basedir=D:\mysql-5.7.17-winx64
   # 设置mysql数据库的数据的存放目录
   datadir=F:\database
   # 允许最大连接数
   max_connections=200
   # 服务端使用的字符集默认为8比特编码的latin1字符集
   character-set-server=utf8
   # 创建新表时将使用的默认存储引擎
   default-storage-engine=INNODB
   
   # 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 
   
   sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 
   

    

3. 管理员cmd启动，安装mysql服务：   

   mysqld --install mysql

    

4. 启动服务： 

   net start mysql

    

5. 报错： 

查找问题，重新安装，找到问题原因，配置文件有误，还有就是未初始化mysql data文件夹。修改步骤如下：

1. 删除mysql服务

   mysqld --remove mysql

    

2. 修改配置文件中的[mysql]    [mysqld]   ！！注意这两个括号里面的 不能少。详细的见上面的inip配置（我贴的已经是正确的了，之前我两个括号里面都写的是[mysqld]）
3. 重新安装mysql服务

   mysqld --install mysql

    

4. 初始化data

   mysqld --initialize-insecure

    

5. 启动mysql服务

   net start mysql