How to login to Mysql from command line in Ubuntu

Question 1

I installed mysql on my ubuntu 14.04 machine. How can I login to mysql to create database and tables?

Question 2

Though MySQL should be running on your machine, type the following command on terminal to access mysql.

1. sudo service mysql start : It will start the mysql server.

2. mysql -u root -p : It will ask for password. Enter your password to get access to mysql.

praveen · Answer 1 · 2016-04-08T07:58:05+0000

Though MySQL should be running on your machine, type the following command on terminal to access mysql.

1. sudo service mysql start : It will start the mysql server.

2. mysql -u root -p : It will ask for password. Enter your password to get access to mysql.

Please log in or register to add a comment.