Category Archives: SQL

Creating an IDE Connection (DBeaver) to UbuntuServer running MySql

Desired Outcome Note: I had run into an issue with making the connection between NetBeans and UbuntuServer (that is running on another laptop and connected to same LAN) because I needed a plugin that would require the full JDK installation … Continue reading

Posted in SQL | Tagged | Leave a comment

Creating connection between NetBeans IDE and SQL Server on UbuntuServer

Desired Outcome Establish a connection between NetBeans IDE (running on my Mac) with a local UbuntuServer (I have running on a laptop attached to same LAN) that has MySQL running NetBeans IDE -Version 8.2 -Tools, Servers, Add Server returns: No … Continue reading

Posted in SQL, Troubleshooting-Pending, UbuntuServer | Tagged | Leave a comment

Installing OracleDB on CentOS7

Note: I already have MariaDB and Apache Tomcat installed on CentOS7 server. Now I’ll be adding the free version of OracleDB. Note: I followed these instructions: http://www.tecmint.com/oracle-database-11g-release-2-installation-in-linux/ cd /etc/yum.repos.d (Change directory) wget http://public-yum.oracle.com/public-yum-ol6.repo (Get the file) yum install oracle-rdbms-server-11gR2-preinstall (Install … Continue reading

Posted in SQL | Leave a comment

SQL within 1and1 databases – basic commands

Access the database within 1and1 using Putty and SSH – this is the easy part, and I’m into SQL Monitor where the prompt is: mysql> Note: 1and1 is using Oracle, which is convenient for learning and I can create a … Continue reading

Posted in SQL | Leave a comment