From MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, and many others. If you’re looking for a database tool with health monitoring, and an SQL editor with various extensions (plugins), then DBeaver is a great tool for you. There are plugins and extensions for all the databases mentioned above and any others that support the JDBC driver.
Install OpenJDK 8
DBeaver works with Java. You must have JAVA installed on Ubuntu before installing DBeaver. For this tutorial, we’re going to be installing the open-source version of Oracle JAVA. To install, run the commands below: After running the commands above, run the commands below to test if Java is installed. You should get a similar print as below: Continue below to install DBeaver
Install DBeaver Community
Now that DBeaver Community is installed, run the commands below to add the DBeaver official repository to Ubuntu. After that, run the commands below to install DBeaver If you want to use MariaDB, use the steps below to install and configure.
Install MariaDB Database Server
MariaDB database server is a great place to start when looking at open-source database servers to use with DBeaver. To install MariaDB run the commands below. After installing MariaDB, the commands below can be used to stop, start and enable the MariaDB service to always start up when the server boots. Run these on Ubuntu 16.04 LTS Run these on Ubuntu 18.04 and 18.10 LTS After that, run the commands below to secure the MariaDB server by creating a root password and disallowing remote root access. When prompted, answer the questions below by following the guide.
Enter current password for root (enter for none): Just press the Enter Set root password? [Y/n]: Y New password: Enter password Re-enter new password: Repeat password Remove anonymous users? [Y/n]: Y Disallow root login remotely? [Y/n]: Y Remove test database and access to it? [Y/n]: Y Reload privilege tables now? [Y/n]: Y
Restart MariaDB server To test if MariaDB is installed, type the commands below to logon into the MariaDB server Then type the password you created above to sign on. if successful, you should see MariaDB welcome message That should install it. Now you can navigate to Ubuntu Activities overview, then search and launch DBeaver Community. When it opens, attempt to connect to your Database of choice. Select the database server you want to connect to from the list and attempt to connect. Connect to MySQL database using the root account. When you attempt to log on using the MariaDB root account it will fail… That’s because MariaDB and MySQL have switched their authentication method to auth_socket The auth_socket plugin authenticates users that connect from the localhost through the Unix socket file… which prevents users from connecting with passwords… So, you won’t be able to connect via the root account… When you attempt to log in, you see the error “#1698 – Access denied for user ‘root’@’localhost’” To fix that, run the commands below: That should get you into the database server. After that, run the commands below to disable plugin authentication for the root user Restart and run the commands below to set a new password. Now try again to log on… this time it should work! Congratulations! You have successfully installed DBeaver Community on Ubuntu. You may also like the post below:
