/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 vote243 views1 answer
Selecting from a view SQL
SQL
0 vote194 views1 answer
Sql server udf performance
SQL
2 votes190 views1 answer
Create table with primary key
SQL
2 votes205 views2 answers
Postgres add column integer
SQL
0 vote197 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote189 views1 answer
Check sql database table lock
SQL
0 vote265 views1 answer
Sql server current time without date
SQL
0 vote178 views2 answers
Influxdb delete measurement based on date
SQL
0 vote184 views1 answer
Zerar auto increment mysql
SQL
1 vote194 views1 answer
Postgres convert exisiting column to text
SQL