mysql 安装与配置常见错误

mysql 安装与配置

下载安装
https://mirrors.huaweicloud.com/mysql/Downloads/MySQL-5.7/ 华为源下载
https://www.runoob.com/mysql/mysql-install.html 安装

C:\Windows\system32>cd C:\Program Files\MySQL\MySQL Server 5.7\bin

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --install
Service successfully installed.

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)

C:\Program Files\MySQL\MySQL Server 5.7\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务无法启动。

服务没有报告任何错误。

请键入 NET HELPMSG 3534 以获得更多的帮助。

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld --initialize --console
2020-11-19T12:54:58.161054Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-11-19T12:54:58.440740Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-11-19T12:54:58.560516Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-11-19T12:54:58.640641Z 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: 6e0e658e-2a66-11eb-8c30-98fa9bfb276f.
2020-11-19T12:54:58.646790Z 0 [Warning] Gtid table is not ready to be used. Table ‘mysql.gtid_executed’ cannot be opened.
2020-11-19T12:54:59.381517Z 0 [Warning] CA certificate ca.pem is self signed.
2020-11-19T12:54:59.664056Z 1 [Note] A temporary password is generated for root@localhost: dwWuZ<(HY7x8

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysqld install
The service already exists!
The current server installed: “C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld” MySQL

C:\Program Files\MySQL\MySQL Server 5.7\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

C:\Program Files\MySQL\MySQL Server 5.7\bin>net stop mysql
MySQL 服务正在停止.
MySQL 服务已成功停止。

C:\Program Files\MySQL\MySQL Server 5.7\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。

C:\Program Files\MySQL\MySQL Server 5.7\bin>mysql -u root -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.7.30

Copyright © 2000, 2020, 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> ALTER USER USER() IDENTIFIED BY ‘123456’;
Query OK, 0 rows affected (0.02 sec)

mysql>
mysql> create database AutoTest default charset=utf8;