Step by step guide to properly install MySQL Server and MySQL-Workbench on Arch Linux and other based distributions like Manjaro etc.

arch-install-mysql-workbench

# Part 0 - Updating system
sudo pacman -Syyu

# Part 1 - Installing software dependencies
sudo pacman -S git gnome-keyring

# Part 2 - Compile and Install MySQL Server
# (This might take like ~4 hours since it's compiling the source)
git clone https://aur.archlinux.org/mysql.git
cd mysql
makepkg -si

# Part 3 - Install MySQL-Workbench
sudo pacman -S mysql-workbench

# Part 4 - Setting up database
sudo rm -rf /var/lib/mysql
sudo mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql
# ^ Once the above command is executed successfully, make sure to copy paste the demo password displayed at screen!

# Part 5 - Enabling the service
sudo systemctl enable --now mysqld

# Part 6 - Verifying
mysql -u root -p
# ^ Enter your dummy password from Part 4

# Part 7 - Loading up Workbench
# Launch MySQL Workbench from menu
It should display a local connection.
Right click and edit the connection and save your dummy password in the config from Part 4. (Next line for more refrence)
Make sure to click on "Store in Keychain" and generate a new keychain by setting up a password.