/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

0 vote158 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
1 vote137 views1 answer
Mysql history command
SQL
0 vote170 views1 answer
In query in sql
SQL
0 vote165 views1 answer
Replace \n sql
SQL
0 vote141 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote153 views2 answers
Timing sql queries
SQL
0 vote130 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
31 votes156 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote137 views1 answer
Mysql calculated column
SQL
0 vote145 views1 answer
Sql get user account
SQL