MySQL#

MySQL 是目前主流的關聯式資料庫其中之一，最早在 1994 年由瑞典一家公司的團隊 MySQL AB 開發，後來在 2008 年被昇陽（Sun）公司收購，接著在2010 年隨著昇陽被甲骨文（Oracle）收購，MySQL 現在也是甲骨文旗下的產品。

Install#

1. download:

   $ wget https://dev.mysql.com/get/mysql-apt-config_0.8.12-1_all.deb && \
   $ sudo dpkg -i mysql-apt-config_0.8.12-1_all.deb

2. select this options:

   Bionic -> MySQL Server and Cluster -> mysql-5.7 -> ok

3. add key:

   #sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 467B942D3A79BD29
   $ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys B7B3B788A8D3785C && \
   $ apt-get update

4. check available mysql versions:

   $ apt-cache policy mysql-server

   mysql-server:
       Installed: (none)
       Candidate: 8.0.27-0ubuntu0.20.04.1
       Version table:
           8.0.27-0ubuntu0.20.04.1 500
               500 http://ru.archive.ubuntu.com/ubuntu focal-updates/main amd64 Packages
               500 http://ru.archive.ubuntu.com/ubuntu focal-security/main amd64 Packages
           8.0.19-0ubuntu5 500
               500 http://ru.archive.ubuntu.com/ubuntu focal/main amd64 Packages
           5.7.37-1ubuntu18.04 500
               500 http://repo.mysql.com/apt/ubuntu bionic/mysql-5.7 amd64 Packages

5. and install it:

   apt install -f mysql-client=5.7* mysql-community-server=5.7* mysql-server=5.7*

Setting in up#

Operate#

Reference#

Official docs:

MySQL Installer Guide