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.

what would the dummy password be

it is system generated as far as I remember

greak work bro 👍

This worked very well. Thank you! 🐿️

I've got this problem after makepkg -si "One or more PGP signatures could not be verified!".Do you have any solution?

I've got this problem after makepkg -si "One or more PGP signatures could not be verified!".Do you have any solution?

Open the PKGBUILD file with a text editor and look for the validpgpkeys section. Copy the fingerprint and then enter gpg --recv-keys FINGERPRINT into the terminal.

I've got this problem after makepkg -si "One or more PGP signatures could not be verified!".Do you have any solution?

You can add --skippgpcheck as the command line parameter in the makepkg command if nothing else works. However do try to fix the makepkg issue, since pgp keys should be kept valid.

I've got this problem after makepkg -si "One or more PGP signatures could not be verified!".Do you have any solution?

You can add --skippgpcheck as the command line parameter in the makepkg command if nothing else works. However do try to fix the makepkg issue, since pgp keys should be kept valid.

thank you it works

I paste the system generated password and it shows "access denied for user 'root'@'localhost' (using password: yes)"

I paste the system generated password and it shows "access denied for user 'root'@'localhost' (using password: yes)"

No need anymore I finally done the mysql installation.Thank you so much.

thank you it works!!!

I paste the system generated password and it shows "access denied for user 'root'@'localhost' (using password: yes)"

No need anymore I finally done the mysql installation.Thank you so much.

I'm now facing this issue, how did you fix it? can you share please?

When you run the mysqld command check the output, it generates and prints a password there.

When you run the mysqld command check the output, it generates and prints a password there.

Yep, I copied the password, and enter that password, still printing output like that.

Yep, I copied the password, and enter that password, still printing output like that.

Finally, it works now, there was Mariadb installed and I forgot that was configured. I uninstalled everything and follow this instruction again. Thank you :D
But fyi, there's a warning message that is not supported and asking me to use MySQL workbench version 6.3

how passwd change?