/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 votes351 views2 answers
Sql strip non alphanumeric characters
SQL
0 vote359 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
0 vote331 views1 answer
Take sql dump in to file
SQL
2 votes350 views1 answer
SQL column name Postgre
SQL
11 votes363 views3 answers
Sql line numbers
SQL
0 vote322 views1 answer
Time in sql server
SQL
1 vote359 views1 answer
Oracle sql average
SQL
1 vote361 views1 answer
Mysql strict_trans_tables
SQL
0 vote352 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote335 views1 answer
Sql server convert date to weekday
SQL