- How to install mysql workbench in debian buster?
- How to install MySQL WorkBench in Debian wheezy Operating System?
- 2 Answers 2
- How to Install MySQL Workbench on Debian 11
- MySQL Workbench Alternatives:
- Dbeaver:
- Navicat:
- Data Grip:
- phpMyAdmin:
- Conclusion:
- About the author
- David Adams
- Как установить MySQL Workbench на Debian 10
- Установите MySQL Workbench на Debian 10 Buster
- Шаг 1. Перед запуском приведенного ниже руководства важно убедиться, что ваша система обновлена, выполнив следующие apt команды в терминале:
- Шаг 2. Установка MySQL Workbench в Debian 10.
- Шаг 3. Доступ к MySQL Workbench в Debian.
How to install mysql workbench in debian buster?
I did manage to install without issues MySQL Workbench 8.0.19 version from an Ubuntu package in Debian Buster, with the command:
sudo dpkg -i mysql-workbench-community_8.0.19-1ubuntu18.04_amd64.deb First you must download the package from the mysql website:
Just select Ubuntu Linux operating system and 18.04 version (19.10 version had broken dependencies) .
it seems to be working but I got this error: /usr/bin/mysql-workbench-bin: error while loading shared libraries: libpcrecpp.so.0: cannot open shared object file: No such file or directory
That worked, but to avoid an error when saving schema’s in Buster I needed to add the US locale: — Uncomment en_US.utf8 in /etc/locale.gen — Run locale-gen — Confirm with locale -a and restart MySQL Workbench
MySQL Workbench mysql-workbench has been removed from Debian buster due to a release-critical bug.
If you are willing to work with a critical bug, you can download an Ubuntu version from downloads.mysql.com/archives/workbench. Then from a terminal install it with sudo dpkg -i. Then you need to open synaptic package manager which will notice the broken package. Use Edit > Fix Broken Package, then Apply the changes. Workbench will not load for you with a WARNING. So be careful how much you count on it. An alternative I’ve used is dbeaver.
It can also be installed from Snapcraft. I haven’t used it that much, but apparently it works. First you need to enable snapd:
Then install MySQL workbench (community edition):
$ sudo snap install mysql-workbench-community
If you want to delete it, simply:
$ sudo snap remove mysql-workbench-community
I was able to install the latest version of MySQL Workbench (as of this writing) on Debian 10 using this method:
sudo apt install ./mysql-workbench-community_8.0.23-1ubuntu20.10_amd64.deb A couple dependencies were missing so I subsequently ran:
sudo apt --fix-broken install Just started using it, but MySQL Workbench seems to be running fine. It’s also worth mentioning the link below states MySQL Workbench community is not available on Debian, although I’m not sure why this is the case.
mysql-workbench-community — MySQL Workbench (not available for Debian platforms)
Command line to install mysql on Debian 10:
$ sudo apt update $ sudo apt upgrade $ wget http://repo.mysql.com/mysql-apt-config_0.8.13-1_all.deb $ sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb Remember to make safe passwords with lettler numbers and symbols
$ sudo apt update $ sudo apt install mysql-server $ sudo apt-get build-dep mysql-server $ wget https://downloads.mysql.com/archives/get/file/mysql-workbench-community_8.0.16-1ubuntu18.04_amd64.deb $ sudo dpkg -i mysql-workbench-community_8.0.16-1ubuntu18.04_amd64.deb $ sudo apt install -f $ sudo dpkg -i mysql-workbench-community_8.0.16-1ubuntu18.04_amd64.deb How to install MySQL WorkBench in Debian wheezy Operating System?
I tried to install MySQL workbench in Debian Operating System by using workbench for linux distribution, but its not working.
What is your error message? What is not working? What have you tried? Please provide more information
2 Answers 2
sudo apt-get install mysql-workbench This will install mysql workbench ONLY on debian. Both wheezy and Jessie. Also works on ubuntu.
A common method is to use the operating system’s package system. For Debian, MySQL recommends installing the official APT repository and then use apt-get as you would normally. The official repositories contain most MySQL products and typically they are newer versions than the versions provided by vendors such as Debian, Ubuntu, Fedora, CentOS, Ubuntu, and so on.
So, for Debian, download the appropriate APT file and then execute something like the following (The mysql-apt-config_0.3.5-1debian8_all.deb file name that you download might be different, so adjust that accordingly):
cd ~/Downloads sudo dpkg -i mysql-apt-config_0.3.5-1debian8_all.deb sudo apt-get update sudo apt-get install mysql-workbench-community
You might notice that both mysql-workbench and mysql-workbench-community packages will be available via apt-get, but mysql-workbench-community is the package you want. Use «apt-cache show » on both packages to see the difference.
Installing the package file (mysql-apt-config_0.3.5-1debian8_all.deb above) is a one time deal, so feel free to skip this step when updating Workbench or installing other MySQL products.
How to Install MySQL Workbench on Debian 11
This tutorial explains how to install MySQL Workbench on Debian 11 and Linux-based distributions properly.
Currently, the official MySQL Workbench installation method doesn’t work properly on Debian 11. Some users report the MySQL Workbench repository isn’t added properly, and manual addition does not solve the problem. Other users complain the manual installation for Ubuntu doesn’t work with Debian, and I can confirm that. Yet, installing MySQL Workbench on Debian 11 is pretty easy using Snap.
Before installing MySQL Workbench on Debian 11, update your repositories as shown in the following screenshot:
Install the snapd package by running the following command:
Install core files using Snap by running the following command:
Now, to install MySQL Workbench using Snap, run the command below:
Once installed, you can find MySQL Workbench on the Application Finder as shown in the image below or on your applications menu:
And as you can see, MySQL Workbench opens properly:
On Debian 11, you’ll notice a warning saying the operating system is unsupported. Currently, the operating systems supported by MySQL Workbench are Ubuntu, Red Hat Enterprise, Oracle Linux, Fedora, and Microsoft Windows. The fact your system isn’t officially supported can be ignored, and it does not mean you’ll encounter errors. However, below I decided to add some Linux compatible MySQL Workbench alternatives.
You can get additional information on MySQL Workbench at https://www.mysql.com/products/workbench/.
MySQL Workbench Alternatives:
As you can see, many Linux distributions, including Debian 11, are not officially supported by MySQL Workbench. That’s why I decided to add a brief description of some of the most popular alternatives to manage and develop MySQL (and other) databases.
Dbeaver:
Dbeaver is an open-source and free tool to manage databases. Dbeaver is multiplatform (Available for Linux, Windows, and Mac). This tool supports not only MySQL but also PostgreSQL, SQLite, Oracle, SQL Server, DB2, Teradata, MS Access, Sybase, Firebird, Apache Hive, and more. Users can write their plugins. DBeaver supports Cloud data sources, and it can be integrated with Excel, Git, and other extensions, among other features. Dbeaver has a free Community version and a paid Enterprise version. This tool is widely supported by the community, which also features CloudBeaver to manage databases from the web browser.
You can download Dbeaver or read more information on it at https://dbeaver.io/.
Navicat:
Navicat is another MySQL Workbench alternative. Navicat is not free. The cheaper plan costs $15.00 per month. Navicat is a multiplatform, available for Linux, macOS, iOS, and Microsoft Windows. Navicat is used to manage and develop MySQL and MariaDB databases. When using Navicat, you can connect to multiple MySQL and MariaDB simultaneously. Navicat is also compatible with cloud databases, intuitive, and graphically powerful.
You can download Navicat 15 for MySQL or get additional information at https://www.navicat.com/.
Data Grip:
Data Grip is another tool, also available for Linux, to create and modify database objects. Data Grip supports MySQL, PostgreSQL, Oracle Database, SQL Server, HyperSQL, Apache Derby, Exasol, Azure, Amazon Redshift, and more engines. With Data Grip, you can add, edit, remove, and clone data rows. It was designed to browse and search data easily. Data Grip features a user-friendly interface to add and edit tables, indexes, columns, and more. It also provides a smart code completion function, code supervision, and on-the-fly error warning with quick fixes capabilities. Data Grip isn’t free, but it offers a 30-day trial you can use to test it.
To download Data Grip or get additional information on it, visit https://www.jetbrains.com/datagrip/.
phpMyAdmin:
phpMyAdmin is probably the most popular alternative. Present in almost every hosting service, phpMyAdmin is one of the most popular tools to manage MySQL through the web. This is an excellent tool to manage databases, tables, relations, columns, indexes, users, and more. It features an intuitive web interface, allowing you to import and export data in CSV and SQL formats. With phpMyAdmin, you can manage multiple servers, create graphics of your database, address complex queries, search globally, and convert data into a different format.
To get additional information on phpMyAdmin, you can visit https://www.phpmyadmin.net/.
Conclusion:
As you can see, installing MySQL Workbench on Debian 11 is pretty easy, even when Debian 11 isn’t officially supported. Users simply must install it using Snap instead of manually installing the package offered on the MySQL website. By using Snap, this process is extremely easy, and any Linux level user can achieve it by following a few steps. Additionally, users have a variety of alternatives in case their system isn’t officially supported. All MySQL Workbench alternatives listed in this tutorial are compatible with Linux.
Thank you for reading this tutorial explaining how to install MySQL Workbench on Debian 11. Keep following Linux Hint for additional Linux tutorials and tips.
About the author
David Adams
David Adams is a System Admin and writer that is focused on open source technologies, security software, and computer systems.
Как установить MySQL Workbench на Debian 10
В этом руководстве мы покажем вам, как установить MySQL Workbench на Debian 10. Для тех из вас, кто не знал, MySQL Workbench — это инструмент с графическим интерфейсом для управления серверами MySQL. Вы можете использовать этот инструмент для управления вашим сервером MySQL, установленным локально или удаленно. В нем есть много важных инструментов, необходимых для создания, редактирования, удаления баз данных, создания и редактирования пользователей, таблиц и многого другого.
В этой статье предполагается, что у вас есть хотя бы базовые знания Linux, вы знаете, как использовать оболочку, и, что наиболее важно, вы размещаете свой сайт на собственном VPS. Установка довольно проста и предполагает, что вы работаете с учетной записью root, в противном случае вам может потребоваться добавить ‘ sudo ‘ к командам для получения привилегий root. Я покажу вам пошаговую установку MySQL Workbench на Debian 10 (Buster).
Установите MySQL Workbench на Debian 10 Buster
Шаг 1. Перед запуском приведенного ниже руководства важно убедиться, что ваша система обновлена, выполнив следующие apt команды в терминале:
sudo apt update sudo apt install ca-certificates
Шаг 2. Установка MySQL Workbench в Debian 10.
Теперь мы загружаем файл конфигурации репозитория с заданного URL https://dev.mysql.com/downloads/repo/apt/ . Когда вы просматриваете этот URL-адрес, вы попадете прямо на страницу загрузки, откуда вы будете загружать ‘ ‘ (вы можете получить последнюю версию, поэтому версия № может быть изменена): mysql — apt — config_0 . 8.15 — 1 _all . deb
sudo apt install ./mysql-apt-config_0.8.16-1_all.deb
Затем пришло время установить рабочую среду MySQL с использованием репозитория apt:
sudo apt update sudo apt install mysql-workbench-community
Выполните следующую команду, чтобы установить его:
sudo apt install snapd snap install core snap install mysql-workbench-community
Шаг 3. Доступ к MySQL Workbench в Debian.
После успешного завершения установки вы можете запустить приложение и подключиться к серверу базы данных, чтобы начать управление из графического интерфейса, или вы можете запустить его с помощью терминала, введя следующую команду:
Поздравляю! Вы успешно установили MySQL Workbench . Благодарим за использование этого руководства для установки последней версии MySQL Workbench в системе Debian. Для получения дополнительной помощи или полезной информации мы рекомендуем вам посетить официальный сайт MySQL .