This post shows students and new users the steps to install MySQL or MariaDB database server on Google Cloud servers running Ubuntu Linux. If you want to run a website online, you will need a web server. You probably also need a database server installed if you want to run dynamic and some of the more popular CMS, like WordPress, Drupal, or Drupal.
MySQL and MariaDB are the most popular open source database servers in use today and run on most online websites.
This is the sixth post in this series that can be used as a beginner’s guide to learning how to create a website domain, configure a Google Cloud server with Ubuntu Linux, and install software and packages to create and run an online website.
Now that you have learned how to create a website domain and configure a Google Cloud server, this post shows you how to install MySQL or MariaDB on Google Cloud servers with Ubuntu Linux.
A web server allows content to be published and served to web clients and your audience browsing your website. A database server enables you to store your website content efficiently.
If you are going to run a popular content management system (CMS), then a database server is certainly required.
In our first post, we mentioned that after creating a domain name, it cannot be used until it is forwarded or pointed to a server. In the second post, we showed you how to point a domain to a server that we created.
At this point, we are ready to connect to our Google Cloud server and begin installing additional software and packages that will be used to run an online website.
How to connect to the Google Cloud server
The Google Cloud (Compute Engine) server allows users to connect using SSH from the browser window to your virtual machine (VM) instance from within the Google Cloud Console.
Browser SSH supports the following:
- Latest version of Google Chrome
- Microsoft Edge
- Microsoft Internet Explorer 11 and later
- Safari 8 and later. Please note that Safari in private browser mode is not supported.
Virtual machine configurations
- All Linux VM images that are available natively on Google Cloud.
No additional software or browser extensions are required. Just log in to the Google Cloud Console and go to Menu ==> Compute Engine ==> VM instances.
In the list of virtual machine instances, click SSH in the row of the instance you want to connect to.
Alternatively, you can open an SSH connection to an instance by clicking its name and clicking SSH from the instance details page.
An SSH terminal window will open with the Ubuntu Linux instance that was created in the second posts in the series.
You should now be able to run commands on Ubuntu Linux created on the Google Cloud server.
How to install a database server on Google Cloud Servers
Installing MySQL or MariaDB on Ubuntu Linux is no different, whether it’s on Google Cloud or on a local VM instance.
Both the MySQL and MariaDB packages are available in the default Ubuntu repositories. One can simply use the apt to get commands to download and install database packages on Ubuntu Linux.
A detailed post and help on how to install MySQL or MariaDB on Ubuntu Linux is at the link below. Click on it to learn more about how to install and manage MySQL or MariaDB database servers on Ubuntu Linux.
How to install MySQL or MariaDB on Ubuntu Linux
With a database server installed, your domain name pointing to your Google Cloud server, you should now be able to store content within a database.
We are now way ahead in the process of creating an online website using a web server, PHP server-side language, a database server and almost ready to put all these servers and software together for your website, you are all set. .
Now we are ready to configure our servers and packages for the website to work.
Stay tuned and keep reading our previous posts.
In this tutorial we have seen how to install MySQL or MariaDB on Ubuntu Linux on Google Cloud. If you find any errors above or have something to add, use the comment form below.