/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 vote122 views1 answer
Mysql select and count left join
SQL
0 vote122 views1 answer
How to display value of variable in mysql
SQL
0 vote119 views1 answer
Sql server select ignore dupplicates
SQL
0 vote126 views1 answer
QUERY JPQL
SQL
0 vote115 views1 answer
Mysql random number between 1 and 100
SQL
1 vote108 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote117 views2 answers
What is 1=2 in sql
SQL
2 votes131 views4 answers
Sql query interview questions
SQL
0 vote102 views1 answer
What are the aggregate function in sql
SQL
0 vote114 views1 answer
Find most frequent value in SQL column
SQL