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

Enhancing Productivity with Dynamics 365: The Power of Session Restore

Spread the love Enhancing Productivity with Dynamics 365:

Salesforce Admin

Spread the love In our last blog, we discussed common

Unlocking AI with Spring Boot: Real-World Use Cases and Solutions

Spread the love Artificial Intelligence (AI) has moved from

Enhancing Performance with Reactive Java: A Beginner-Friendly Guide

Spread the love In today’s fast-paced software

Integrating Azure Function with Dynamics 365

Spread the love Signup on azure portal and make sure to

How to Create a Power Apps Component Framework (PCF) with React

Spread the love If youʼve been looking to supercharge your

Customize lead qualification for a seamless experience

Spread the love When the 2024 Release Wave 2 was launched,

Create a Custom Console Command in Spryker

Spread the love In Spryker, developers can create custom

SALESFORCE

Spread the love Salesforce is a cloud-based software

CRUD Operation in Spryker Backoffice with a Custom Module

Spread the love Spryker is a highly flexible and modular

bluethinkinc Blogs