/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 vote345 views1 answer
Mysql get nested records
SQL
0 vote263 views1 answer
Show function mysql
SQL
1 vote283 views1 answer
Spring postgresql reset auto increment to 0
SQL
5 votes283 views1 answer
Mysql count newlines in field
SQL
0 vote279 views1 answer
Ksql quickstart docker
SQL
0 vote257 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
4 votes287 views6 answers
Second max salary in sql
SQL
0 vote283 views1 answer
Get rows from 1 table with other table empty mysql
SQL
0 vote250 views1 answer
Sql select maximum column with other columns returned
SQL
1 vote270 views1 answer
Oracle create index if not exists
SQL