Skip to content

Instantly share code, notes, and snippets.

@morshadunnur
Created August 25, 2020 12:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save morshadunnur/d8d2409a07278b49daac6809dbea5d93 to your computer and use it in GitHub Desktop.
Save morshadunnur/d8d2409a07278b49daac6809dbea5d93 to your computer and use it in GitHub Desktop.
Install Maria DB on Ubuntu
// 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