MySQL
Techno Sensei 4 months ago

How To Install MySQL on Ubuntu 22.04

MySQL is a widely-used open-source relational database management system (RDBMS). It is based on the Structured Query Language (SQL) and is often used in conjunction with PHP and other programming languages to build dynamic websites and web-based applications. In this tutorial, we will show you how to install MySQL on Ubuntu Server OS.

1.Update the package list

To ensure that you have the latest version of MySQL, you should update the package list on your system. Open the terminal and run the following command:

sudo apt-get update 

2.Install MySQL

To install MySQL, run the following command:

sudo apt-get install mysql-server 

During the installation process, you will be prompted to set a root password for the MySQL server. Make sure to choose a strong and secure password.

3.Verify the installation

To verify that the installation was successful, check the MySQL service status by running the following command:

sudo systemctl status mysql 

You should see an output indicating that the service is active and running.

4.Secure the Installation

MySQL provides a script called mysql_secure_installation that can be used to improve the security of your MySQL installation. To run the script, enter the following command:

sudo mysql_secure_installation 

You will be prompted to answer several questions about how to secure your MySQL installation. It is recommended to answer yes to all questions.

OUTPUT:
Securing the MySQL server deployment.

Connecting to MySQL using a blank password.

VALIDATE PASSWORD COMPONENT can be used to test passwords
and improve security. It checks the strength of password
and allows the users to set only those passwords which are
secure enough. Would you like to setup VALIDATE PASSWORD component?

Press y|Y for Yes, any other key for No: Y

There are three levels of password validation policy:

LOW    Length >= 8
MEDIUM Length >= 8, numeric, mixed case, and special characters
STRONG Length >= 8, numeric, mixed case, special characters and dictionary file

Please enter 0 = LOW, 1 = MEDIUM and 2 = STRONG:

After choosing validation policy, the next prompt will be to set for mysql password, and retype the password for confirmation

OUTPUT:
Please set the password for root here.


New password:

Re-enter new password:

5.Log in to MySQL

Once the installation is complete, you can log in to the MySQL server by running the following command:

sudo mysql -u root -p 

Enter the root password that you set during the installation process when prompted.

Congratulations, you have successfully installed MySQL on your Ubuntu system! You can now use MySQL to create and manage databases.

0
185
How To Save Battery on Android Phone

How To Save Battery on Android Phone

1676196989.jpg
JAFAR
3 months ago
Best Budget Entry Level Gaming Laptop

Best Budget Entry Level Gaming Laptop

1674143770.png
Techno Sensei
4 months ago
Advantages of root android

Advantages of root android

1674143770.png
Techno Sensei
3 months ago
How To Make Gaming on Smartphones Smoother

How To Make Gaming on Smartphones Smoother

1676196989.jpg
JAFAR
3 months ago
Self-Driving Car, A Good Step For The Future

Self-Driving Car, A Good Step For The Future

1674143770.png
Techno Sensei
4 months ago