/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 vote302 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
8 votes348 views6 answers
Insert command in sql
SQL
1 vote348 views1 answer
Create new table from old table
SQL
14 votes327 views5 answers
Sql oracle limit
SQL
10 votes342 views4 answers
Mysql if else
SQL
1 vote299 views1 answer
Sql try catch
SQL
0 vote334 views1 answer
Oracle table privileges
SQL
0 vote337 views3 answers
Condition in count sql
SQL
1 vote312 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote314 views1 answer
Update and keep original value sql
SQL