There are not many SQL client tools available under the Ubuntu 16.04 Lts, of course it means free open source tools. Personally, I like dbeaver very much. Dbeaver relies on Java (JDK/JRE) 1.8+. Dbeaver is a common database management tool and SQL client that supports databases such as MySQL, dbeaver sql client PostgreSQL, Oracle, DB2, MSSQL, Sybase, and so on, dbeaver vpn basically as long as it is compatible with JDBC databases. You reader, I will use the life skill, will dbeaver the installment process record and to share out, hoped can bring the person who needs to have a little help.
dbeaver download
1. Download Dbeaver first of all, Dbeaver provides Deb and tar.gz two ways to install the package, if you download the Deb package, directly using the "sudo dpkg-i package name" To install it, if you encounter other dependencies are not installed directly using sudo Apt-get install-f To install dependencies, and then use the Dpkg-i command to install the Deb package. Of course, this way will not reflect a programmer love to toss the heart. So, I chose to use the Tar.gz method to install. Download command, open terminal execution can be: 32-bit: wget http://dbeaver.jkiss.org/files/dbeaver-ce-latest-linux.gtk.x86.tar.gz 64: wget http:// dbeaver.jkiss.org/files/dbeaver-ce-latest-linux.gtk.x86_64.tar.gz 2. Installation Dbeaver Unzip the tar.gz file that you just downloaded to the specified directory (you need to install to that directory, unzip to where). Commands are as follows: TAR-ZXVF package name-C target path
dbeaver create table sql
3. Execute dbeaver to the unpacked directory, you can see the Dbeaver file structure, we execute the./dbeaver command, we can run the dbeaver.
dbeaver csv driver
4. Configure the connection in the upper left corner of the Dbeaver click on the "plus icon", and then choose MySQL, click Next to enter the next step, dbeaver mysql public key retrieval is not allowed configure the MySQL database connection information is always next, until the finish is ok (of course, before finish can also point test Connection test configuration is OK).
dbeaver stored procedure
After everything is configured, you can use Dbeaver happily under Ubuntu. Permanent update of this article address:export database dbeaver Http://www.linuxdiyf.com/linUx/28943.html