Как установить mysql-workbench в Ubuntu / Debian
Установка:
Для установки mysql-workbench в Ubuntu / Linux Mint / Debian, введите в Терминал :
Подробная информация о пакете:
MySQL Workbench — инструмент визуализации базы данных, администрирования и очередей
Зависимости:
Библиотека GNU C: общие библиотеки
Простой, но мощный язык шаблонов для C++
Библиотека поддержки GCC
Библиотека абстракции геопространственных данных
Библиотека GDK Pixbuf
Бесплатная реализация OpenGL API — время выполнения GLX
Это виртуальный пакет. Для определения виртуальных пакетов см. Политику Debian.
Библиотека GLib подпрограмм C
C++-оболочка для инструментария GLib (разделяемые библиотеки)
Библиотека сервисов для ключей GNOME
Библиотека графического интерфейса пользователя GTK+
C++-оболочки для GTK+ (разделяемые библиотеки)
Клиентская библиотека базы данных MySQL
Коннектор MySQL для C++ (библиотека)
Библиотека ODBC для Unix
Макет и предоставление интернационализированного текста
Макет и предоставление интернационализированного текста
C++ Wrapper для pango (разделяемые библиотеки)
Старая Perl 5 совместимая библиотека регулярных выражений — файлы времени выполнения
Старая Perl 5 совместимая библиотека регулярных выражений — файлы времени выполнения C++
Общая библиотека времени исполнения Python (версия 2.7)
Безопасная сигнальная структура для C++ — время выполнения
Стандартная библиотека GNU GNU v3
Библиотека синтаксического анализа XML C++
Универсальная уникальная библиотека ID
SQLite3 Wrapper для C++
X11 клиентская библиотека
Библиотека XML GNOME
Библиотека для чтения, создания и изменения zip-архивов (runtime)
MySQL Workbench — независимые от архитектуры данные
Интерактивный высокоуровневый объектно-ориентированный язык (ветка 2.x)
Чистая реализация протокола Python MySQL Client /Server
Сделать соединения ssh v2 (Python 2)
Модуль Python для автоматизации интерактивных приложений
Модуль Python для доступа к базе данных ODBC
Интерфейс Python для SQLite 3
Интерактивный объектно-ориентированный язык высокого уровня (версия 2.7)
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.
How To Install MySQL Workbench on Linux mint 18.03
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.
Install the MySQL Workbench package run the following command
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.
linux mint mysql-server and mysql-workbench installation and setup issue
I tried to below OS installed on my laptop
I have installed mysql-server using below command:
During this installation I was not prompted to enter any root password. TO see if installation was successful, I ran below command:
As I was not prompted to set any root password, I thought of setting root password.
1. Why I can’t be able to use «mysqladmin» command without being logged in as root?
2. How to fix the warning for mysqladmin set root password? ANd can I be able to use that password inside mysql workbench in future if decide to use it?
After setting root password(assuming that’s the right way to set it) , I have installed mysql-workbench
When I launch mysql workbench, I can’t be able to connect to user:root using hostname: localhost and port: 3306 and password set using mysqladmin command.
I also tried to use hostname: 127.0.0.1 but that didn’t work either.
3. How to fix mysql-workbench issue?
I looked on internet to find answers for this and tried multiple solutions, but none worked.
Linux mint mysql workbench
There are binary distributions of MySQL Workbench available for several variants of Linux, including Fedora, Oracle Linux, and Ubuntu. For general requirements and specific installation instructions, see the sections that follow.
Installation options include:
Official MySQL Yum or APT repository packages : These binaries are built by the MySQL Release team. For additional information about installing these, see Yum or APT. They contain the newest versions of MySQL Workbench. Typically this package is named mysql-workbench-community .
Your Linux distributions repository packages : These binaries are built and maintained by members of the Linux distribution you use, and not by the MySQL team. They are stable but the releases often lag behind. Typically this package is named mysql-workbench .
Download official MySQL packages : Downloads are available at https://dev.mysql.com/downloads/workbench.
Download the source code and compile yourself : The source code is available at https://dev.mysql.com/downloads/workbench as a tar.gz or RPM package.
32-bit binary builds are not available as of MySQL Workbench 6.2.0. You can use the source code to build your own 32-bit version, as needed.
The procedure for installing on Linux depends on which Linux distribution you are using.
Requirements for Linux
The requirements for Linux are embedded within their respective packages. Use the platform specific tool (for example, yum or apt) to install the package and their dependencies.
The Save password in vault functionality requires gnome-keyring-daemon to store the passwords. Note that KDE systems use their own ksecretservice implementation.
For Linux and macOS, the MySQL server administration features require sudo command privileges to execute several commands. The sudo user must be capable of executing the following system commands:
Additionally, the sudo user must keep the HOME environment variable when executing system commands, which means adding the following entry to the /etc/sudoers file safely by using the visudo command:
For MySQL Workbench to execute MySQL Enterprise Backup commands, the sudo command user must also be able to execute the MySQL Enterprise Backup binary.
Installing DEB packages
On Ubuntu, and other systems that use the Debian package scheme, you can either download and install .deb packages or use the APT package manager.
Using the APT Package Manager
Your Linux distribution includes MySQL Workbench builds where «apt-get install mysql-workbench» will install their build of the MySQL Workbench package. To use the official MySQL Workbench builds as provided by the MySQL Release team, you must install the official MySQL APT repository and choose the «mysql-workbench-community» package instead of «mysql-workbench».
First, install the MySQL APT repository as described in the MySQL APT Repository documentation. For example:
Next, install MySQL Workbench. You might have multiple Workbench packages available, so choose the «mysql-workbench-community» version. For example:
Installing a Package Manually
You install MySQL Workbench using a command such as:
package .deb is the MySQL Workbench package name; for example, mysql-workbench-community- version 1ubu1404-amd64.deb , where version is the MySQL Workbench version number.
You may be warned that certain libraries are not available, depending on what you already have installed. Install the required libraries and then install the MySQL Workbench package again.
Installing RPM packages
On Red Hat-based systems, and other systems that use the RPM package format, you can either download and install RPM packages or use the Yum package manager.
Enterprise Linux systems, such as Oracle Linux and Red Hat, may require access to the EPEL package repository. For additional information about installing EPEL, see Installing Oracle Enterprise Linux and Similar.
Using the Yum Package Manager
Your Linux distribution includes MySQL Workbench builds where «yum install mysql-workbench» will install their build of the MySQL Workbench package. To use the official MySQL Workbench builds as provided by the MySQL Release team, you must install the official MySQL Yum repository and choose the «mysql-workbench-community» package instead of «mysql-workbench».
First, install the MySQL Yum repository as described in the MySQL Yum Repository documentation. For example:
Next, install MySQL Workbench. You might have multiple Workbench packages available, so choose the «mysql-workbench-community» version. For example:
Manually Installing a Package
package .rpm is the MySQL Workbench package name; for example, mysql-workbench-community- version -1fc10.x86_64.rpm , where version is the MySQL Workbench version number.
Installing Oracle Enterprise Linux and Similar
MySQL Workbench requires access to the EPEL repository only if you are working with spatial data, but not for general use. Earlier versions of MySQL Workbench (before 8.0.18) require access to it for all use cases. EPEL is a repository with additional RPM packages that are not part of the core RHEL/OEL distribution. This includes packages (such as tinyxml) that MySQL Workbench requires.
You need to set up the EPEL repository in yum to resolve the required dependencies. For example, using Oracle Linux 6.8 you would:
These instructions also apply to similar Linux distributions such as Red Hat Enterprise Linux, CentOS, and Scientific Linux.
Next, follow the RPM-based installation documentation at Installing RPM packages.