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-19.2.1.247.2212-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 sqldeveloper-*-no-jre.zip -d /opt/ # Create desktop starter cat <<EOF | 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 grep Home ~/.sqldeveloper/20.2.0/product.conf SetJavaHome /usr/lib/jvm/java-8-oracle/
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