/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 vote148 views2 answers
Plpgsql
SQL
9 votes160 views3 answers
Postgres make sql dump
SQL
1 vote148 views1 answer
Sql server if exists update else insert
SQL
0 vote126 views1 answer
Sql server select value large text
SQL
0 vote146 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote139 views1 answer
Check database restore status sql script
SQL
-1 vote133 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote119 views1 answer
Capture Image Store Image in Folder and image Path in sqlite Database
SQL
12 votes140 views4 answers
How to check mysql version ubuntu
SQL
0 vote122 views1 answer
Laravel general error 2006 mysql server has gone away
SQL