Created
August 25, 2020 12:29
-
-
Save morshadunnur/d8d2409a07278b49daac6809dbea5d93 to your computer and use it in GitHub Desktop.
Install Maria DB on Ubuntu
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
// Add Repository | |
sudo apt-get install software-properties-common | |
sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc' | |
sudo add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://sgp1.mirrors.digitalocean.com/mariadb/repo/10.5/ubuntu bionic main' | |
// Install Mariadb Server | |
sudo apt update | |
sudo apt install mariadb-server | |
sudo mysql -u root | |
select user,password, plugin, host from user; | |
UPDATE user SET plugin='mysql_native_password' WHERE User='root'; | |
SET Password for 'root'@'localhost' = PASSWORD('secret') | |
//Create Another User | |
CREATE USER 'frontliner'@'localhost' IDENTIFIED BY 'secret'; | |
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost'; | |
FLUSH PRIVILEGES; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment