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

How to Add a Custom Tab to the Customer Order Detail Page in Magento 2

Spread the love Adding a custom tab to the Order Detail

Exception Handling in Java

Spread the love Introduction – Exception:An unwanted

How to add custom less file in Magento2

Spread the love Source files *.css included into layout

Spring Boot Microservices

Spread the love Microservices architecture has become

Implementation of WireMock for better testing

Spread the love WireMock is a flexible and powerful tool

Magento 2: How to selected default option in configurable options?

Spread the love Configurable products in Magento 2 allow

How To Implement Simple JWT Authentication in Django Rest Framework

Spread the love We’ll learn how to use simple JWT

Optimizing Search: Integrating Elasticsearch in Django Applications

Spread the love What is Elasticsearch? Elasticsearch is a

How to create Customer Segments

Spread the love In Magento 2, “customer

Proxy Design Pattern and Requisition List in Magento 2

Spread the love Requisition List in Magento 2 Requisition

bluethinkinc Blogs