July 8, 2014

SQL Developer Crash on Fedora 20

I ran into a painful issue on Fedora 20 with SQL Developer.  Basically every time it was launched via the shortcut it would go through loading, and then disappear. Manual Invocation of SQL Developer When launching it via the script itself it gives us a little more information. I also noticed, that while executing as root it worked.  However that clearly isn’t the “solution” Fixing […]
July 7, 2014

Install MySQL Server Community Edition on Fedora 20

Today we are going to go through the process of installing MySQL Server Community Edition on Fedora 20.  You could of course simply use MariaDB, but this will focus on the Community Edition. Install the MySQL Repository We will need to install the MySQL Community Repository, the MySQL project hosts an RPM file with the repository.  First lets look at the repositories that I have […]
February 13, 2013

Oracle VM 3: Connecting to MySQL Backend

Starting in Oracle VM 3.2.1 the built in database of the Oracle VM Manager was MySQL.  I had hoped that this change would also signal a change in the database schema.  In prior versions of OVM 3.x all data was populated in the database in a completely useless longblob form. As we can see it is attempting and failing to use /var/lib/mysql/mysql.sock as the connection.  […]
February 12, 2013

Solaris 11: Installing MySQL

Recently I have been spending some time learning about database technologies (Oracle Databases at Keste as well as MySQL on my own).  Part of this I have decided to carry over into my existing work with Solaris, and go through the installation process using the Image Packaging System which is in Solaris.  Now really the IPS does all the heavy lifting for us, but we […]
February 11, 2013

MySQL: Describe All Tables

In MySQL if you want to find out what columns are in a given table, you can describe the table and it will show you the columns and the data types associated with that column.  However if you need to do this for a large number of tables, it can get a bit repetitive. Connect to MySQL Show the Available Databases Use the TST Database […]
+1 (844) 368-2747