/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 vote228 views1 answer
How to create a table in sql stack overflow
SQL
3 votes228 views1 answer
Sql is not like
SQL
1 vote240 views2 answers
Sql server add time to date
SQL
-1 vote238 views1 answer
Spring boot mysql connection properties
SQL
0 vote259 views1 answer
How to define a non primary composite key in sql
SQL
0 vote213 views1 answer
Select from 3 tables one is empty
SQL
2 votes227 views2 answers
Get all columns from table sql
SQL
0 vote222 views1 answer
Sql select min
SQL
0 vote237 views1 answer
Second Step in installing SQL workbench
SQL
6 votes214 views2 answers
WHERE value IS sql
SQL