Cloudbooklet
  • News
  • Artificial Intelligence
  • Applications
  • Linux
No Result
View All Result
Cloudbooklet
  • News
  • Artificial Intelligence
  • Applications
  • Linux
No Result
View All Result
Cloudbooklet
No Result
View All Result
Home Google Cloud

How to Install MySQL 8.0 on Ubuntu 18.04

by Cloudbooklet
4 years ago
in Google Cloud, MySQL
How To Install Mysql 8.0 On Ubuntu 18.04
ShareTweetSendShare
Readers like you help support Cloudbooklet. When you make a purchase using links on our site, we may earn an affiliate commission.

How to Install MySQL 8.0 on Ubuntu 18.04. MySQL is an open source database management system used to store and retrieve data for a wide variety of popular applications. To use the most new features of MySQL it is necessary to install the latest version of MySQL. In this guide you are going to learn […]

ADVERTISEMENT

How to Install MySQL 8.0 on Ubuntu 18.04. MySQL is an open source database management system used to store and retrieve data for a wide variety of popular applications.

To use the most new features of MySQL it is necessary to install the latest version of MySQL. In this guide you are going to learn how to install MySQL 8.0 on your Ubuntu 18.04.

Add MySQL Software Repository

The MySQL developers maintains the APT repository which provides a simple and convenient way to install and update MySQL products with the latest software packages using Apt.

ADVERTISEMENT

To get the latest release go to MySQL downloads page and click the download button at the bottom right. In the Begin your Download page right click on the No thanks, just start my download and copy the link address.

You might also like

How To Setup Ssh Keys On Ubuntu

How to Setup SSH Keys on Ubuntu 20.04

4 months ago
Draggan Ai Editing Tool Install And Use Draggan Photo Editor

DragGAN AI Editing Tool Install and Use DragGAN Photo Editor

4 months ago

Go to your server and download the file using the link you have copied.

cd /tmp
sudo curl -OL https://dev.mysql.com/get/mysql-apt-config_0.8.13-1_all.deb

Now a .deb software package will get downloaded to your server.

ADVERTISEMENT

Use the dpkg command to install the package.

sudo dpkg -i mysql-apt-config*

You will prompted to choose the version, you can move to OK menu and hit Enter

ADVERTISEMENT
sudo apt update

Now the MySQL repository is added and you can delete the downloaded file.

sudo rm mysql-apt-config*

Install MySQL 8.0

Once the package is added and the cache is refreshed you can install MySQL Server.

ADVERTISEMENT
sudo apt install mysql-server

You can provide a secure password for your root. Next you need to configure the authentication plugin. Use the default Use Strong Password Encryption and hit Enter.

Wait for the installation to complete.

ADVERTISEMENT

Once the installation is complete you can view the status of the MySQL server using the following command.

sudo systemctl status mysql
Output
 ● mysql.service - MySQL Community Server
    Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
    Active: active (running) since Thu 2019-06-25 17:46:42 UTC; 13s ago
      Docs: man:mysqld(8)
            http://dev.mysql.com/doc/refman/en/using-systemd.html
  Main PID: 7918 (mysqld)
    Status: "SERVER_OPERATING"
     Tasks: 37 (limit: 1152)
    CGroup: /system.slice/mysql.service
            └─7918 /usr/sbin/mysqld

Securing MySQL

Once the installation is completed it is necessary to secure the MySQL installation.

mysql_secure_installation
  • Enable the validate password plugin
  • Update the root password if you need
  • Remove anonymous MySQL user
  • Remove test database
  • Reload privileges

Now your installation is secured.

Conclusion

Now you have learned how to install MySQL 8.0 on Ubuntu 18.04. Next you can proceed to create database and assign users.

Thanks for your time. If you face any problem or any feedback, please leave a comment below.

Tags: Ubuntu 18.04
ShareTweetSendShare
Cloudbooklet

Cloudbooklet

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Related Posts

Install Wordpress With Docker Compose, Nginx, Apache With Ssl

WordPress Deployment Made Easy: Docker Compose, Nginx, Apache, SSL Setup Guide

4 months ago
Set Up Deep Learning With Nvidia, Cuda, Cudnn On Ubuntu

How to Set Up Deep Learning with Nvidia, CUDA, cuDNN on Ubuntu 22.04

7 months ago
How To Install Or Upgrade Php 8.2 On Ubuntu 22.04

How to Install or Upgrade PHP 8.2 on Ubuntu 22.04

9 months ago
How To Change Timezone On Ubuntu 22.04

How to Change Timezone on Ubuntu 22.04

1 year ago

Follow Us

Trending Articles

Best Laptop For Minecraft-

5 Best Laptop for Minecraft in 2023: Top Picks for All Budgets

September 21, 2023

Microsoft Editor vs Grammarly: Which is the Best Grammar Checker?

Create High Quality AI Cover Song with Covers AI

AI Statistics and Trends: What You Need to Know in 2023

Validator AI: The AI Powered Business Idea Validator

Best 10 AI Comic Generator: Create Comic book in Seconds

Popular Articles

Cleanup Ai

10 FREE Cleanup AI Tools to Remove Objects and Cleanup Pictures

September 11, 2023

Free AI Script Generators Online to Create High Quality Scripts

Google Dark Web Report: Protect Your Personal Information

How to Create a Personal AI Assistant with LocalGPT

5 FREE AI Horoscope Online – Personalized Way to See Your Future

How to Use the Donne App: A Step-by-Step Guide for Fashion Lovers

Subscribe Now

loader

Subscribe to our mailing list to receives daily updates!

Email Address*

Name

Cloudbooklet Logo

Welcome to our technology blog, where we explore the latest advancements in the field of artificial intelligence (AI) and how they are revolutionizing cloud computing. In this blog, we dive into the powerful capabilities of cloud platforms like Google Cloud Platform (GCP), Amazon Web Services (AWS), and Microsoft Azure, and how they are accelerating the adoption and deployment of AI solutions across various industries. Join us on this exciting journey as we explore the endless possibilities of AI and cloud computing.

  • About
  • Contact
  • Disclaimer
  • Privacy Policy

Cloudbooklet © 2023 All rights reserved.

No Result
View All Result
  • News
  • Artificial Intelligence
  • Applications
  • Linux

Cloudbooklet © 2023 All rights reserved.