apfelcast

MariaDB

Mar 1st, 2021
1,070
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. ## install software-properties-common ##
  2. apt install software-properties-common
  3.  
  4. ## add maria db repository ##
  5. add-apt-repository 'deb [arch=amd64,arm64,ppc64el] http://sfo1.mirrors.digitalocean.com/mariadb/repo/10.3/ubuntu bionic main'
  6.  
  7. ## add GPG Public Key ##
  8. apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
  9. apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8
  10.  
  11. ## update ##
  12. apt update
  13.  
  14. ## Set innodb_fast_shutdown to 0 ##
  15. mysql
  16. SET GLOBAL innodb_fast_shutdown=0;
  17.  
  18. ## stop MariaDB ##
  19. service mariadb stop
  20.  
  21. ## Uninstall the old version of MariaDB ##
  22. apt remove mariadb-server
  23.  
  24. ## Install the new version of MariaDB ##
  25. apt update
  26. apt install mariadb-server
  27.  
  28. choose N
  29.  
  30. ## start MariaDB ##
  31. service mariadb start
  32.  
  33. ## Run mysql_upgrade ##
  34. mysql_upgrade
  35.  
  36. ## if error ##
  37.  
  38. nano /etc/mysql/mariadb.conf.d/50-server.cnf
  39.  
  40. add the line below [mysqld] section.
  41.  
  42. plugin-load-add = auth_socket.so
  43.  
  44. service mariadb restart
Advertisement
Add Comment
Please, Sign In to add comment