/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 vote144 views1 answer
Dump db only triggers mysql
SQL
0 vote172 views1 answer
Php insert null mysql
SQL
0 vote101 views2 answers
Jupyter notebook connect to database
SQL
0 vote148 views1 answer
Mysqlimport
SQL
0 vote149 views1 answer
How to map sql column to custom names
SQL
1 vote166 views1 answer
Sql server loop over query
SQL
1 vote146 views1 answer
Age postgres
SQL
10 votes142 views5 answers
Between keyword in sql
SQL
1 vote139 views1 answer
Md5 encryption for existing records
SQL
-1 vote137 views3 answers
Error mysql shutdown unexpectedly
SQL