Get Oracle SQL Developer package
http://www.oracle.com/technology/software/products/sql/index.html
https://www.oracle.com/database/sqldeveloper/technologies/download/
accept the licence login download "Oracle SQL Developer for other platforms"
Install
# download sqldeveloper-*-no-jre.zip archive #https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-22.2.1.234.1810-no-jre.zip https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-23.1.0.097.1607-no-jre.zip # OPTIONAL: archive previous version sudo mv /opt/sqldeveloper{,.$(date -I)} # extract sudo unzip -q ~/Downloads/sqldeveloper-*-no-jre.zip -d /opt/
Configure JDK home / version
# find latest configuration file SQL_DEVELOPER_COFIG=$(find ~/.sqldeveloper/*/product.conf | sort -V | tail -1) #sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/default-java/|g' ${SQL_DEVELOPER_COFIG} sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/java-1.17.0-openjdk-amd64/|g' ${SQL_DEVELOPER_COFIG}
Create starter
# Create desktop starter cat <<EOF | sudo tee /usr/share/applications/sqldeveloper.desktop [Desktop Entry] Encoding=UTF-8 Name=Oracle SQL Developer Exec=/opt/sqldeveloper/sqldeveloper.sh Icon=/opt/sqldeveloper/icon.png Terminal=false Type=Application Categories=GNOME;Application;Development; EOF
Reduced memory usage
sed -i 's|-Xmx640M|-Xmx384M|g' /opt/sqldeveloper/ide/bin/ide.conf
Connect to MySQL server
https://oracle-base.com/articles/mysql/mysql-connections-in-sql-developer
sudo dpkg -i mysql-connector-java_8.0.26-1ubuntu21.04_all.deb # "Tools > Preferences > Database > Third Party JDBC Driver" /usr/share/java/mysql-connector-java-8.0.26.jar
# DEP:
https://raw.githubusercontent.com/panticz/installit/master/install.sqldeveloper.sh