search

Home  >  Q&A  >  body text

Connect to a local MySQL Workbench database using sqlplus

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 terminal

My 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

P粉787934476P粉787934476304 days ago420

reply all(1)I'll reply

  • P粉947296325

    P粉9472963252024-03-29 14:34:25

    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.

    reply
    0
  • Cancelreply