/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 vote268 views1 answer
Sql ignore
SQL
3 votes346 views4 answers
Sql interview questions
SQL
0 vote255 views1 answer
Incorrect string value: mysql
SQL
0 vote279 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote276 views1 answer
Name '_mysql' is not defined
SQL
0 vote279 views1 answer
Postgresql find biggest table
SQL
0 vote240 views0 answer
SQL
0 vote283 views1 answer
How to print some string in mysql
SQL
1 vote257 views1 answer
Sql to mongodb query converter
SQL
1 vote264 views1 answer
Show per page table in xampp
SQL