I'm trying to learn the PL/SQL language. On my Mac laptop (macOS Monterey, M1) I have the following setup:
MySQL Workbench running test database
And install SQL*Plus
in the terminalMy question: How to connect to a local MySQL Workbench database through sqlplus?
I think I need a user/password and specify localhost 3306 as the connection endpoint...but where do I find these things and how do I set them up? I looked through the Oracle documentation but didn't find an answer.
Any help would be greatly appreciated! This is a study on SQL interviews. Thanks in advance. -Sebastian
You need to use MySQL Workbench as the client of MySQL Server, or you need to use SQL*Plus as the client of Oracle Server. These are two different brands of databases (even though they are both owned by Oracle Corporation) and clients cannot connect to each other's databases.
Your statement of using SQL*Plus to connect to MySQL Workbench doesn't make sense anyway since they are both client side.