/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 vote255 views1 answer
Vbscript connect mssql
SQL
0 vote252 views1 answer
Oracle list partitions
SQL
0 vote237 views4 answers
Rownum in sql
SQL
0 vote229 views1 answer
Oracle current session details
SQL
0 vote224 views1 answer
Order by with where clause in mysql
SQL
1 vote236 views1 answer
Oracle user last connection date
SQL
0 vote243 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
1 vote239 views2 answers
Drop table if exists test
SQL
0 vote244 views1 answer
Renommer base sql
SQL
1 vote276 views1 answer
Create new table from old table
SQL