/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 vote182 views1 answer
Md5 encryption for existing records
SQL
0 vote182 views1 answer
Oracle webcenter content search enginer
SQL
0 vote260 views1 answer
Postgresql powershell query
SQL
2 votes169 views1 answer
Oracle kill job by sid
SQL
1 vote170 views1 answer
Mysql datetime with timezone offset
SQL
0 vote241 views1 answer
Check user sql password from command line
SQL
16 votes190 views3 answers
Update table from another table
SQL
0 vote171 views1 answer
Django how to get query result count
SQL
2 votes135 views1 answer
Foreign key example in dbms
SQL
44 votes256 views6 answers
Rename command in sql
SQL