How to start MySQL in Linux terminal

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
Enter password:
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
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

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:

/etc/init.d/mysqld stop

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s