/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

1 vote337 views2 answers
Sql left characters
SQL
0 vote324 views1 answer
Mysql regex exact match
SQL
0 vote376 views1 answer
Add user mysql wordpress
SQL
0 vote378 views1 answer
How to get button for every record from mysql
SQL
1 vote363 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote333 views2 answers
Reseed sql identity
SQL
1 vote307 views1 answer
SQLSTATE[HY000] [2002]
SQL
1 vote347 views1 answer
Drop column if exists sql server
SQL
0 vote312 views1 answer
Import mysql'
SQL
2 votes319 views2 answers
Join update query in sql
SQL