/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

8 votes162 views3 answers
Postgresql connection string c#
SQL
11 votes179 views2 answers
Safe mode off mysql
SQL
13 votes186 views2 answers
Sql join 3 tables
SQL
0 vote172 views1 answer
FIND most frequent word in sql server
SQL
1 vote170 views1 answer
Right outer vs left outer join
SQL
0 vote215 views1 answer
Mysql 3 months ago
SQL
0 vote193 views3 answers
Convert sql query to python pandas
SQL
0 vote193 views1 answer
Create table split string function in sql server
SQL
0 vote175 views1 answer
Mysql trim characters
SQL
0 vote234 views1 answer
Sqlalchemy query return only n results
SQL