/SQL/Mysql Install Ubuntu with native password

Mysql Install Ubuntu with native password

#installation
sudo apt update
sudo apt install mysql-server
sudo service mysql status

sudo mysql_secure_installation
#You will be asked to configure the VALIDATE PASSWORD PLUGIN which is used to test the strength of the MySQL users' passwords. Press ENTER if you don’t want to set up the validate password plugin.
#On the next prompt, You should answer “Y” (yes) to all questions.
#the root user is authenticated by the auth_socket plugin by default.
#This means that you can’t authenticate as root by providing a password.

#password type change
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'very_strong_password';
FLUSH PRIVILEGES;
quit

Source: stackoverflow.com

Similar codes

2 votes166 views1 answer
Match in sql server
SQL
3 votes335 views9 answers
Linq to sql converter online
SQL
1 vote178 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
8 votes194 views2 answers
Alert table name mysql
SQL
0 vote195 views1 answer
Mysql wsrep ls
SQL
2 votes190 views1 answer
Query to find table size in oracle 12c
SQL
1 vote200 views1 answer
Oracle sql average
SQL
0 vote198 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote200 views1 answer
Mysql locate
SQL
2 votes201 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL