However there’s one you might not have heard of: RazorSQL. This particular tool has been confirmed to work with over 40 databases, via JDBC or ODBC. And although RazorSQL does suffer from an aging GUI, it’s still a very powerful tool that can take your database administration to the next level. It also should be noted that RazorSQL isn’t free. The cost is $99.95 USD for a single user license. For more users, the cost goes down (check out this price matrix). What’s important to know about RazorSQL is that it has a fairly large feature list that will impress most any DB admin. I want to show you how to connect RazorSQL to a MySQL database server.
I’ll be running Razor on Ubuntu Linux 17.10 (the client is available for Linux, macOS, and Windows) and my database server is Ubuntu Server 16.04. The first thing you must do is install RazorSQL. On the Linux platform, there really isn’t an installation per say. Instead, you download the file that matches your platform architecture (32- or 64-bit), unzip that file, change into the newly created directory, and start RazorSQL with the command. This will create a new folder in your $USER directory, called. Within that folder, your configuration options will be saved. With that taken care of, let’s make the connection.
See: How to set up MySQL for remote access on Ubuntu Server 16.04 Creating a new connectionīefore you attempt to make the connection, you must make sure your MySQL server is setup to allow remote connections.
To create a new connection, open RazorSQL and click Connections | Add Connection Profile. In the resulting screen ( Figure A), you must select the database type. As I’m connecting to a MySQL server, I’ll select MySQL and click Continue. In the next window ( Figure B), you must select a type of connection from the CONNECTION TYPE window. Select JDBC (MySQL Connector), click Auto Download Driver, and then when prompted click Continue. $ sh razorsql.sh How to install RazorSQL 6.2.When the driver has downloaded, click OK. Follow the instructions for your system architecture exactly, in order to get a successful installation: How to install RazorSQL 6.2.3 on 32 bit Linux systems: There is no repository available for RazorSQL, so we have to download the zip file from the official site and execute the installation script. In this article I will show you how to install RazorSQL 6.2.3 on Ubuntu, Linux Mint, Pear OS, Elementary OS, Debian, KWheezy, Fedora, CentOS, Mageia, ROSA Desktop, OpenSUSE, Arch Linux and many others. For more information, see the official changelog. The latest version available is RazorSQL 6.2.3 which has been released a while ago, bringing improvemenets and fixes. As you may know, RazorSQL is a cross platform tool for managing SQL databases, running on Linux, Solaris, Windows and Mac OS X.
0 kommentar(er)
