Connect to a local MySQL Workbench database using sqlplus
P粉787934476
P粉787934476 2024-03-28 21:56:02
0
1
410

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粉787934476
P粉787934476

reply all(1)
P粉947296325

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.

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template