/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 vote362 views1 answer
Define a variable in mysql from select
SQL
0 vote344 views1 answer
Last date for each user sql
SQL
2 votes314 views1 answer
Select from array in psql
SQL
0 vote355 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
1 vote328 views1 answer
ALL_TAB_PARTITIONS
SQL
1 vote322 views1 answer
Sql list all procedures
SQL
4 votes350 views1 answer
Postgresql list sequences
SQL
1 vote327 views1 answer
Oracle check table space
SQL
0 vote313 views1 answer
Sql query for getting data with join and count
SQL
0 vote329 views1 answer
Oracle string substitution
SQL