{"id":14498,"date":"2020-08-14T08:47:52","date_gmt":"2020-08-14T06:47:52","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/"},"modified":"2020-08-14T08:47:52","modified_gmt":"2020-08-14T06:47:52","slug":"installing-mysql-server-on-oracle-cloud-infrastructure-compute","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/","title":{"rendered":"Installing MySQL Server on Oracle Cloud Infrastructure Compute"},"content":{"rendered":"

If you are thinking about to move your MySQL databases to the Cloud but you are still reticent, you can maybe use the “Oracle Cloud Free Tier<\/a>” offer to test it.
\n
\nOracle Cloud Free Tier offers you 2 Oracle Autonomous Databases and 2 Oracle Cloud Infrastructure Compute VMs as Always Free services and in addition a 30-day Free Trial with US$300 in free credits.
\nOn these VMs instances (provisioned and managed by Oracle Cloud Infrastructure Compute) you can install your MySQL server. Let’s see how…<\/p>\n

Oracle Cloud account creation<\/h2>\n

Connect to the Oracle Cloud page<\/a> and fill in your credentials:
\n\"\"<\/a>
\nDefine your account type, your Cloud account name, your region and some other details:
\n\"\"<\/a>
\nEnter your Cloud account password:
\n\"\"<\/a>
\nLast step is to insert your payment information (this will be just used for verification, you won’t have to pay anything):
\n\"\"<\/a>
\nAnd you account will be created:
\n\"\"<\/a><\/p>\n

Instance creation<\/h2>\n

Some minutes after the account creation, you can sign in to your Oracle Cloud environment:
\n\"\"<\/a>
\nOnce connected, you can directly see that you are in a free trial and you have the possibility to switch to upgrade to paid at any time:
\n\"\"<\/a>
\nYou can now create your VM instance in the “Quick Actions” section in the main page or under “Menu > Compute > Instances > Create Instance”. For example:
\n\"\"<\/a>
\nYou can define the instance name, which image you want to use (Oracle Linux, CentOS, …) as operating system and some other network and storage options:
\n\"\"<\/a>
\nYou also need to define the keys to connect to the VM. If you don’t have them yet, you can generate RSA keys via PuTTYgen for example. You just have to generate the key, assign it a passphrase and save your public and private keys:
\n\"\"<\/a>
\nYou can now add your public key in the “Add SSH keys” section:
\n\"\"<\/a>
\nand finally launch the instance creation.
\nThe VM creation is in progress in the region that you selected (Z\u00fcrich in my case):
\n\"\"<\/a>
\nYou can check the status of the operation in the “Work Requests” section:
\n\"\"<\/a>
\nThe instance has been provisioned (it took 2 minutes for me) and it is running now, and you can get the public IP address of the new VM:
\n\"\"<\/a>
\n\"\"<\/a><\/p>\n

Connection to the new VM instance<\/h2>\n

You can now connect to the new VM via PuTTY, using the given IP address and adding your private key for the authentication in the PuTTY configuration under “Connection > SSH > Auth”:
\n\"\"<\/a>
\nAfter entering your passphrase, you are now connected to your VM:<\/p>\n

login as: opc\nAuthenticating with public key \"rsa-key-20200813\"\nPassphrase for key \"rsa-key-20200813\":\nLast login: Fri Aug 14 06:25:38 2020 from 213.55.220.190\n[opc@instance-20200730-1509 ~]$\n<\/pre>\n
MySQL Server installation<\/h2>\n
You can now start the installation of MySQL Server.
\nYou have to keep attention to the fact that on Oracle Linux the default RDBMS that will be be installed is MariaDB, and we don’t want that:<\/p>\n
$ sudo yum install mysql\nLoaded plugins: langpacks, ulninfo\nol7_UEKR5                                                                                                                                                             | 2.8 kB  00:00:00\nol7_addons                                                                                                                                                            | 2.8 kB  00:00:00\nol7_developer                                                                                                                                                         | 2.8 kB  00:00:00\nol7_developer_EPEL                                                                                                                                                    | 3.4 kB  00:00:00\nol7_ksplice                                                                                                                                                           | 2.8 kB  00:00:00\nol7_latest                                                                                                                                                            | 3.4 kB  00:00:00\nol7_oci_included                                                                                                                                                      | 2.9 kB  00:00:00\nol7_optional_latest                                                                                                                                                   | 2.8 kB  00:00:00\nol7_software_collections                                                                                                                                              | 2.8 kB  00:00:00\n(1\/19): ol7_UEKR5\/x86_64\/updateinfo                                                                                                                                   |  70 kB  00:00:00\n(2\/19): ol7_developer\/x86_64\/primary_db                                                                                                                               | 560 kB  00:00:00\n(3\/19): ol7_addons\/x86_64\/updateinfo                                                                                                                                  |  91 kB  00:00:00\n(4\/19): ol7_addons\/x86_64\/primary_db                                                                                                                                  | 157 kB  00:00:00\n(5\/19): ol7_UEKR5\/x86_64\/primary_db                                                                                                                                   | 8.4 MB  00:00:00\n(6\/19): ol7_developer_EPEL\/x86_64\/group_gz                                                                                                                            |  87 kB  00:00:00\n(7\/19): ol7_developer\/x86_64\/updateinfo                                                                                                                               | 7.2 kB  00:00:00\n(8\/19): ol7_latest\/x86_64\/group_gz                                                                                                                                    | 134 kB  00:00:00\n(9\/19): ol7_latest\/x86_64\/updateinfo                                                                                                                                  | 2.9 MB  00:00:00\n(10\/19): ol7_developer_EPEL\/x86_64\/updateinfo                                                                                                                         | 6.3 kB  00:00:00\n(11\/19): ol7_oci_included\/x86_64\/primary_db                                                                                                                           | 260 kB  00:00:00\n(12\/19): ol7_optional_latest\/x86_64\/updateinfo                                                                                                                        | 1.0 MB  00:00:00\n(13\/19): ol7_developer_EPEL\/x86_64\/primary_db                                                                                                                         |  12 MB  00:00:00\n(14\/19): ol7_software_collections\/x86_64\/updateinfo                                                                                                                   | 8.7 kB  00:00:00\n(15\/19): ol7_software_collections\/x86_64\/primary_db                                                                                                                   | 5.1 MB  00:00:00\n(16\/19): ol7_optional_latest\/x86_64\/primary_db                                                                                                                        | 4.8 MB  00:00:00\n(17\/19): ol7_ksplice\/primary_db                                                                                                                                       | 1.0 MB  00:00:01\n(18\/19): ol7_latest\/x86_64\/primary_db                                                                                                                                 |  24 MB  00:00:01\n(19\/19): ol7_ksplice\/updateinfo                                                                                                                                       | 5.3 kB  00:00:01\nResolving Dependencies\n--> Running transaction check\n---> Package mariadb.x86_64 1:5.5.65-1.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n=============================================================================================================================================================================================\n Package                                    Arch                                      Version                                            Repository                                     Size\n=============================================================================================================================================================================================\nInstalling:\n mariadb                                    x86_64                                    1:5.5.65-1.el7                                     ol7_latest                                    8.7 M\n\nTransaction Summary\n=============================================================================================================================================================================================\nInstall  1 Package\n\nTotal download size: 8.7 M\nInstalled size: 49 M\nIs this ok [y\/d\/N]: N\nExiting on user command\nYour transaction was saved, rerun it with:\n yum load-transaction \/tmp\/yum_save_tx.2020-07-30.15-02.2RFWFI.yumtx\n\n$ yum list installed | grep -i -e maria\nmariadb-libs.x86_64                   1:5.5.65-1.el7              @anaconda\/7.8\n$ sudo yum remove mariadb-libs.x86_64\nLoaded plugins: langpacks, ulninfo\nResolving Dependencies\n--> Running transaction check\n---> Package mariadb-libs.x86_64 1:5.5.65-1.el7 will be erased\n--> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64\n--> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64\n--> Running transaction check\n---> Package postfix.x86_64 2:2.10.1-9.el7 will be erased\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n=============================================================================================================================================================================================\n Package                                       Arch                                    Version                                          Repository                                      Size\n=============================================================================================================================================================================================\nRemoving:\n mariadb-libs                                  x86_64                                  1:5.5.65-1.el7                                   @anaconda\/7.8                                  4.4 M\nRemoving for dependencies:\n postfix                                       x86_64                                  2:2.10.1-9.el7                                   @anaconda\/7.8                                   12 M\n\nTransaction Summary\n=============================================================================================================================================================================================\nRemove  1 Package (+1 Dependent package)\n\nInstalled size: 17 M\nIs this ok [y\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Erasing    : 2:postfix-2.10.1-9.el7.x86_64                                                                                                                                             1\/2\nwarning: \/etc\/postfix\/main.cf saved as \/etc\/postfix\/main.cf.rpmsave\n  Erasing    : 1:mariadb-libs-5.5.65-1.el7.x86_64                                                                                                                                        2\/2\n  Verifying  : 1:mariadb-libs-5.5.65-1.el7.x86_64                                                                                                                                        1\/2\n  Verifying  : 2:postfix-2.10.1-9.el7.x86_64                                                                                                                                             2\/2\n\nRemoved:\n  mariadb-libs.x86_64 1:5.5.65-1.el7\n\nDependency Removed:\n  postfix.x86_64 2:2.10.1-9.el7\n\nComplete!\n<\/pre>\n
So you need to specify the exact MySQL packages that you want to install (in my case I will use the MySQL 8.0 Community Edition):<\/p>\n
$ sudo yum install https:\/\/dev.mysql.com\/get\/mysql-community-common-8.0.21-1.el7.x86_64.rpm\nLoaded plugins: langpacks, ulninfo\nmysql-community-common-8.0.21-1.el7.x86_64.rpm                                                                                                                        | 617 kB  00:00:00\nExamining \/var\/tmp\/yum-root-c8T9EW\/mysql-community-common-8.0.21-1.el7.x86_64.rpm: mysql-community-common-8.0.21-1.el7.x86_64\nMarking \/var\/tmp\/yum-root-c8T9EW\/mysql-community-common-8.0.21-1.el7.x86_64.rpm to be installed\nResolving Dependencies\n--> Running transaction check\n---> Package mysql-community-common.x86_64 0:8.0.21-1.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n=============================================================================================================================================================================================\n Package                                       Arch                          Version                                Repository                                                          Size\n=============================================================================================================================================================================================\nInstalling:\n mysql-community-common                        x86_64                        8.0.21-1.el7                           \/mysql-community-common-8.0.21-1.el7.x86_64                        8.8 M\n\nTransaction Summary\n=============================================================================================================================================================================================\nInstall  1 Package\n\nTotal size: 8.8 M\nInstalled size: 8.8 M\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : mysql-community-common-8.0.21-1.el7.x86_64                                                                                                                                1\/1\n  Verifying  : mysql-community-common-8.0.21-1.el7.x86_64                                                                                                                                1\/1\n\nInstalled:\n  mysql-community-common.x86_64 0:8.0.21-1.el7\n\nComplete!\n\n$ sudo yum install https:\/\/dev.mysql.com\/get\/mysql-community-libs-8.0.21-1.el7.x86_64.rpm\nLoaded plugins: langpacks, ulninfo\nmysql-community-libs-8.0.21-1.el7.x86_64.rpm                                                                                                                          | 4.5 MB  00:00:00\nExamining \/var\/tmp\/yum-root-c8T9EW\/mysql-community-libs-8.0.21-1.el7.x86_64.rpm: mysql-community-libs-8.0.21-1.el7.x86_64\nMarking \/var\/tmp\/yum-root-c8T9EW\/mysql-community-libs-8.0.21-1.el7.x86_64.rpm to be installed\nResolving Dependencies\n--> Running transaction check\n---> Package mysql-community-libs.x86_64 0:8.0.21-1.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n=============================================================================================================================================================================================\n Package                                      Arch                           Version                                 Repository                                                         Size\n=============================================================================================================================================================================================\nInstalling:\n mysql-community-libs                         x86_64                         8.0.21-1.el7                            \/mysql-community-libs-8.0.21-1.el7.x86_64                          22 M\n\nTransaction Summary\n=============================================================================================================================================================================================\nInstall  1 Package\n\nTotal size: 22 M\nInstalled size: 22 M\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : mysql-community-libs-8.0.21-1.el7.x86_64                                                                                                                                  1\/1\n  Verifying  : mysql-community-libs-8.0.21-1.el7.x86_64                                                                                                                                  1\/1\n\nInstalled:\n  mysql-community-libs.x86_64 0:8.0.21-1.el7\n\nComplete!\n\n$ sudo yum install https:\/\/dev.mysql.com\/get\/mysql-community-client-8.0.21-1.el7.x86_64.rpm\nLoaded plugins: langpacks, ulninfo\nmysql-community-client-8.0.21-1.el7.x86_64.rpm                                                                                                                        |  48 MB  00:00:08\nExamining \/var\/tmp\/yum-root-c8T9EW\/mysql-community-client-8.0.21-1.el7.x86_64.rpm: mysql-community-client-8.0.21-1.el7.x86_64\nMarking \/var\/tmp\/yum-root-c8T9EW\/mysql-community-client-8.0.21-1.el7.x86_64.rpm to be installed\nResolving Dependencies\n--> Running transaction check\n---> Package mysql-community-client.x86_64 0:8.0.21-1.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n=============================================================================================================================================================================================\n Package                                       Arch                          Version                                Repository                                                          Size\n=============================================================================================================================================================================================\nInstalling:\n mysql-community-client                        x86_64                        8.0.21-1.el7                           \/mysql-community-client-8.0.21-1.el7.x86_64                        231 M\n\nTransaction Summary\n=============================================================================================================================================================================================\nInstall  1 Package\n\nTotal size: 231 M\nInstalled size: 231 M\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : mysql-community-client-8.0.21-1.el7.x86_64                                                                                                                                1\/1\n  Verifying  : mysql-community-client-8.0.21-1.el7.x86_64                                                                                                                                1\/1\n\nInstalled:\n  mysql-community-client.x86_64 0:8.0.21-1.el7\n\nComplete!\n\n$ sudo yum install https:\/\/dev.mysql.com\/get\/mysql-community-server-8.0.21-1.el7.x86_64.rpm\nLoaded plugins: langpacks, ulninfo\nmysql-community-server-8.0.21-1.el7.x86_64.rpm                                                                                                                        | 499 MB  00:01:32\nExamining \/var\/tmp\/yum-root-c8T9EW\/mysql-community-server-8.0.21-1.el7.x86_64.rpm: mysql-community-server-8.0.21-1.el7.x86_64\nMarking \/var\/tmp\/yum-root-c8T9EW\/mysql-community-server-8.0.21-1.el7.x86_64.rpm to be installed\nResolving Dependencies\n--> Running transaction check\n---> Package mysql-community-server.x86_64 0:8.0.21-1.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n=============================================================================================================================================================================================\n Package                                       Arch                          Version                                Repository                                                          Size\n=============================================================================================================================================================================================\nInstalling:\n mysql-community-server                        x86_64                        8.0.21-1.el7                           \/mysql-community-server-8.0.21-1.el7.x86_64                        2.3 G\n\nTransaction Summary\n=============================================================================================================================================================================================\nInstall  1 Package\n\nTotal size: 2.3 G\nInstalled size: 2.3 G\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : mysql-community-server-8.0.21-1.el7.x86_64                                                                                                                                1\/1\n  Verifying  : mysql-community-server-8.0.21-1.el7.x86_64                                                                                                                                1\/1\n\nInstalled:\n  mysql-community-server.x86_64 0:8.0.21-1.el7\n\nComplete!\n\n$ sudo yum install https:\/\/dev.mysql.com\/get\/mysql-shell-8.0.21-1.el7.x86_64.rpm\nLoaded plugins: langpacks, ulninfo\nmysql-shell-8.0.21-1.el7.x86_64.rpm                                                                                                                                   |  31 MB  00:00:05\nExamining \/var\/tmp\/yum-root-c8T9EW\/mysql-shell-8.0.21-1.el7.x86_64.rpm: mysql-shell-8.0.21-1.el7.x86_64\nMarking \/var\/tmp\/yum-root-c8T9EW\/mysql-shell-8.0.21-1.el7.x86_64.rpm to be installed\nResolving Dependencies\n--> Running transaction check\n---> Package mysql-shell.x86_64 0:8.0.21-1.el7 will be installed\n--> Finished Dependency Resolution\n\nDependencies Resolved\n\n=============================================================================================================================================================================================\n Package                                  Arch                                Version                                    Repository                                                     Size\n=============================================================================================================================================================================================\nInstalling:\n mysql-shell                              x86_64                              8.0.21-1.el7                               \/mysql-shell-8.0.21-1.el7.x86_64                              106 M\n\nTransaction Summary\n=============================================================================================================================================================================================\nInstall  1 Package\n\nTotal size: 106 M\nInstalled size: 106 M\nIs this ok [y\/d\/N]: y\nDownloading packages:\nRunning transaction check\nRunning transaction test\nTransaction test succeeded\nRunning transaction\n  Installing : mysql-shell-8.0.21-1.el7.x86_64                                                                                                                                           1\/1\n  Verifying  : mysql-shell-8.0.21-1.el7.x86_64                                                                                                                                           1\/1\n\nInstalled:\n  mysql-shell.x86_64 0:8.0.21-1.el7\n\nComplete!\n<\/pre>\n
Packages are now installed and you can start the MySQL Server service:<\/p>\n
$ sudo service mysqld start\nRedirecting to \/bin\/systemctl start mysqld.service\n\n$ ps -eaf|grep mysqld\nmysql      600     1 12 16:04 ?        00:00:01 \/usr\/sbin\/mysqld\nopc        656  2746  0 16:04 pts\/0    00:00:00 grep --color=auto mysqld\n<\/pre>\n
and secure your MySQL installation:<\/p>\n
$ sudo grep 'temporary password' \/var\/log\/mysqld.log\n2020-07-30T16:04:02.227475Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: -:NQql*u3\/IS\n\n$ sudo mysql_secure_installation\n\nSecuring the MySQL server deployment.\n\nEnter password for user root:\n\nThe existing password for the user account root has expired. Please set a new password.\n\nNew password:\n\nRe-enter new password:\nThe 'validate_password' component is installed on the server.\nThe subsequent steps will run with the existing configuration\nof the component.\nUsing existing password for root.\n\nEstimated strength of the password: 100\nChange the password for root ? ((Press y|Y for Yes, any other key for No) : No\n\n ... skipping.\nBy default, a MySQL installation has an anonymous user,\nallowing anyone to log into MySQL without having to have\na user account created for them. This is intended only for\ntesting, and to make the installation go a bit smoother.\nYou should remove them before moving into a production\nenvironment.\n\nRemove anonymous users? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\n\nNormally, root should only be allowed to connect from\n'localhost'. This ensures that someone cannot guess at\nthe root password from the network.\n\nDisallow root login remotely? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nBy default, MySQL comes with a database named 'test' that\nanyone can access. This is also intended only for testing,\nand should be removed before moving into a production\nenvironment.\n\n\nRemove test database and access to it? (Press y|Y for Yes, any other key for No) : y\n - Dropping test database...\nSuccess.\n\n - Removing privileges on test database...\nSuccess.\n\nReloading the privilege tables will ensure that all changes\nmade so far will take effect immediately.\n\nReload privilege tables now? (Press y|Y for Yes, any other key for No) : y\nSuccess.\n\nAll done!\n<\/pre>\n
Everything is fine, you have now access to a MySQL Server on Oracle IaaS:<\/p>\n
$ mysqlsh root@localhost --sql\nPlease provide the password for 'root@localhost': *************\nSave password for 'root@localhost'? [Y]es\/[N]o\/Ne[v]er (default No): N\nMySQL Shell 8.0.21\n\nCopyright (c) 2016, 2020, Oracle and\/or its affiliates. All rights reserved.\nOracle is a registered trademark of Oracle Corporation and\/or its affiliates.\nOther names may be trademarks of their respective owners.\n\nType '\\help' or '\\?' for help; '\\quit' to exit.\nCreating a session to 'root@localhost'\nFetching schema names for autocompletion... Press ^C to stop.\nYour MySQL connection id is 15 (X protocol)\nServer version: 8.0.21 MySQL Community Server - GPL\nNo default schema selected; type \\use  to set one.\n MySQL  localhost:33060+ ssl  SQL >\n<\/pre>\n
Conclusion<\/h2>\n
In this blog post we saw how to configure a MySQL Server Community Edition on an Oracle Cloud Infrastructure Compute<\/a> using the “Oracle Cloud Free Tier<\/a>” offer. This let you practice with a Cloud environment.
\nThe idea would be, once tested, to switch to the new MySQL Database Service<\/a> (MDS) built on the latest MySQL 8.0 Enterprise Edition and powered by Oracle Gen 2 Cloud Infrastructure.
\nI will give you more information soon, so stay tuned as usual and enjoy MySQL \ud83d\ude09
\nby Elisa Usai<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
If you are thinking about to move your MySQL databases to the Cloud but you are still reticent, you can maybe use the “Oracle Cloud Free Tier” offer to test it.<\/p>\n","protected":false},"author":42,"featured_media":14515,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[955,229,1316],"tags":[135,2079,144],"type_dbi":[],"class_list":["post-14498","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cloud","category-database-administration-monitoring","category-mysql","tag-cloud","tag-iaas","tag-mysql"],"acf":[],"yoast_head":"\nInstalling MySQL Server on Oracle Cloud Infrastructure Compute - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing MySQL Server on Oracle Cloud Infrastructure Compute\" \/>\n<meta property=\"og:description\" content=\"If you are thinking about to move your MySQL databases to the Cloud but you are still reticent, you can maybe use the “Oracle Cloud Free Tier” offer to test it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-14T06:47:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png\" \/>\n\t<meta property=\"og:image:width\" content=\"920\" \/>\n\t<meta property=\"og:image:height\" content=\"727\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Elisa Usai\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elisa Usai\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"11 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/\"},\"author\":{\"name\":\"Elisa Usai\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\"},\"headline\":\"Installing MySQL Server on Oracle Cloud Infrastructure Compute\",\"datePublished\":\"2020-08-14T06:47:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/\"},\"wordCount\":601,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png\",\"keywords\":[\"Cloud\",\"IaaS\",\"MySQL\"],\"articleSection\":[\"Cloud\",\"Database Administration & Monitoring\",\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/\",\"name\":\"Installing MySQL Server on Oracle Cloud Infrastructure Compute - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png\",\"datePublished\":\"2020-08-14T06:47:52+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png\",\"width\":920,\"height\":727},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Installing MySQL Server on Oracle Cloud Infrastructure Compute\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f\",\"name\":\"Elisa Usai\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g\",\"caption\":\"Elisa Usai\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/elisa-usai\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Installing MySQL Server on Oracle Cloud Infrastructure Compute - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/","og_locale":"en_US","og_type":"article","og_title":"Installing MySQL Server on Oracle Cloud Infrastructure Compute","og_description":"If you are thinking about to move your MySQL databases to the Cloud but you are still reticent, you can maybe use the “Oracle Cloud Free Tier” offer to test it.","og_url":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/","og_site_name":"dbi Blog","article_published_time":"2020-08-14T06:47:52+00:00","og_image":[{"width":920,"height":727,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png","type":"image\/png"}],"author":"Elisa Usai","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elisa Usai","Est. reading time":"11 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/"},"author":{"name":"Elisa Usai","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f"},"headline":"Installing MySQL Server on Oracle Cloud Infrastructure Compute","datePublished":"2020-08-14T06:47:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/"},"wordCount":601,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png","keywords":["Cloud","IaaS","MySQL"],"articleSection":["Cloud","Database Administration & Monitoring","MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/","url":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/","name":"Installing MySQL Server on Oracle Cloud Infrastructure Compute - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png","datePublished":"2020-08-14T06:47:52+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/1-9.png","width":920,"height":727},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/installing-mysql-server-on-oracle-cloud-infrastructure-compute\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Installing MySQL Server on Oracle Cloud Infrastructure Compute"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/ac5847ee8d7bad4196e72660c1377b1f","name":"Elisa Usai","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d41c7e94b7e4cd42bdcc5b82003c00562de8da0cf0a1081fbe832d47e3a828ff?s=96&d=mm&r=g","caption":"Elisa Usai"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/elisa-usai\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14498","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/42"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14498"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14498\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14515"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14498"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14498"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14498"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14498"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}