How to Install MySQL Server on Ubuntu 20.04 LTS - Golang Web Development
In this Golang Web Development Series #16, we will install the MySQL Server as our database in preparations for Golang's MySQL CRUD operations with step by step guide here in Golang's Web Development Series.
#MaharlikansCode
#GolangWebDevelopment16
#GolangMySQL
#InstallMySQLServerOnUbuntu
#GolangTutorial
#LearnGolangWebDevelopment
#Golang
#LifeAsSoftwareDeveloper
#Maharlikans
#FilipinoSoftwareDeveloper
Get Linode Account:
https://www.linode.com/?r=6aae17162e9...
If you go with extra mile for buying me a cup of coffee, I appreciate it guys: https://ko-fi.com/maharlikanscode
Installation Guides:
sudo apt update
sudo apt install mysql-server
sudo mysql_secure_installation
sudo mysql -u root -p
This is for the phpMyAdmin:
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'userPassword@';
CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'userPassword@';
GRANT CREATE, ALTER, DROP, INSERT, UPDATE, DELETE, SELECT, REFERENCES, RELOAD on . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION;
