Get Oracle SQL Developer package
http://www.oracle.com/technology/software/products/sql/index.html
#https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-20.2.0.175.1842-no-jre.zip https://download.oracle.com/otn/java/sqldeveloper/sqldeveloper-22.2.1.234.1810-no-jre.zip 2. accept the licence 3. login 4. download "Oracle SQL Developer for other platforms"
# download sqldeveloper-*-no-jre.zip archive # extract sudo unzip -q Downloads/sqldeveloper-*-no-jre.zip -d /opt/ # 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 # configure JDK home sed -i 's|# SetJavaHome /path/jdk|SetJavaHome /usr/lib/jvm/default-java/|g' ~/.sqldeveloper/*/product.conf
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