/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 vote267 views3 answers
ChAnge TABLE name apex oracle
SQL
-1 vote262 views1 answer
Sql getdate date only
SQL
0 vote296 views1 answer
Consecutive numbers sql
SQL
0 vote292 views1 answer
Show tables in cassandra cql
SQL
0 vote315 views1 answer
Sql basic commands
SQL
8 votes247 views3 answers
Duplicate entry
SQL
1 vote250 views1 answer
Mysqli connect
SQL
0 vote293 views2 answers
How to prevent sql injection in java
SQL
1 vote256 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote285 views1 answer
Sql query tags
SQL