Workbench для linux mint

How To Install Mysql-Workbench On Linux Mint 20.2

MySQL Workbench is a Visual database designing and modeling access tool for MySQL server relational database. It facilitates creation of new physical data models and modification of existing MySQL databases with reverse/forward engineering and change management functions.

Step 1 : Check the OS version by using the below command

[email protected]:~# lsb_release -a No LSB modules are available. Distributor ID: Linuxmint Description: Linux Mint 20.2 Release: 20.2 Codename: uma 

Step 2 : Update the System repositories by using the below command

[email protected]:~# apt-get update Hit:1 http://repo.mysql.com/apt/ubuntu focal InRelease Hit:2 http://archive.ubuntu.com/ubuntu focal InRelease Hit:3 http://archive.canonical.com/ubuntu focal InRelease Get:4 http://archive.ubuntu.com/ubuntu focal-updates InRelease [114 kB] Get:5 http://security.ubuntu.com/ubuntu focal-security InRelease [114 kB] Ign:6 http://packages.linuxmint.com uma InRelease Get:7 http://archive.ubuntu.com/ubuntu focal-backports InRelease [108 kB] Hit:8 http://packages.linuxmint.com uma Release Fetched 336 kB in 2s (174 kB/s) Reading package lists. Done 

Step 3 : reconfigure the mysql using dpkg command by using the below command

[email protected]:~# dpkg-reconfigure mysql-apt-config Warning: apt-key should not be used in scripts (called from postinst maintainerscript of the package mysql-apt-config) OK 

Step 4 : Install the mysql-workbench package by using the below command

[email protected]:~# apt-get install mysql-workbench-community Reading package lists. Done Building dependency tree Reading state information. Done The following additional packages will be installed: libopengl0 libpcrecpp0v5 libproj15 proj-data Suggested packages: proj-bin libproj-dev The following NEW packages will be installed: libopengl0 libpcrecpp0v5 libproj15 mysql-workbench-community proj-data 0 upgraded, 5 newly installed, 0 to remove and 28 not upgraded. Need to get 38.0 MB of archives. After this operation, 197 MB of additional disk space will be used. Do you want to continue? [Y/n] y Get:1 http://repo.mysql.com/apt/ubuntu focal/mysql-tools amd64 mysql-workbench-community amd64 8.0.27-1ubuntu20.04 [29.4 MB] Get:2 http://archive.ubuntu.com/ubuntu focal/main amd64 libpcrecpp0v5 amd64 2:8.39-12build1 [15.5 kB] Get:3 http://archive.ubuntu.com/ubuntu focal/universe amd64 proj-data all 6.3.1-1 [7,647 kB] Get:4 http://archive.ubuntu.com/ubuntu focal/universe amd64 libproj15 amd64 6.3.1-1 [925 kB] Get:5 http://archive.ubuntu.com/ubuntu focal-updates/main amd64 libopengl0 amd64 1.3.2-1~ubuntu0.20.04.1 [29.3 kB] Fetched 38.0 MB in 4s (9,527 kB/s) Selecting previously unselected package libpcrecpp0v5:amd64. (Reading database . 281386 files and directories currently installed.) Preparing to unpack . /libpcrecpp0v5_2%3a8.39-12build1_amd64.deb . Unpacking libpcrecpp0v5:amd64 (2:8.39-12build1) . Selecting previously unselected package proj-data. Preparing to unpack . /proj-data_6.3.1-1_all.deb . Unpacking proj-data (6.3.1-1) . Selecting previously unselected package libproj15:amd64. Preparing to unpack . /libproj15_6.3.1-1_amd64.deb . Unpacking libproj15:amd64 (6.3.1-1) . Selecting previously unselected package libopengl0:amd64. Preparing to unpack . /libopengl0_1.3.2-1~ubuntu0.20.04.1_amd64.deb . Unpacking libopengl0:amd64 (1.3.2-1~ubuntu0.20.04.1) . Selecting previously unselected package mysql-workbench-community. Preparing to unpack . /mysql-workbench-community_8.0.27-1ubuntu20.04_amd64.deb . Unpacking mysql-workbench-community (8.0.27-1ubuntu20.04) . Setting up libpcrecpp0v5:amd64 (2:8.39-12build1) . Setting up proj-data (6.3.1-1) . Setting up libopengl0:amd64 (1.3.2-1~ubuntu0.20.04.1) . Setting up libproj15:amd64 (6.3.1-1) . Setting up mysql-workbench-community (8.0.27-1ubuntu20.04) . Processing triggers for mime-support (3.64ubuntu1) . Processing triggers for hicolor-icon-theme (0.17-2) . Processing triggers for gnome-menus (3.36.0-1ubuntu1) . Processing triggers for libc-bin (2.31-0ubuntu9.2) . Processing triggers for shared-mime-info (1.15-1) . Processing triggers for desktop-file-utils (0.24+linuxmint1) . 

Step 5: To Open the menubar and search mysql workbench as shown in the below image

Step 6: This is the welcome page of mysql workbench

Step 7: This image shows the connection setup option. Step 8: This is the image shows the manage server Connections

With this, the installation process of MySQL-workbench on Linux mint 20.2 comes to an end !!

Источник

How To Install MySQL Workbench on Linux mint 18.03

MySQL workbench is a cross-platform tool used for accessing MySQL server and database. It is simple and easy to install tool. In this tutorial, let us see about the installation of MySQL workbench on Linux mint 18.03

Installation

Let’s first start with updating the system repositories.

linuxhelp ~ # apt-get update Hit:1 http://ppa.launchpad.net/ondrej/php/ubuntu xenial InRelease Hit:2 http://archive.ubuntu.com/ubuntu xenial InRelease Hit:3 http://archive.canonical.com/ubuntu xenial InRelease Ign:4 http://packages.linuxmint.com sylvia InRelease Hit:5 http://ppa.launchpad.net/webupd8team/java/ubuntu xenial InRelease Hit:6 http://packages.linuxmint.com sylvia Release Get:8 http://security.ubuntu.com/ubuntu xenial-security InRelease [107 kB] Get:9 http://archive.ubuntu.com/ubuntu xenial-updates InRelease [109 kB] Get:10 http://archive.ubuntu.com/ubuntu xenial-backports InRelease [107 kB] Fetched 323 kB in 2s (157 kB/s) Reading package lists. Done 

Install the MySQL Workbench package run the following command

linuxhelp ~ # apt-get install mysql-workbench Reading package lists. Done Building dependency tree Reading state information. Done The following additional packages will be installed: libaec0 libarmadillo6 libarpack2 libctemplate2v5 libdap17v5 libdapclient6v5 libepsilon1 libfreexl1 libgdal1i libgeos-3.5.0 libgeos-c1v5 libhdf4-0-alt libhdf5-10 libkmlbase1 libkmldom1 libkmlengine1 libminizip1 libmysqlclient20 libmysqlcppconn7v5 libnetcdf11 libodbc1 libogdi3.2 libopenjp2-7 libpcrecpp0v5 libpq5 libproj9 libspatialite7 libsuperlu4 libsz2 libtinyxml2.6.2v5 liburiparser1 libvsqlitepp3v5 libxerces-c3.1 mysql-workbench-data odbcinst odbcinst1debian2 proj-data python-mysql.connector python-pyodbc python-pysqlite2 Suggested packages: . . . Setting up mysql-workbench-data (6.3.6+dfsg-0ubuntu1) . Setting up python-mysql.connector (2.0.4-1) . Setting up python-pyodbc (3.0.7-0ubuntu2) . Setting up python-pysqlite2 (2.7.0-1) . Setting up odbcinst1debian2:amd64 (2.3.1-4.1) . Setting up libgdal1i (1.11.3+dfsg-3build2) . Setting up mysql-workbench (6.3.6+dfsg-0ubuntu1) . Setting up odbcinst (2.3.1-4.1) . Processing triggers for libc-bin (2.23-0ubuntu9) . 

Once Installation is done you can access the MySQL Workbench from the Menu as shown here

The version of MySQL Workbench application.

With this, the method to install Mysql Workbench on Linuxmint-18.03 comes to an end.

Источник

How to install MySQL Workbench on Linux Mint 18

MySQL Workbench is a GUI tool to manage MySQL Server. It comes with many features to administer multiple MySQL or MariaDB server remotely. We can create new database, tables, edit table, create query, export and import data using this Workbench. This tutorial is going to show you how to install MySQL Workbench on Linux Mint 18. Before we go through the installation process. You may want to have a look at the new MySQL Workbench running on Linux Mint 18. When this article is being written, MySQL Workbench 6.3.1 is available from the official website.

MySQL Workbench Screenshots on Linux Mint 18

Click the following image to see the larger version.

This slideshow requires JavaScript.

Steps to install MySQL Workbench on Linux Mint 18

Step 1. Download MySQL Workbench DEB

First, we need to download the installation file of MySQL Workbench for Ubuntu 16.04. Please use the following link to download the file.

Make sure you choose Ubuntu Linux from the Operating System list.

Now save the DEB file to your local directory. You should have a file name: mysql-workbench-community-6.3.10-1ubuntu16.04-amd64.deb

Step 2. Install MySQL Workbench

Now, open File Manager and right click on the DEB file. Select Open With GDebi Package Installer to start the installation.

Next, click Install Package and then enter your root password

Wait until the installation process is complete.

Now you should see MySQL Workbench on your application menu. You can find it under Programming. Click it to open.

Create new MySQL Connection

After we install MySQL Workbench, we need to connect our MySQL Server. Open Workbench and then click + button close to MySQL Connection on its main window. It will open up a new connection window. Enter your MySQL Server details including IP address, user and password.

Click OK to complete this step and you can now working with your MySQL Server.

Final Thoughts

MySQL Workbench is a must have tool for MySQL Server administrator. It can be installed on Windows and Linux as well. You can manage multiple MySQL Servers from remotely. It comes with great built in tools you need. Thanks for reading this how to install MySQL Workbench on Linux Mint. See you on the next tutorial.

Источник