How to install MySQL on Ubuntu VM

How to install MySQL on Ubuntu

Step by Step Guide on How to Install MySQL Server on Ubuntu VM

Update Package List:

Start by updating the package list on your Ubuntu server to ensure you have the latest information about available packages:

sudo apt update

Install MySQL Server:

Use the following command to Install MySQL Server

sudo apt install mysql-server

Secure MySQL Installation:

After MySQL server is Installed, you should run a security script that comes with MySQL to improve its security. Run the following command and follow the on-screen prompts:

sudo mysql_secure_installation

This script will help you set a root password, remove anonymous users, disallow remote root login, and remove the test database.

Start and Enable MySQL:

Start the MySQL service and enable it to start automatically on boot:

sudo systemctl start mysql
sudo systemctl enable mysql

Check MySQL Service Status:

Verify that MySQL is running without any issues by using the following command:

sudo systemctl status mysql

You should see “active (running)” in the output if MySQL is running correctly.

Access MySQL:

You can access the MySQL server with the following command. Replace your_password with the root password you set during the installation process:

sudo mysql -u root -p

This will prompt you for the root password. Once you enter it, you will be in the MySQL shell like below.

How to install MySQL on Ubuntu

Create Databases, Use or Drop Database :

If you need to create the databases or drop the databases use the following commands

USE mydb;

Create User and Grant Permissions :

CREATE USER 'user'@'localhost' IDENTIFIED BY 'yourpassword';
GRANT ALL PRIVILEGES ON your_database.* TO 'your_user'@'localhost'; FLUSH PRIVILEGES;

How to Create a Table in MySQL :

CREATE TABLE mytable (
    ID int,
    FirstName varchar(255),
    lastName varchar(255),
    Address varchar(255),
    Age int

How to Insert Records in a Table in MySQL :

INSERT INTO mytable (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Exit MySQL Shell:

To exit from MySQL shell just enter like below


By using the above steps now we are able to how to install MySQL server on Ubuntu VM

it’s a good idea to refer to the latest documentation for the most accurate instructions. the official MySQL Documentation for more advanced features and setup options.

How to install Apache Airflow on Ubuntu VM

Leave a Reply

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