Substring in razorsql how to#
Substring in razorsql install#

When the driver has downloaded, click OK. Select JDBC (MySQL Connector), click Auto Download Driver, and then when prompted click Continue. In the next window ( Figure B), you must select a type of connection from the CONNECTION TYPE window. As I’m connecting to a MySQL server, I’ll select MySQL and click Continue. In the resulting screen ( Figure A), you must select the database type. To create a new connection, open RazorSQL and click Connections | Add Connection Profile.

Substring in razorsql how to#

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. With that taken care of, let’s make the connection. Within that folder, your configuration options will be saved. This will create a new folder in your $USER directory, called. 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. On the Linux platform, there really isn’t an installation per say.

Substring in razorsql install#

The first thing you must do is install RazorSQL. 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. I want to show you how to connect RazorSQL to a MySQL database server. What’s important to know about RazorSQL is that it has a fairly large feature list that will impress most any DB admin. For more users, the cost goes down (check out this price matrix). The cost is $99.95 USD for a single user license. It also should be noted that RazorSQL isn’t free. 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. This particular tool has been confirmed to work with over 40 databases, via JDBC or ODBC. However there’s one you might not have heard of: RazorSQL. Sure you might know every MySQL command available, but running a host of commands on your server isn’t nearly as efficient as having a good GUI–especially when you’re charged with managing a large number of databases.īut which GUI should you use? Most MySQL database administrators know there are a lot of GUIs out there. If you’re a database administrator, you know a good GUI client can make life a whole lot easier. Jack Wallen shows you how to connect the RazorSQL database client to a remote MySQL server, so you can gain even more power and efficiency with your database admin tasks. How to connect RazorSQL database client to your MySQL server