/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 vote208 views1 answer
Query on date sqlite flutter
SQL
2 votes203 views1 answer
Node and mysql like
SQL
0 vote215 views1 answer
List mysql tables and views
SQL
1 vote203 views1 answer
Column with prefix in sql
SQL
1 vote218 views1 answer
Oracle list data files
SQL
10 votes202 views1 answer
Oracle dependency
SQL
0 vote217 views1 answer
Tsql cmd exec script from file
SQL
4 votes204 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote210 views1 answer
Grant access on table in oracle
SQL
0 vote217 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL