How to Install MySQL on Ubuntu

Blog
Spread the love

Expertise over technologies, commitment to deadlines, experienced corporate trainers and more makes us an ideal IT solution provider to your enterprise. Isn’t it the right time to work together?

Step 1 – Install MySQL

# sudo apt-get update
installed apache2 on ubantu

# sudo apt-get install mysql-server
installed apache2 on ubantu

Step 2 – Configuring MySQL

installed apache2 on ubantu

Enter a three level of password validation and also given a root password:
installed apache2 on ubantu

# sudo mysql
installed apache2 on ubantu

Step 3 – Create a MySQL User

Creating a new user and give it a strong password.
mysql> CREATE USER ‘magento’@’localhost’ IDENTIFIED BY ‘magento123’;
installed apache2 on ubantu

You could grant the user privileges to all tables within the database, as well as the power to add, change, and remove user privileges, with this command.
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘magento’@’localhost’ WITH GRANT OPTION;
installed apache2 on ubantu

mysql> FLUSH PRIVILEGES;
installed apache2 on ubantu

mysql> exit;

Step 4 – Testing MySQL

# sudo systemctl status mysql
installed apache2 on ubantu

bluethinkinc_blog

bluethinkinc_blog

2022-07-11

0

Leave a Reply

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

Find More Blogs

Understanding Database Allows Callout in Salesforce Apex

Spread the love In Salesforce, the Database.AllowsCallouts

PODMAN

Spread the love 1.Introduction Podman: The Modern Container

Running Your Java Program (JAR) 24/7 on AWS EC2 Automatically

Spread the love Introduction Running a Java application

Building a REST API with Spring Boot

Spread the love Introduction REST (Representational State

Custom API to Fetch Customer Data by Customer ID in Spryker

Spread the love Introduction In this blog post, we will

Creating a Custom Module for a Custom Frontend Page in Spryker

Spread the love To create a custom module for a custom

How to create custom module api get category list without access token in Spryker

Spread the love To create a custom API for fetching a

Creating a Custom Glue API in Spryker

Spread the love Spryker’s Glue API is a powerful tool

Get AI Generated 360-Degree View of Account Summary in Dynamics 365 Sales

Spread the love Navigating the demanding landscape of sales

Enhancing Productivity with Dynamics 365: The Power of Session Restore

Spread the love Enhancing Productivity with Dynamics 365:

bluethinkinc Blogs