Very simple step. Type this command on your terminal:
mysql -u root -p
It’ll ask for your password that you had given while installing mysql on your Ubuntu machine.
Give the password and it’ll show something like this:
hagudu@hagudu-H81M-S1:~$ mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 52
Server version: 5.5.47-0ubuntu0.14.04.1 (Ubuntu)
Copyright (c) 2000, 2015, 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
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
You can find further reference by typing mysql –help or at the online manual.
How you can stop the mysql server from linux terminal?
It depends. Red Hat based distributions have the service command:
service mysqld stop
Other distributions require to call the init script directly: