/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 vote138 views1 answer
How to connect postgresql database with java
SQL
0 vote147 views1 answer
What is delimiter in mysql
SQL
14 votes150 views2 answers
Sql cast
SQL
0 vote152 views1 answer
Mysql milliseconds
SQL
0 vote142 views2 answers
Sql last updated
SQL
10 votes184 views2 answers
Reset mysql root password mac
SQL
0 vote141 views1 answer
Power query case when
SQL
0 vote179 views1 answer
Sp help text in postgresql
SQL
0 vote171 views1 answer
Mysql show create db
SQL
0 vote145 views1 answer
Mysqldump ignore table
SQL