- ArchPKGs
- The Simplest Guide on Installing mysql on Arch-Based Linux (Manjaro/ArcoLinux)
- Table of Contents
- Install link
- Install with pacman link
- Install with yay link
- Update link
- Update with pacman link
- Update with yay link
- Uninstall link
- Uninstall with pacman link
- Uninstall with yay link
- More Guides
- How to Install perl-string-perlquote with One Command on Arch-Based Linux (Manjaro, Parabola)
- charles Install (Update, Uninstall) Guide on Arch-Based Linux (Manjaro/RebornOS)
- airspy Install (Update, Remove) Guide on Arch-Based Linux (Manjaro, BlackArch)
- wasm-gc Install, Update and Uninstall Guide on Arch-Based Linux (Manjaro/Artix)
- collage-git Install/Update/Remove Guide on Arch Linux (Manjaro/Parabola)
- The Simplest Tutorial on osmosisd-bin Installation on Arch Linux, Manjaro and BlackArch
- How to install MySQL Workbench on Manjaro Linux
- How to install MySQL Workbench on Manjaro Linux
- Method 1: How to install MySQL Workbench using GUI on Manjaro Linux
- Method 2: How to install MySQL Workbench using terminal on Manjaro Linux
- Method A: Installing MySQL Workbench using yay(AUR helper)
- Method B: Installing MySQL Workbench using Pacman
- How to use MySQL-Workbench on Manjaro
- Step 1 : Create MySQL Connection
- Step 2 : Check the server status
- Step 3 : Add new Schema
- Step 4 : Create Tables
- Conclusion
ArchPKGs
The Simplest Guide on Installing mysql on Arch-Based Linux (Manjaro/ArcoLinux)
«Fast SQL database server, community edition» is the developer’s description of mysql . To install this package ( mysql ) from AUR (Arch User Repository) on Arch Linux, Manjaro, EndeavourOS, Anarchy and Garuda is pretty straightforward. This guide will taught you how to install, update and uninstall the package with either the default package manager pacman or an AUR helper like yay .
Table of Contents
Install link
Two common ways are used to install mysql from AUR. pacman is the choice for you if you are an expert of Arch Linux and know the concept of how packages are built. If not, yay is a popular alternative to install packages without the hassle of reviewing PKGBUILD and build packages with makepkg by yourself.
Install with pacman link
sudo pacman -S --needed git && git clone https://aur.archlinux.org/mysql.git && cd mysql && makepkg -si
- Install git if required (not installed before).
- clone the package’s git repository from upstream URL.
- cd into the directory.
- Use makepkg to build the package. Also, it will automatically be installed with pacman afterwards.
Install with yay link
Update link
Updating AUR packages is practically the same as installing them. Simply pull it from upstream then re-build it. Nevertheless, it is still recommended to upgrade your whole system first with sudo pacman -Syu before updating any packages to avoid dependency issues, since Arch is a rolling-release Linux distribution.
Update with pacman link
Before running the command, make sure you’re in the directory of the repository you previously cloned:
git pull && makepkg -si
- pull from the package’s git repository.
- Use makepkg to build the package, then update it with pacman .
Update with yay link
Uninstall link
Compared to installing and updating packages, uninstalling is the simplest of these three,all you have to do is choose whether to purge the unused dependencies and the configuration files used by the package.
Uninstall with pacman link
sudo pacman -R mysql
sudo pacman -Rs mysql
sudo pacman -Rns mysql
Uninstall with yay link
yay -Rns mysql
Learn more details about how to build AUR packages on Arch-based Linux distros, please refer to this post from NoCache.
More Guides
How to Install perl-string-perlquote with One Command on Arch-Based Linux (Manjaro, Parabola)
«Quote a string as Perl does» is their description of perl-string-perlquote. To get this package (perl-string-perlquote) from AUR (Arch User Repository) on Arch Linux and Arch-based distributions (e.g. Manjaro, EndeavourOS, RebornOS, Parabola, Artix) is fairly easy. This guide will show you step-by-step how to install, update and remove the package with either the built-in package manager pacman or an AUR helper like yay.
charles Install (Update, Uninstall) Guide on Arch-Based Linux (Manjaro/RebornOS)
«Web debugging proxy application» is the maintainer’s description of charles. To install this package (charles) from AUR (Arch User Repository) on Arch Linux and Arch-based distributions (e.g. Manjaro, EndeavourOS, Garuda, BlackArch, Anarchy) is relatively straightforward. This tutorial will cover how to install/update/uninstall the package with either the default package manager pacman or an AUR helper (e.g. yay).
airspy Install (Update, Remove) Guide on Arch-Based Linux (Manjaro, BlackArch)
extra/airspy is «Host code for Airspy SDR.» quoting from its definition. To install or uninstall this package (extra/airspy) from Arch official repository (Extra) on Arch Linux and Arch-based Linux distros (e.g. Manjaro, EndeavourOS, Garuda, ArcoLinux) is relatively easy. This guide will show you step-by-step how to install/update/remove the package with either the default package manager pacman or an AUR helper like yay.
wasm-gc Install, Update and Uninstall Guide on Arch-Based Linux (Manjaro/Artix)
«gc-sections for wasm» is their outline of wasm-gc. To install this package (wasm-gc) from AUR (Arch User Repository) on Arch Linux, Manjaro, EndeavourOS, RebornOS, Artix, BlackArch and Parabola is relatively easy. This tutorial will show you step-by-step how to install/update/remove the package with either the default package manager pacman or an AUR helper like yay.
collage-git Install/Update/Remove Guide on Arch Linux (Manjaro/Parabola)
«A command-line tool to create a collage from a collection of photos/images.» is their description of collage-git. To install collage-git from AUR (Arch User Repository) on Arch Linux and Arch-based distros (e.g. Manjaro, EndeavourOS, RebornOS, BlackArch, Anarchy) is comparatively simple. This tutorial will be covering how to install/update/uninstall the package with either the default package manager pacman or an AUR helper like yay.
The Simplest Tutorial on osmosisd-bin Installation on Arch Linux, Manjaro and BlackArch
osmosisd-bin is «The AMM Laboratory on Cosmos» according to its own profile. To install osmosisd-bin from AUR (Arch User Repository) on Arch Linux and Arch-based Linux distributions (e.g. Manjaro, EndeavourOS, RebornOS, Parabola) is quite straightforward. This guide will cover how to install, update and remove the package with either the built-in package manager pacman or an AUR helper like yay.
More guides… copyright 2023 ArchPKGs. All Rights Reserved.
How to install MySQL Workbench on Manjaro Linux
MySQL Workbench is a multipurpose database management tool that integrates several SQL artifacts. It has a set of features to offer such as SQL development, data modeling, user administration, server configuration, database administration, and many more. The functionalities provided by MySQL Workbench are practiced by Database Administrators and MySQL developers of the organizations using MySQL database management.
MySQL Workbench offers cross-platform support and can be installed on various Linux distributions as well. In this post, a detailed guide is provided that addresses the following objectives:
How to install MySQL Workbench on Manjaro Linux
In this guide, several methods and their respective steps are provided that direct you to the installation of MySQL Workbench. There are two methods to get MySQL Workbench on Manjaro and are mentioned below:
– Using Graphical User Interface
– Using Command Line Interface
Both methods are described briefly in the upcoming sections.
Method 1: How to install MySQL Workbench using GUI on Manjaro Linux
To get MySQL workbench in Manjaro, you have to follow the steps mentioned below:
Step 1: Click on the “Show Applications” option on the desktop:
Step 2: Once the applications window is opened; click on “Add/Remove Software“.
Step 3: After that, navigate to the search icon on the top left corner of the window.
Step 4: A search bar will be displayed in the center of the menu bar. Now, write “mysql-workbench” to look for packages. After that, you will get the “MySQL Workbench” package as shown in the image below.
Step 5: After that, navigate to the install button, as soon as you click on the button it will turn to the “tick” mark and an “Apply” button will be displayed on the foot bar of the window. For further proceedings, click on “Apply“:
Step 6: After clicking on “Apply“, an authentication prompt will appear. You must enter your password correctly to proceed further.
Step 7: After that, you will be prompted with a window that contains the list of additional packages that are recommended to work with MySQL Workbench. To grant permission, click on “Apply“:
After that, the installation process will start that may take several minutes.
Once the installation is completed, the green button will turn to remove (red) button that shows the installation has successfully completed.
To locate the installed package, click on “Show Applications” icon on the desktop and you will find the newly installed “MySQL Workbench” there:
Method 2: How to install MySQL Workbench using terminal on Manjaro Linux
This method explains the MySQL Workbench installation using the terminal of Manjaro Linux. There are two ways to use command line support to get MySQL Workbench on Manjaro Linux.
Method A: Installing MySQL Workbench using yay(AUR helper)
The yay is the helper for AUR(Arch User Repository) and is used to install/uninstall packages. The below-mentioned command will install MySQL Workbench on Manjaro Linux:
You can verify the installation by executing the following command using terminal:
And the above command will start the MySQL Workbench application:
Method B: Installing MySQL Workbench using Pacman
Pacman is a package manager of Manjaro Linux-like apt in Debian-based distributions. One can use Pacman to install MySQL workbench on Manjaro.
Step 1: Firstly, update the package’s database by issuing the below-stated command.
Step 2: Once you have performed the updating, you can install MySQL Workbench with the help of the given command.
Or, if you use the “-Syu” flag to install the package, then pacman updates the database and installs the package in a single command. So, you can perform that multitask by issuing commands mentioned below.
Step 3 : To verify the installation, you can run MySQL workbench on your Manjaro system from the terminal by entering the following keywords.
How to use MySQL-Workbench on Manjaro
This section contains the usage of MySQL Workbench on Manjaro, and the below-mentioned steps will lead you to uninterrupted connection and use of MySQL Workbench.
Step 1 : Create MySQL Connection
Open the MySQL Workbench and click on the “+” icon as shown below.
After doing so, you would get a connection interface where you have to create a new connection as follows.
– Choose the connection method “Local Socket/Pipe”
– Type a connection name, it can be any as per your wish. We have named it “linuxhint”
– Insert the Socket/Pipe Path “/var/run/mysqld/mysqld.sock“. You can do it manually by copying the right path or navigating to three horizontal dots and searching for “/var/run/mysqld/mysqld.sock”
After configuring, click on “OK” to proceed further.
The time you click on “OK“, the connection will be created and you can run it.
To run “linuxhint” connection, click on “linxuhint‘ and you would get the following interface.
Step 2 : Check the server status
Now, you must check the SQL server status by navigating to “Server Status” on the left pane of the window:
And you can see that the server is running.
Step 3 : Add new Schema
Click on the add schema icon as shown below:
Choose the schema name and click on “Apply“:
The next prompt will show you the query to create SQL Schema, navigate to “Apply“.
After successful application of the query, the Schema will be added, and click on “Close“.
You can observe that the Schema is created with the name “linux“.
Step 4 : Create Tables
As observed, the “Tables” option is there. Right click on the “Tables” and then navigate to “Create Table“.
You would find the interface where you have to enter the “Table Name” and enter its field and then click on “Apply“.
After successful creation, it will appear under the “linux” named database.
To perform any operation on the table, MySQL Workbench provides the built-in set of queries. To use any query, right-click on the table and choose “Send to SQL Editor“.
Insert Statement: Like here we are using “Insert Statement”, the time you click on “Insert Statement”, you will get the following syntax of INSERT query.
You can add values by replacing the values as we have done and then the query can be executed by clicking on the blitz icon. If the query is correct, then it will be executed(without showing any prompt), otherwise, it will return errors.
Select All Statement: To retrieve inserted data, you may navigate to the “Select All Statement”.
After clicking, you will get a built-in query of the Select All statement.
When you will execute this query, the result will be displayed in a new pane as can be seen below.
By following the same ways as mentioned above, you can use update and delete queries as well.
Conclusion
MySQL Workbench is a widely used graphical tool to work on MySQL databases and servers. This tool can be used by database stakeholders, like Database administrators, developers, and designers. This writeup is focusing on installing and using MySQL workbench on Manjaro. The installation is performed here using graphical and command line support of Manjaro. The usage of MySQL Workbench is demonstrated from scratch, like creating a connection, checking the server status, adding new schema, and creating tables. Moreover, you can also perform several operations on tables by using built in SQL queries.