How to run mysql in ubuntu through terminal

Question

I am seeking to run MySQL in ubuntu typing mysql in the terminal and I am getting the below error.

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

Can anyone help me sort out this problem?

Answer 1

You need to give a valid username. For example, to run a query with user root you need to type the following command and then enter the password when prompted:

mysql -u root -p

When you get connected, the prompt will be looking like:

mysql>

Then here you can write your query, after the database selection, for example:

mysql> USE your_database;
mysql> SELECT * FROM your_table;

Become a SQL expert with this complete SQL Training Course!