how to run mysql in ubuntu through terminal

Question

trying to run mysql in ubuntu typing mysql in terminal and getting error

ERROR 1045(28000): Access denied for user 'root'@'localhost' (using password: NO)

Can anybody please sort out this problem...

Answer 1

Let’s get started

Steps to run MySQL in ubuntu through terminal:

• It’s significant to have a valid username. let’s  say you have stud as user name then you have to use the following command to connect with MySQL:      

 mysql -u root -p

• After that enter the password to proceed for connecting with MySQL.

         Then choose the database and enjoy writing and execute the query.

mysql> USE Covid_19;;

mysql> SELECT * FROM Infection_rate;