How to install mysql in ubuntu 18.04
1. sudo apt-get install mysql-server mysql-client libmysqlclient-dev2. 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