Installing MySQL on Oracle Cloud’s “Always Free” Compute Instance
November 14, 2019 2 Comments
At Oracle’s OpenWorld 2019, Oracle announced an Oracle Cloud Free Tier, which includes Oracle Cloud services that will always be free – as long as you use them or keep them active.
Most other hyperscale cloud vendors offer a free 12-month trial before they start charging you, so to see Oracle provide a “truly free” service is really great. And the free services are not just limited to one or two choices – you get a wide variety of free services to choose from. As of this blog post, here is a brief summary of free services (these are subject to change in the future):
Databases – Your choice of Autonomous Transaction Processing or Autonomous Data Warehouse. 2 databases total, each with 1 OCPU and 20 GB storage.
Storage – 2 Block Volumes, 100 GB total. 10 GB Object Storage. 10 GB Archive Storage.
Compute – 2 virtual machines with 1/8 OCPU and 1 GB memory each.
Additional Services – Load Balancer, 1 instance, 10 Mbps bandwidth. Monitoring, 500 million ingestion datapoints, 1 billion retrieval datapoints. Notifications, 1 million delivery options per month, 1,000 emails sent per month. Outbound Data Transfer, 10 TB per month.
For this post, I am going to show you how to create an Oracle Cloud Compute Instance (virtual machine) and install the MySQL Community Edition and MySQL Enterprise Edition (license required) of MySQL on it. Installation is a fairly simple process but there are a few things to note. If you follow these steps, you should be able to have a free cloud instance up and running with MySQL installed in less than a half-hour.
Creating your free Oracle Cloud instance
First, you need to go to Oracle’s Cloud Free Tier website, and register. Yes, this requires that you give them your email address and a method of payment, but you won’t be charged as long as you choose the Oracle Cloud free-tier products. I am not going to go through all of the steps to register your account, but it is fairly easy. Here are a few things to note:
When selecting your home region, be sure that the services you want to use are located in this region. This link will show you the available regions for the “Always Free Cloud Services”. (A region is a localized geographic area.)
After you have registered, you will be taken to the login page and then you will need to enter your email address and password. After a successful login, you will be directed to the dashboard page. At the top of the page, you should see a note that states something like this – “You are in a free trial. When your trial is over, your account will be limited to Always Free resources. Upgrade at any time.” If you are part of a free trial period, this period is for a set amount of money and for a limited time. In other words, if your free trial amount is $300 and one month of services, your free trial for normal (not free) services will expire after you have consumed $300 worth of services or after 30-days. So, you aren’t limited in your initial trial to only using the “Always Free Eligible” services. And, the “Always Free” services will continue to work after the trial period – these services are “always free”.
Note: Some of the images and words on the Oracle Cloud web page might change over time.
| Note: As you are creating your instances, be sure that you only select options that have the “Always Free Eligible” banner. |  |
Creating your compute instance
You are now ready to create your first Compute instance (Virtual Machine). Click on the “Create a VM instance” box.
Notice the “Always Free Eligible” banner at the top right of the box.
On the “Create Compute Instance” page, the first box allows you to name your instance. If you don’t want to keep the auto-generated instance name, you should change it here. (I am going to keep the default instance name.)
The default operating system or image source is Oracle Linux.
If you don’t want to use Oracle Linux, click on the “Change Image Source” button, and you will see a selection of available operating systems to use. Note that not all images are part of the free version.
Next, click on the “Show Shape, Network and Storage Options” to expand this selection.
The first option is to choose your Availability Domain, but the free option should already be selected. Do not change this option. An Availability Domain is one or more data centers located within a region.
Your Instance Type should be chosen for you, as a Virtual Machine is the only free option.
Your Instance Shape should also be chosen for you. The free Instance Shape version is VM.Standard.E2.1.Micro (Virtual Machine) with 1 Core OCPU and 1 GB Memory.
Under Configure Networking, you can change the virtual cloud network name if you want. I left mine as the default auto-generated name. Important – You will want to select “Assign a public IP address” to be able to connect to this instance from outside of the Oracle Cloud. If you choose “Do not assign a public IP address”, you won’t have a way to connect to this instance unless you connect through another instance from within Oracle Cloud.
You are allocated 100 gigabytes of free storage under the free tier. So, under Boot Volume, you can accept the default size of 46.6 GB, or click “Custom boot volume size (in GB) and enter a smaller or larger number. I am going with the default size. Note: You are limited to two free virtual machines per account under the “Always Free” option.
If you are going to connect to instances using Oracle Linux, CentOS or Ubuntu, you will need to create an SSH key pair. This is very simple to do.
Here is one example of how to create the SSH key pair. You might have to search for how to do it for your particular operating system. The file “id_rsa.pub” is what you will need to upload. You will need to place this file in the $HOME/.ssh directory of the computer you will use to access this compute instance. You can also share this file with others who will want to access this instance.
# ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/var/root/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /var/root/.ssh/id_rsa. Your public key has been saved in /var/root/.ssh/id_rsa.pub. The key fingerprint is: SHA256:od/ZPR2IcW+ml5mcWFa3ojK9c0eeTqsW9eH8T9AQzEI root@Hackintosh.local The key's randomart image is: +---[RSA 2048]----+ | .Eo. | | . o. | | . . o. o| | . . + o=+| | . S . o=O+| | . ..o.oX*B| | .ooo.o*O=| | o..oo*o| | .+.+oo| +----[SHA256]-----+
After you have created the key, you will want to drag-and-drop the SSH key file (it should be named id_rsa.pub) onto the “Drop files here” box. Or you can click “Choose Files” and navigate the window to the location of your SSH key file.
For this demo, I am not going to address any of the advanced options, so I will skip this part:
Finally, you need to click on the “Create” button to create your instance.
You should be directed to the Work Requests page under the Instance Details page, where you will see all of the information about your instance as it is being created.
Towards the bottom, you will see the progress of the instance creation:
It only took a couple of minutes for my instance to be created. The instance page should refresh automatically, but you can manually refresh it. Once the instance has been created, you should see something like this.
Under the Primary VNIC Information, you will see your Public IP Address. You will need this to be able to connect to the instance via SSH.
Now that my instance has been created and is running, I can connect to the Oracle Cloud Compute Instance via a terminal window. I have already placed my SSH key file in the .ssh directory under my $HOME directory.
$ pwd /Users/tonydarnell $ ls -l .ssh/*pub -rw-------@ 1 tonydarnell staff 403 Sep 12 10:58 .ssh/id_rsa.pub
I can connect using SSH and with the user named “opc“. You will probably get a warning about the authenticity of the host, but you can just answer “yes”.
$ ssh opc@150.136.199.99 The authenticity of host '150.136.199.99 (150.136.199.99)' can't be established. ECDSA key fingerprint is SHA256:9ZE+AFYo7luYoBFZhJZ0YS/W6QdQPPJOP9xItnY17+c. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '150.136.199.99' (ECDSA) to the list of known hosts.
I am now connected to my Oracle Cloud Compute Instance. I can check to see which OS version I am running:
$ cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.7 (Maipo)
Installing the MySQL RPM packages via yum
I can now install MySQL but I have to be careful – as MariaDB is the default version of MySQL installed on Oracle Linux (even though MariaDB isn’t the same as MySQL). If you try to run the regular yum install command (sudo yum install mysql), you will see that it tries to install MariaDB:
Note: Be sure to type “N” at the end of this process when asked “Is this ok” so you don’t install MariaDB.
$ sudo yum install mysql Loaded plugins: langpacks, ulninfo ol7_UEKR5 | 2.8 kB 00:00:00 ol7_addons | 2.8 kB 00:00:00 ol7_developer | 2.8 kB 00:00:00 ol7_developer_EPEL | 3.4 kB 00:00:00 ol7_ksplice | 2.8 kB 00:00:00 ol7_latest | 3.4 kB 00:00:00 ol7_oci_included | 2.9 kB 00:00:00 ol7_optional_latest | 2.8 kB 00:00:00 ol7_software_collections | 2.8 kB 00:00:00 (1/12): ol7_ksplice/primary_db | 257 kB 00:00:00 (2/12): ol7_addons/x86_64/updateinfo | 74 kB 00:00:00 (3/12): ol7_addons/x86_64/primary_db | 137 kB 00:00:00 (4/12): ol7_latest/x86_64/updateinfo | 2.6 MB 00:00:00 (5/12): ol7_oci_included/x86_64/primary_db | 71 kB 00:00:00 (6/12): ol7_optional_latest/x86_64/updateinfo | 868 kB 00:00:00 (7/12): ol7_software_collections/x86_64/updateinfo | 8.7 kB 00:00:00 (8/12): ol7_developer/x86_64/primary_db | 441 kB 00:00:00 (9/12): ol7_software_collections/x86_64/primary_db | 4.7 MB 00:00:00 (10/12): ol7_latest/x86_64/primary_db | 15 MB 00:00:00 (11/12): ol7_developer_EPEL/x86_64/primary_db | 11 MB 00:00:01 (12/12): ol7_optional_latest/x86_64/primary_db | 4.0 MB 00:00:00 Resolving Dependencies --> Running transaction check ---> Package mariadb.x86_64 1:5.5.64-1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ====================================================================== Package Arch Version Repository Size ====================================================================== Installing: mariadb x86_64 1:5.5.64-1.el7 ol7_latest 8.7 M Transaction Summary ====================================================================== Install 1 Package Total download size: 8.7 M Installed size: 49 M Is this ok [y/d/N]: N Exiting on user command Your transaction was saved, rerun it with: yum load-transaction /tmp/yum_save_tx.2019-11-04.21-11.NHFXMJ.yumtx
To install a real version of MySQL, you will need to download the release package for your platform. (Full instructions may be found at https://dev.mysql.com/doc/mysql-repo-excerpt/8.0/en/linux-installation-yum-repo.html)
Go to the Download MySQL Yum Repository page (https://dev.mysql.com/downloads/repo/yum/) in the MySQL Developer Zone.
Select and download the release package for your platform. You should see something like this on the Yum download page.
Since I am installing on Oracle Linux 7, I will want to download the RPM package for “Red Hat Enterprise Linux 7 / Oracle Linux 7 (Architecture Independent) RPM Package“. Downloading this package requires an Oracle account, so you can register for one if you don’t already have one.
I will now need to copy the package over to the Oracle Cloud instance I created. I can easily do this via SFTP. You will want to set up your FTP client with the user name of opc and you will also need to use the id_rsa.pub file to connect. I am on a Mac, and I use CyberDuck, so this is what my SFTP settings look like:
I created a directory in my $HOME directory and named it mysql-install-files. I placed the RPM package in this directory. You can place the files wherever you want.
[opc@instance-20191113-1544 ~]$ pwd /home/opc [opc@instance-20191113-1544 ~]$ ls -l total 0 drwxrwxr-x. 2 opc opc 56 Nov 14 15:33 mysql-install-files [opc@instance-20191113-1544 ~]$ cd mysql-install-files/ [opc@instance-20191113-1544 mysql-install-files]$ ls -l total 28 -rw-rw-r--. 1 opc opc 26024 Nov 14 15:32 mysql80-community-release-el7-3.noarch.rpm
I can now install the downloaded release package. If you chose a different operating system, you will want to replace the platform-and-version-specific-package-name with the name of the downloaded RPM package. And, you will want to refer to the instructions for installing MySQL for your specific OS version.
[opc@instance-20191113-1544 mysql-install-files]$ sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm Loaded plugins: langpacks, ulninfo Examining mysql80-community-release-el7-3.noarch.rpm: mysql80-community-release-el7-3.noarch Marking mysql80-community-release-el7-3.noarch.rpm to be installed Resolving Dependencies --> Running transaction check ---> Package mysql80-community-release.noarch 0:el7-3 will be installed --> Finished Dependency Resolution ol7_UEKR5/x86_64 | 2.8 kB 00:00:00 ol7_UEKR5/x86_64/updateinfo | 21 kB 00:00:00 ol7_UEKR5/x86_64/primary_db | 4.0 MB 00:00:00 ol7_addons/x86_64 | 2.8 kB 00:00:00 ol7_addons/x86_64/updateinfo | 74 kB 00:00:00 ol7_addons/x86_64/primary_db | 137 kB 00:00:00 ol7_developer/x86_64 | 2.8 kB 00:00:00 ol7_developer/x86_64/updateinfo | 71 B 00:00:00 ol7_developer/x86_64/primary_db | 444 kB 00:00:00 ol7_developer_EPEL/x86_64 | 3.4 kB 00:00:00 ol7_developer_EPEL/x86_64/group_gz | 87 kB 00:00:00 ol7_developer_EPEL/x86_64/updateinfo | 4.9 kB 00:00:00 ol7_developer_EPEL/x86_64/primary_db | 11 MB 00:00:00 ol7_ksplice | 2.8 kB 00:00:00 ol7_ksplice/updateinfo | 4.8 kB 00:00:00 ol7_ksplice/primary_db | 257 kB 00:00:00 ol7_latest/x86_64 | 3.4 kB 00:00:00 ol7_latest/x86_64/group_gz | 148 kB 00:00:00 ol7_latest/x86_64/updateinfo | 2.6 MB 00:00:00 ol7_latest/x86_64/primary_db | 15 MB 00:00:00 ol7_oci_included/x86_64 | 2.9 kB 00:00:00 ol7_oci_included/x86_64/primary_db | 71 kB 00:00:00 ol7_optional_latest/x86_64 | 2.8 kB 00:00:00 ol7_optional_latest/x86_64/updateinfo | 868 kB 00:00:00 ol7_optional_latest/x86_64/primary_db | 4.0 MB 00:00:00 ol7_software_collections/x86_64 | 2.8 kB 00:00:00 ol7_software_collections/x86_64/updateinfo | 8.7 kB 00:00:00 ol7_software_collections/x86_64/primary_db | 4.7 MB 00:00:00 Dependencies Resolved ============================================================================================= Package Arch Version Repository Size ============================================================================================= Installing: mysql80-community-release noarch el7-3 /mysql80-community-release-el7-3.noarch 31 k Transaction Summary ============================================================================================= Install 1 Package Total size: 31 k Installed size: 31 k Is this ok [y/d/N]: y Downloading packages: Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : mysql80-community-release-el7-3.noarch 1/1 Verifying : mysql80-community-release-el7-3.noarch 1/1 Installed: mysql80-community-release.noarch 0:el7-3 Complete!
Installing the Community version
Now that I have the MySQL repository in place, I can install the MySQL Community edition server.
$ sudo yum install mysql-community-server
Loaded plugins: langpacks, ulninfo
mysql-connectors-community | 2.5 kB 00:00:00
mysql-tools-community | 2.5 kB 00:00:00
mysql80-community | 2.5 kB 00:00:00
(1/3): mysql-connectors-community/x86_64/primary_db | 49 kB 00:00:00
(2/3): mysql-tools-community/x86_64/primary_db | 66 kB 00:00:00
(3/3): mysql80-community/x86_64/primary_db | 87 kB 00:00:00
Resolving Dependencies
--> Running transaction check
---> Package mysql-community-server.x86_64 0:8.0.18-1.el7 will be installed
--> Processing Dependency: mysql-community-common(x86-64) = 8.0.18-1.el7 for package: mysql-community-server-8.0.18-1.el7.x86_64
--> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.18-1.el7.x86_64
--> Running transaction check
---> Package mysql-community-client.x86_64 0:8.0.18-1.el7 will be installed
--> Processing Dependency: mysql-community-libs(x86-64) >= 8.0.11 for package: mysql-community-client-8.0.18-1.el7.x86_64
---> Package mysql-community-common.x86_64 0:8.0.18-1.el7 will be installed
--> Running transaction check
---> Package mariadb-libs.x86_64 1:5.5.64-1.el7 will be obsoleted
--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-7.el7.x86_64
---> Package mysql-community-libs.x86_64 0:8.0.18-1.el7 will be obsoleting
--> Running transaction check
---> Package mysql-community-libs-compat.x86_64 0:8.0.18-1.el7 will be obsoleting
--> Finished Dependency Resolution
Dependencies Resolved
======================================================================================
Package Arch Version Repository Size
======================================================================================
Installing:
mysql-community-libs x86_64 8.0.18-1.el7 mysql80-community 3.7 M
replacing mariadb-libs.x86_64 1:5.5.64-1.el7
mysql-community-libs-compat x86_64 8.0.18-1.el7 mysql80-community 1.3 M
replacing mariadb-libs.x86_64 1:5.5.64-1.el7
mysql-community-server x86_64 8.0.18-1.el7 mysql80-community 429 M
Installing for dependencies:
mysql-community-client x86_64 8.0.18-1.el7 mysql80-community 38 M
mysql-community-common x86_64 8.0.18-1.el7 mysql80-community 597 k
Transaction Summary
======================================================================================
Install 3 Packages (+2 Dependent packages)
Total download size: 473 M
Is this ok [y/d/N]: Y
Downloading packages:
warning: /var/cache/yum/x86_64/7Server/mysql80-community/packages/mysql-community-common-8.0.18-1.el7.x86_64.rpm:
Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
Public key for mysql-community-common-8.0.18-1.el7.x86_64.rpm is not installed
(1/5): mysql-community-common-8.0.18-1.el7.x86_64.rpm | 597 kB 00:00:00
(2/5): mysql-community-libs-8.0.18-1.el7.x86_64.rpm | 3.7 MB 00:00:00
(3/5): mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm | 1.3 MB 00:00:00
(4/5): mysql-community-client-8.0.18-1.el7.x86_64.rpm | 38 MB 00:00:17
(5/5): mysql-community-server-8.0.18-1.el7.x86_64.rpm | 429 MB 00:01:31
----------------------------------------------------------------------------------
Total 5.1 MB/s | 473 MB 00:01:32
Retrieving key from file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Importing GPG key 0x5072E1F5:
Userid : "MySQL Release Engineering "
Fingerprint: a4a9 4068 76fc bd3c 4567 70c8 8c71 8d3b 5072 e1f5
Package : mysql80-community-release-el7-3.noarch (@/mysql80-community-release-el7-3.noarch)
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
Is this ok [y/N]: y
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-community-common-8.0.18-1.el7.x86_64 1/6
Installing : mysql-community-libs-8.0.18-1.el7.x86_64 2/6
Installing : mysql-community-client-8.0.18-1.el7.x86_64 3/6
Installing : mysql-community-server-8.0.18-1.el7.x86_64 4/6
Installing : mysql-community-libs-compat-8.0.18-1.el7.x86_64 5/6
Erasing : 1:mariadb-libs-5.5.64-1.el7.x86_64 6/6
Verifying : mysql-community-client-8.0.18-1.el7.x86_64 1/6
Verifying : mysql-community-common-8.0.18-1.el7.x86_64 2/6
Verifying : mysql-community-server-8.0.18-1.el7.x86_64 3/6
Verifying : mysql-community-libs-8.0.18-1.el7.x86_64 4/6
Verifying : mysql-community-libs-compat-8.0.18-1.el7.x86_64 5/6
Verifying : 1:mariadb-libs-5.5.64-1.el7.x86_64 6/6
Installed:
mysql-community-libs.x86_64 0:8.0.18-1.el7
mysql-community-libs-compat.x86_64 0:8.0.18-1.el7
mysql-community-server.x86_64 0:8.0.18-1.el7
Dependency Installed:
mysql-community-client.x86_64 0:8.0.18-1.el7
mysql-community-common.x86_64 0:8.0.18-1.el7
Replaced:
mariadb-libs.x86_64 1:5.5.64-1.el7
Complete!
Now that we have MySQL installed, we can start the server.
$ sudo service mysqld start Redirecting to /bin/systemctl start mysqld.service
And I can check to make sure MySQL is running:
sudo service mysqld status
Redirecting to /bin/systemctl status mysqld.service
● mysqld.service - MySQL Server
Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
Active: active (running) since Thu 2019-11-14 16:26:34 GMT; 41s ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 7344 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 7426 (mysqld)
Status: "Server is operational"
CGroup: /system.slice/mysqld.service
└─7426 /usr/sbin/mysqld
Nov 14 16:26:13 instance-20191113-1544 systemd[1]: Starting MySQL Server...
Nov 14 16:26:34 instance-20191113-1544 systemd[1]: Started MySQL Server.
During the installation process, the user ‘root’@’localhost’ is automatically created, along with a password which can be found in the MySQL error log file. To find the password, issue this command: Note: The location of the mysqld.log file may be different for your operating system.
sudo grep 'temporary password' /var/log/mysqld.log 2019-11-14T16:26:25.260720Z 5 [Note] [MY-010454] [Server] \ A temporary password is generated for root@localhost: i&wCaLKQf6Tm
I can now login to the MySQL server using this password. I will also need to change the password before I can do anything else within MySQL. I can do this with the ALTER USER command.
$ mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.18 Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'N3wP4ssW0rd678!'; Query OK, 0 rows affected (0.01 sec)
If you don’t specify a password that matches the default password policy, you will get an error message like this:
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'HeyThere!'; ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
MySQL is now installed and ready to use.
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | sys | +--------------------+ 4 rows in set (0.01 sec)
Enterprise Edition
MySQL’s Enterprise Edition (which requires a license) may be installed in the same way, except you must download the the Enterprise Edition files via Oracle’s eDelivery web site.
You will want to download at least the following files: (relative to your operating system)
-rw-rw-r--. 1 opc opc 40154652 Nov 4 21:53 mysql-commercial-client-8.0.18-1.1.el7.x86_64.rpm -rw-rw-r--. 1 opc opc 623112 Nov 4 21:50 mysql-commercial-common-8.0.18-1.1.el7.x86_64.rpm -rw-rw-r--. 1 opc opc 3890924 Nov 4 21:49 mysql-commercial-libs-8.0.18-1.1.el7.x86_64.rpm -rw-rw-r--. 1 opc opc 1377676 Nov 4 21:48 mysql-commercial-libs-compat-8.0.18-1.1.el7.x86_64.rpm -rw-rw-r--. 1 opc opc 477137056 Nov 4 21:34 mysql-commercial-server-8.0.18-1.1.el7.x86_64.rpm
To install, use this command:
$ sudo yum install mysql-commercial-{server,client,common,libs}-*
During the installation process, you should see something like this:
$ sudo yum install mysql-commercial*{server,client,common,libs}-*
Loaded plugins: langpacks, ulninfo
Examining mysql-commercial-server-8.0.18-1.1.el7.x86_64.rpm: mysql-commercial-server-8.0.18-1.1.el7.x86_64
Marking mysql-commercial-server-8.0.18-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-client-8.0.18-1.1.el7.x86_64.rpm: mysql-commercial-client-8.0.18-1.1.el7.x86_64
Marking mysql-commercial-client-8.0.18-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-common-8.0.18-1.1.el7.x86_64.rpm: mysql-commercial-common-8.0.18-1.1.el7.x86_64
Marking mysql-commercial-common-8.0.18-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-libs-8.0.18-1.1.el7.x86_64.rpm: mysql-commercial-libs-8.0.18-1.1.el7.x86_64
Marking mysql-commercial-libs-8.0.18-1.1.el7.x86_64.rpm to be installed
Examining mysql-commercial-libs-compat-8.0.18-1.1.el7.x86_64.rpm: mysql-commercial-libs-compat-8.0.18-1.1.el7.x86_64
Marking mysql-commercial-libs-compat-8.0.18-1.1.el7.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package mysql-commercial-client.x86_64 0:8.0.18-1.1.el7 will be installed
---> Package mysql-commercial-common.x86_64 0:8.0.18-1.1.el7 will be installed
---> Package mysql-commercial-libs.x86_64 0:8.0.18-1.1.el7 will be installed
---> Package mysql-commercial-libs-compat.x86_64 0:8.0.18-1.1.el7 will be installed
---> Package mysql-commercial-server.x86_64 0:8.0.18-1.1.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
==========================================================================================================================
Package Arch Version Repository Size
==========================================================================================================================
Installing:
mysql-commercial-client x86_64 8.0.18-1.1.el7 /mysql-commercial-client-8.0.18-1.1.el7.x86_64 177 M
mysql-commercial-common x86_64 8.0.18-1.1.el7 /mysql-commercial-common-8.0.18-1.1.el7.x86_64 8.5 M
mysql-commercial-libs x86_64 8.0.18-1.1.el7 /mysql-commercial-libs-8.0.18-1.1.el7.x86_64 17 M
mysql-commercial-libs-compat x86_64 8.0.18-1.1.el7 /mysql-commercial-libs-compat-8.0.18-1.1.el7.x86_64 6.4 M
mysql-commercial-server x86_64 8.0.18-1.1.el7 /mysql-commercial-server-8.0.18-1.1.el7.x86_64 2.0 G
Transaction Summary
==========================================================================================================================
Install 5 Packages
Total size: 2.2 G
Installed size: 2.2 G
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : mysql-commercial-common-8.0.18-1.1.el7.x86_64 1/5
Installing : mysql-commercial-libs-8.0.18-1.1.el7.x86_64 2/5
Installing : mysql-commercial-client-8.0.18-1.1.el7.x86_64 3/5
Installing : mysql-commercial-server-8.0.18-1.1.el7.x86_64 4/5
Installing : mysql-commercial-libs-compat-8.0.18-1.1.el7.x86_64 5/5
Verifying : mysql-commercial-server-8.0.18-1.1.el7.x86_64 1/5
Verifying : mysql-commercial-libs-8.0.18-1.1.el7.x86_64 2/5
Verifying : mysql-commercial-common-8.0.18-1.1.el7.x86_64 3/5
Verifying : mysql-commercial-libs-compat-8.0.18-1.1.el7.x86_64 4/5
Verifying : mysql-commercial-client-8.0.18-1.1.el7.x86_64 5/5
Installed:
mysql-commercial-client.x86_64 0:8.0.18-1.1.el7
mysql-commercial-common.x86_64 0:8.0.18-1.1.el7
mysql-commercial-libs.x86_64 0:8.0.18-1.1.el7
mysql-commercial-libs-compat.x86_64 0:8.0.18-1.1.el7
mysql-commercial-server.x86_64 0:8.0.18-1.1.el7
Complete!
You will need to change the password for root as explained above.
Now you have a free Oracle Cloud compute instance with MySQL running on it. Remember – the “Always Free” tier allows you to create two free compute instances (or virtual machines).
 |
Tony Darnell is a Principal Sales Consultant for MySQL, a division of Oracle, Inc. MySQL is the world’s most popular open-source database program. Tony may be reached at info [at] ScriptingMySQL.com and on LinkedIn. |
 |
Tony is the author of Twenty Forty-Four: The League of Patriots Visit http://2044thebook.com for more information. |
 |
Tony is the editor/illustrator for NASA Graphics Standards Manual Remastered Edition Visit https://amzn.to/2oPFLI0 for more information. |
info [at] Scripting
Scripting MySQL 
Thanks Tony for the nice information. Just a small question about the 10 GB Object Storage and the 10 GB Archive Storage: what are the use cases of this type of storage?
Thanks again
Ahmed
Ahmed
Actually – I will have to update the blog. You can’t have an OCI object storage instance of less than 50 GB.