/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 vote179 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
0 vote189 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote175 views1 answer
Create table with primary key and foreign key in sql server
SQL
0 vote169 views1 answer
Sql pad left 0
SQL
0 vote172 views1 answer
Oracle list proxy users
SQL
2 votes168 views1 answer
Tsql copy table
SQL
6 votes134 views2 answers
Generate c# class from sql server table
SQL
7 votes247 views2 answers
3rd height salary sql
SQL
0 vote189 views1 answer
Reset postgres table index to next max value
SQL
1 vote171 views1 answer
Create procedure with encryption
SQL