/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 vote127 views3 answers
Get all tables postgres
SQL
-2 votes136 views1 answer
Modify column name in tsql
SQL
0 vote153 views1 answer
How do I insert a blob in SQL?
SQL
0 vote164 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote138 views1 answer
Mysql workbench primary key
SQL
2 votes135 views1 answer
Add default sql server
SQL
0 vote140 views2 answers
How to find max and min salary in sql
SQL
6 votes122 views1 answer
Oracle list primary key
SQL
8 votes144 views1 answer
Oracle search stored procedures for text
SQL
1 vote98 views1 answer
What are the cursors and what are the cursors types? in sql
SQL