/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 vote202 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote195 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote207 views1 answer
Mysql query problems and solutions
SQL
1 vote176 views1 answer
Sql server 2016 reseed identity
SQL
-1 vote261 views1 answer
MYSQL stored procedure select from
SQL
0 vote229 views1 answer
Sql where time stamp is in between
SQL
0 vote208 views1 answer
Mysql group by derived column
SQL
1 vote201 views1 answer
Oracle user last connected
SQL
2 votes202 views4 answers
Check timezone of mysql database
SQL
0 vote216 views1 answer
Select year from dual oracle
SQL