Installing MySql on Ubuntu

Steps for install mysql server
sudo apt-get install mysql-server

Steps and Question :

  1. Additional Space
    Y

Steps to setup mysql server
sudo mysql_secure_installation
Steps and Question :

  1. Validate Password Plugin
    y
  2. Password Validation Policy
    0
  3. Set new Passwowrd for root
    root
  4. Do you wish to continue with the password
    y
  5. Remove anonymus users
    y
  6. Disallow root to login remotely
    y
  7. Remove test database and access to it
    y
  8. Reload privilege table now
    y

Install MySql Workbench manually**

Steps to login to mysql server**
sudo mysql -u root -p
-Check databases
show databases
-Default port for mysql 3606

Steps to restart MySql Service

sudo service mysql restart

Leave a Comment