MySQL installs the database engine. Which you run and start from the terminal/bash/shell.
You will need to download the MySQL workbench for a GUI.
phpmMyAdmin is another choice which runs in the browser.
Sounds like you have MySQL installed. You just need to setup a GUI now.
Q1. why until now there's nothing in the applications? I can't see any item or folder like mysql there. is it that every time i want to run mysql, i have to mount the installation package?
A1: The dB engine is installed you have to start and stop it using terminal window.
shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
shell> sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop
Q2. what does MySQLStartupItem.pkg installed?
A2: The Startup Item installation adds a variable MYSQLCOM=-YES- to the system configuration file /etc/hostconfig.
Q3. Is there any client side tools inside the installation package? I mean, for example, Microsoft SQL Server for Windows, there are Microsoft SQL Server; and there are Microsoft SQL Server Management Studio, which serves as a client tool to browse databases and doing queries; also, if i download "Microsoft SQL Server Express with Tools" package, it will install both. does "mysql-5.5.28-osx10.6-x86_64.dmg" contains only the server, or also a client tool inside?
A3: Lots. phpMyAdmin for browser. And MySQLWorkBench equal to SQL Server Management Studio (Browse dB's and other objects)
To connect using 'as sysdba' from a client over sql*net you need to have the
- remote_login_passwordfile parameter to have 'exclusive'
- password file (orapw${ORACLE_SID}) present for the instance where you try to connect to
- have the user granted sysdba in the database (sys has this default and uses the passwd file password.
The default location for the password file is $ORACLE_HOME/dbs but since Oracle v12 it can also be stored in ASM. In that case you find it using srvctl
Best Answer
SQL Developer doesn't come with an Oracle database, it is a client application. You can't "connect to SQL Developer", you use SQL Developer to connect to an existing database.
There are no supported editions of Oracle database for Mac OS X at this time, the latest that was available was 10gR2. You'll need to set one up in a VM on your machine (Windows or Linux, using the Oracle XE edition seems like it would fit your need), or see if you can somehow connect to your lab databases (possibly via a VPN to your school if they have that available).