/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

16 votes324 views3 answers
Delete row psql
SQL
0 vote324 views1 answer
Import big data to mysql
SQL
0 vote323 views1 answer
Restart sql server command line linux
SQL
2 votes320 views2 answers
Postgres select duplicate columns
SQL
1 vote342 views1 answer
Postgresql how to show table names
SQL
1 vote341 views1 answer
Age postgres
SQL
0 vote330 views1 answer
Get first 3 letter of department name in sql
SQL
0 vote354 views1 answer
Oracle list datafiles
SQL
0 vote351 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
0 vote307 views1 answer
Select row from mysql where date more than 30 days
SQL