/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

1 vote289 views2 answers
Datetrunc hour snowflake
SQL
0 vote295 views1 answer
Flask sqlalchemy session delete
SQL
0 vote277 views2 answers
Database owner can't create new tables postgres
SQL
0 vote268 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
1 vote324 views1 answer
Encrypt password postgresql
SQL
0 vote292 views1 answer
Search column name sql
SQL
0 vote302 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
2 votes267 views1 answer
Sql find missing values between two tables
SQL
0 vote280 views1 answer
Duplicate value unique constraint mysql error
SQL
3 votes279 views1 answer
Oracle apex message quit website
SQL