/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 vote195 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL
0 vote201 views1 answer
Mssql dockere
SQL
0 vote182 views1 answer
Power query case when
SQL
3 votes204 views1 answer
Select table column in sql
SQL
0 vote187 views1 answer
C# mysql data reader from two tables
SQL
0 vote215 views1 answer
Mysql delete from where like
SQL
1 vote209 views1 answer
Oracle lowercase
SQL
0 vote194 views1 answer
Use between operator in mysql
SQL
0 vote210 views1 answer
How to combine first and last nae into one columb sql
SQL
0 vote188 views1 answer
Call procedure in wordpress
SQL