Connect to local MySQL Workbench DB via sqlplus

Question

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

Bill Karwin · Accepted Answer · 2022-05-11 00:26:23Z

1

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.

answered May 11, 2022 at 0:26

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to local MySQL Workbench DB via sqlplus

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related