/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

3 votes96 views1 answer
DB: in eloquent using sql
SQL
3 votes145 views2 answers
Mysql user permission database
SQL
0 vote100 views1 answer
Group by two columns postgres
SQL
-1 vote100 views1 answer
Io
SQL
0 vote104 views1 answer
Max mysql
SQL
0 vote99 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote122 views1 answer
Update database collation in postgresql
SQL
0 vote124 views1 answer
How to change mysql port in xampp
SQL
10 votes141 views4 answers
Sql server pagination
SQL
0 vote106 views2 answers
List all the items that have not been part of any purchase order. sql
SQL