/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 vote107 views1 answer
Table values functions in SQL
SQL
0 vote193 views1 answer
Oracle sql alter view add column
SQL
0 vote128 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
3 votes109 views3 answers
Sql last week
SQL
2 votes107 views2 answers
How to view created temporary tables in mysql
SQL
0 vote107 views1 answer
Mysql local password denied
SQL
1 vote109 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote112 views1 answer
Where date in datetime mysql
SQL
-1 vote127 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
0 vote143 views1 answer
How to get table id sequence postgres
SQL