Type below commands in your terminals.
First five commands are NOT required if you don't have any earlier version of mysql in your system.
sudo apt-get remove --purge mysql*
sudo apt-get purge mysql*
sudo apt-get autoremove
sudo apt-get autoclean
sudo apt-get remove dbconfig-mysql
sudo apt-get dist-upgrade
sudo apt-get install mysql-server
This will install mysql without prompting for a password.
Use the cat command to view the default password.
sudo cat /etc/mysql/debian.cnf
======= the sample output will be========
# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host = localhost
user = debian-sys-maint
password = it3vqmn8mXIBBama
socket = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
host = localhost
user = debian-sys-maint
password = it3vqmn8mXIBBama
socket = /var/run/mysqld/mysqld.sock
==================
mysql -udebian-sys-maint -p
Log in with the default password as given in above file. In this example password is it3vqmn8mXIBBama (copy and paste this password after above command)
You will enter into mysql teriminal.
Change password. ( In this example i am setting the password to root for user root)
UPDATE mysql.user SET authentication_string=PASSWORD('root'), PLUGIN='mysql_native_password' WHERE USER='root';
Exit from the mysql terminal (type exit)
exit
Restart the service
/etc/init.d/mysql restart
Try to login with user root (Type the password as root)
mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.32-0ubuntu0.18.04.1 (Ubuntu)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
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> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.03 sec)
mysql> create database test;
Query OK, 1 row affected (0.41 sec)
mysql> use test;
Database changed
mysql>
Try to perform some basic queries as given in this
file.
(If you are a beginner in SQL)
