管理员身份运行powershell

    Windows PowerShell
    版权所有 (C) Microsoft Corporation。保留所有权利。
    
    尝试新的跨平台 PowerShell https://aka.ms/pscore6
    
    PS C:\Users\Administrator> mysql
    ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
    PS C:\Users\Administrator> mysqld -install
    The service already exists!
    The current server installed: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" mysql
    PS C:\Users\Administrator> mysqld -install
    The service already exists!
    The current server installed: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" mysql
    PS C:\Users\Administrator> mysqld --remove mysql
    Service successfully removed.
    PS C:\Users\Administrator> mysqld -install
    The service already exists!
    The current server installed: "C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" mysql
    PS C:\Users\Administrator> net start mysql
    发生系统错误 1058。
    
    无法启动服务，原因可能是已被禁用或与其相关联的设备没有启动。
    
    PS C:\Users\Administrator> mysqld --initialize-insecure
    2021-11-24T08:53:32.858504Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
    2021-11-24T08:53:32.860503Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
    2021-11-24T08:53:32.860503Z 0 [ERROR] Aborting
    
    PS C:\Users\Administrator> net start mysql
    发生系统错误 1058。
    
    无法启动服务，原因可能是已被禁用或与其相关联的设备没有启动。
    
    PS C:\Users\Administrator> mysqld --remove mysql
    Failed to remove the service
    PS C:\Users\Administrator> mysqld --install mysql --defaults-file=C:\Program Files\MySQL\my.ini
    PS C:\Users\Administrator> net start mysql57
    MySQL57 服务正在启动 .
    MySQL57 服务已经启动成功。
    
    PS C:\Users\Administrator> mysql -h 127.0.0.1 -u root -p
    Enter password: ******
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 3
    Server version: 5.7.17-log MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2016, 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> show databases();
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '()' at line 1
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | blog               |
    | db2019             |
    | design             |
    | homework           |
    | jeecg-boot         |
    | lc-cc              |
    | loginregist        |
    | menagerie          |
    | mysql              |
    | nacos              |
    | performance_schema |
    | pig                |
    | pig_codegen        |
    | pig_config         |
    | pig_demo           |
    | pig_job            |
    | pythonmysql        |
    | qiolou             |
    | sakila             |
    | springboot         |
    | springcloud        |
    | starter            |
    | sys                |
    | test               |
    | vueblog            |
    | world              |
    +--------------------+
    27 rows in set (0.01 sec)
    
    mysql>