Wednesday, 9 October 2019

How to install mysql in ubuntu 18.04 and Import mysql database

How to install mysql in ubuntu 18.04

1.  sudo apt-get install mysql-server mysql-client libmysqlclient-dev
2.  sudo service mysql status
3.  mysql -u root -p
4.  sudo mysql -u root -p
5.  uninstall plugin validate_password;
6.  ALTER USER 'root'@'localhost' IDENTIFIED BY 'root';
7.  ALTER USER 'root'@'localhost' IDENTIFIED WITH 
      mysql_native_password  BY 'root';
8.  SELECT user,authentication_string,plugin,host FROM mysql.user;
9.   ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
      BY 'password';
10.  ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password
       BY 'root';

  Import database:-  (mysql -u username -p database_name < file.sql)

No comments:

Post a Comment

  Common Git Commands   Take clone of a repository git clone <remote-repository-url> ex: git clone  https://github.com/agricor/RegTech...