/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

5 votes366 views4 answers
Mysql on duplicate key update
SQL
51 votes749 views6 answers
Installing mysql on ubuntu
SQL
0 vote365 views4 answers
How to connect form to database
SQL
0 vote349 views1 answer
Where case insensitive like mysql
SQL
1 vote409 views1 answer
Postgresql if 0 then 1
SQL
6 votes372 views3 answers
Oracle all dates between two dates
SQL
0 vote318 views1 answer
Java spring boot connect to sql server
SQL
0 vote353 views2 answers
Csv into data postgres
SQL
1 vote356 views1 answer
Mysql select if empty result
SQL
0 vote355 views1 answer
Get employees if not contains in sql
SQL