/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

36 votes40 views6 answers
Delete from where sql
SQL
0 vote32 views1 answer
Update using case in mysql
SQL
7 votes37 views5 answers
Sql remove spaces
SQL
0 vote46 views1 answer
Generate sql from specific migration ef core
SQL
0 vote42 views1 answer
How to check the port of mysql installation in mac
SQL
1 vote43 views1 answer
Oracle check table lock
SQL
0 vote40 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
1 vote37 views1 answer
Use of now() in mysql
SQL
1 vote44 views1 answer
Quit mysql
SQL
1 vote38 views3 answers
Read all columns of a table sql
SQL