数据库工作笔记018---Windows下mysql安装_服务无法启动没有报告解决

技术交流QQ群【JAVA,C++,Python,.NET,BigData,AI】：170933152  

之前用的好好,就今天,mysql服务就起不来了,之前都在centos上做mysql,为了少花时间弄,记录一下吧:

这里win10下安装:mysql5.7.25 64位版:

安装不难,主要注意,初始化的时候,:D:\ProgramFiles\mysql-5.7.25-winx64\bin>mysqld --initialize --console

执行这句,后边要加上console ,要不然一会出来的临时密码就看不到了,不好去修改密码了.

如果下回启动的时候,出现了服务无法启动的情况可以这样,去安装目录,删除data文件夹,或者备份成其他名字,然后再去bin目录

执行mysqld --initialize --console可以看到有临时密码,然后再执行net start mysql 就可以启动了,启动后,登录,然后修改密码,然后,再用Navicat去登录就可以了,注意一定要先修改密码,那个临时密码,Navicat中是登录不了的,而且修改密码,要在控制台上修改.

整个过程的命令就是:

D:\ProgramFiles\mysql-5.7.25-winx64\bin>mysqld --initialize --console
2019-05-12T06:47:07.055326Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-05-12T06:47:08.437388Z 0 [Warning] InnoDB: New log files created, LSN=45790
2019-05-12T06:47:08.867773Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-05-12T06:47:09.084241Z 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: c37c9d2c-7481-11e9-a1ec-b083fe848ce7.
2019-05-12T06:47:09.115355Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-05-12T06:47:09.120486Z 1 [Note] A temporary password is generated for root@localhost: lWvwn:Lyy3YT

D:\ProgramFiles\mysql-5.7.25-winx64\bin>net start mysql
MySQL サービスを開始します.
MySQL サービスは正常に開始されました。


D:\ProgramFiles\mysql-5.7.25-winx64\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.25

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> set password=password('123456')
    -> ;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>

 

我这边下的是压缩包，直接解压，解压后在有bin文件的文件夹中创建my.ini文件并在文件中加入以下配置：


这边有去配置环境变量



完成之后，点击电脑左下角windows查找cmd右键点击以管理员身份运行