mysql各个组件_MySQL8.0 各组件

MySQL Server 8.0

MySQL Workbench 8.0

管理 MySQL 服务器的 GUI 工具

Connector/J

Connector/NET

Connector/Node.js

Connector C++ 8.0

Connector ODBC 8.0

MySQL native driver for PHP - mysqlnd

MySQL Connector Python 8.0 for Python 3.7

MySQL Shell 8.0

MySQL Shell 是命令行 Client.

首先将C:\Program Files\MySQL\MySQL Server 8.0\bin加入到PATH环境变量。

然后在cmd或powershell中输入：mysql -u root -p

C:\Documents and Settings>mysql -u root -p [DatabaseName]

Enter password: *****

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 20

Server version: 8.0.13 MySQL Community Server - GPL

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> status

如果直接输入mysql，将提示：

C:\Documents and Settings>mysql

ERROR 1045 (28000): Access denied for user 'ODBC'@'localhost' (using password: NO)

MySQL Router 8.0

Router 和 Cluster 直接的关系

mysql router config.PNG

其它安装截图

数据库用户角色(User Roles)

UserRoles.PNG

MySQL as Windows Service

一个MySQL服务器实例(instance)可对应到一个Windows服务。(Please specify a Windows Service name to be used for this MySQL Server instance. A unique name is required for each instance.)

MySQL as Windows Service.PNG