通过SQLPlus连接到本地MySQL Workbench DB
我正在尝试学习PL/SQL语言。在我的Mac笔记本电脑（Macos Monterey，M1）上，我有以下设置：
MySQL Workbench运行测试数据库
和SQL*Plus终端中安装了
我的问题：如何连接到本地MySQL WorkBench数据库通过SQLPlus？
我想我需要一个用户/通行证并将Localhost 3306指定为连接端点...但是我在哪里找到这些东西，如何设置它们？我已经看了Oracle文档，但没有找到答案。
任何帮助将不胜感激！这是SQL访谈的研究。提前致谢。 - 塞巴斯蒂安
I'm trying to learn PL/SQL language. On my mac laptop (macOS Monterey, M1) I have the following set up:
MySQL Workbench running a test database
and SQL*Plus installed in the terminal
My question: How do I connect to my local MySQL Workbench database via sqlplus?
I imagine I need a user/pass and to specify localhost 3306 as the connection endpoint... but where do I find these things, how do I set them up? I've looked at Oracle documentation but haven't found the answer.
Any help would be greatly appreciated! This is study for a SQL interview. Thanks in advance.
-Sebastian
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您是否需要将MySQL Workbench用作MySQL Server的客户端，否则您需要使用SQL*Plus作为Oracle Server的客户端。这是两个不同的数据库品牌（尽管它们都是Oracle Corporation拥有的），并且客户无法连接到彼此的数据库。
您关于使用SQL*Plus连接到MySQL Workbench的陈述无论如何都毫无意义，因为这两个都是客户端。
Either you need to use MySQL Workbench as a client for MySQL Server, or else you need to use SQL*Plus as a client for Oracle Server. These are two different brands of database (although they are both owned by Oracle Corporation) and the clients cannot connect to each other's database.
Your statement of connecting to MySQL Workbench using SQL*Plus makes no sense anyway, since both of these are clients.