MySQL is a free and open source RDBMS (Relational Database Management System ). Its used by many organization and many applications such as Wordpress . Its fast , secure , reliable and most important cost effective .
In this post we will follow step by step guide to install Mysql in Ubuntu 22.10 .
We are going to install latest version of mysql , as you know
apt is the repository in ubuntu .All the packages are instaled via apt repository .
Lets follow the steps of installing Ubuntu
- Update the Ubuntu Package manager
$linuxterminal sudo apt-get update
- As a next step let's install the MySQL server with the below command
sudo apt install mysql-server
This will by default install the latest mysql server 8.0 on your system .
- Now that we have mysql instaled , next is we need to check the mysql service is running or not . You can verify this using below command
sudo systemctl status mysql
if mysql is installed successfully then the mysql service status will be shown as below .
Now that we have installed My SQL and it is properly installed .
As a next step we need to do a secure installation of MySQL.In order to perform a secure installation mysql comes up with a inbuilt shell script called as
mysql_secure_installation . We can perform a variety of security related operations on our my school server using this script. The main purpose of the script to enable security on our mysql installation.
Here are the following operations that we can perform using this script.
- We can set passwords for user accounts
- We can remove root accounts that are accessible outside or within the local host.
- We can remove unknown user accounts
- We can remove or add databases we can
We can run the script by running
thelinuxterminal$ sudo mysql_secure_installation
If you check the output below , we get an option for
VALIDATE PASSWORD COMPONENT
[sudo] password for linuxterminal: 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:
The main purpose of this component used to check the strength of the password that we enter while doing a secure installation. Various types of password policies that are present are medium , strong and low. You can skip this as well if you enter no in the output step above .
Have a look at the options we get if we press yes
There are various options with which you can login to my SQL, one of the option is using a mysql client that is shift as a package with mysql installation.
Other Option is you can use mysqlworkbench or any kind of MySQL client to login to your my SQL server installed locally. We will login using built in mysql client .
thelinuxterminal$ sudo mysql
linuxterminal@linuxterminal-QEMU-Virtual-Machine:~$ sudo mysql [sudo] password for linuxterminal: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 8.0.31-0ubuntu2 (Ubuntu) Copyright (c) 2000, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>
Now , this login wont work if you try login using phpmyadmin or any external program running remotely. If you want to login using any external program you need to perform following step .
then perform following command
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'very_strong_password'; mysql> FLUSH PRIVILEGES;
Now what happens here is the default authentication mechanism for MySQL is
auth_socket , now if you want to login as a root you need to change the authentication mechanism . so how do I change it ? We change it by setting the password mechanism as
We have done mysql installation on our Ubuntu 22.10 . We have also seen how we can connect via mysql client and login to ubuntu 22.10. If you face and difficulty or any problem , let us know on comments.