美文网首页
MySQL8.0 各组件

MySQL8.0 各组件

作者: zlrs | 来源:发表于2019-02-16 21:05 被阅读0次

Windows10下安装MySQL,建议安装官网下载的MySQL8.0版本,以避免安装过程中的各种繁琐问题。
下载地址:https://dev.mysql.com/downloads/installer/
官方文档:https://dev.mysql.com/doc/

MySQL Server 8.0

MySQL Workbench 8.0

管理 MySQL 服务器的 GUI 工具

MySQL Connectors

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环境变量。
然后在cmdpowershell中输入: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

相关文章

网友评论

      本文标题:MySQL8.0 各组件

      本文链接:https://www.haomeiwen.com/subject/mjmieqtx.html