Install MySQL Server on Ubuntu

Why

1. I am working on an autoposting tool for social sites.
2. in order to complete that i want a db to log the metadata of my posts

Parts of this series

1. part 1
2. part 2

MYSQL Resources

• APT install guide
• MYSQL config guide
• Post Install configuration

Install

Download the config files

go to this link and download the script.

https://dev.mysql.com/downloads/repo/apt/

Install the release package with dpkg

note that the w.x.y.z will change according to the release package

run

sudo dpkg -i mysql-apt-config_w.x.y-z_all.deb

in my case i ran

sudo dpkg -i mysql-apt-config_0.8.30-1_all.deb 

Update apt and install

so the package above just added the mysql repository to the apt package manager. to actually install we will run

sudo apt-get update &&  sudo apt-get install mysql-server

Start mysql

mysql will likely alrady be running post install. Check the status by running

systemctl status mysql