Created
February 28, 2021 14:40
-
-
Save oddlyspaced/8856bd3db5132ef3714ecc40a9fe37ea to your computer and use it in GitHub Desktop.
Step by step guide to properly install MySQL Server and MySQL-Workbench on Arch Linux and other based distributions like Manjaro etc.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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. | |
it is system generated as far as I remember
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
what would the dummy password be