MySql安装

一，安装

1.直接下载：https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.11-winx64.zip

2.解压文件，复制在目录C:\Program Files下

3.进入bin目录下，然后在地址输入框中直接输入cmd

 4.在控制台中直接输入mysqld --initialize --console

C:\Program Files\Mysql\bin>mysqld --initialize --console
2022-03-15T14:43:22.767065Z 0 [System] [MY-013169] [Server] C:\Program Files\Mysql\bin\mysqld.exe (mysqld 8.0.11) initializing of server in progress as process 9884
2022-03-15T14:43:42.775254Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: 8z6ari:yeypF
2022-03-15T14:43:57.762583Z 0 [System] [MY-013170] [Server] C:\Program Files\Mysql\bin\mysqld.exe (mysqld 8.0.11) initializing of server has completed

C:\Program Files\Mysql\bin>

我在安装的石油遇到了一个问题，就是找不到dll.

在这里找到了正解：https://blog.csdn.net/laixide110/article/details/80340244。原因是没有安装VC++2015的版本库。下载地址：https://www.microsoft.com/en-us/download/details.aspx?id=53587。点击下载、安装相应版本的文件即可。
————————————————————————————————————————————————————————————————————————————————

注意：@localhost后面的是初始密码8z6ari:yeypF

5. 进入bin目录下，然后在地址输入框中直接输入cmd 

6.在控制台中直接输入mysqld --install

7.再输入net start mysql启动MySQL的服务。

C:\Program Files\Mysql\bin>mysqld --install
Service successfully installed.

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


C:\Program Files\Mysql\bin>

二，更改密码和密码认证插件

1. 进入bin目录下，然后在地址输入框中直接输入cmd

2.输入 mysql -u root -p指令     这时候会提示输入密码，记住了上面安装时的密码，填入即可登录成功，进入MySQL命令模式。

3.

修改用户密码，在MySQL中执行命令：

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

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

Copyright (c) 2000, 2018, 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 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.11 sec)

mysql>

修改密码验证插件，同时修改密码。

可以用 命令查看一下默认安装的数据库：

show databases;

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.12 sec)

看到默认初始化了mysql数据库，其中user表里面存储MySQL用户信息。我们可以看一下默认MySQL用户：

 select user,host,authentication_string from mysql.user;

mysql>  select user,host,authentication_string from mysql.user;
+------------------+-----------+-------------------------------------------+
| user             | host      | authentication_string                     |
+------------------+-----------+-------------------------------------------+
| mysql.infoschema | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.session    | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| mysql.sys        | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |
| root             | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 |
+------------------+-----------+-------------------------------------------+
4 rows in set (0.00 sec)

mysql>

三、Navicat 使用

1. Nacvicat解压，直接放在根目录下

2.点击启动 Nacvicat

3.新建连接，连接名随意，密码输入123456

 4. 为了方便一般都练测试连接，练接成功在保存

5. 创建一个数据库

6.运行SQL文件，就直接可以导入数据和表结构