/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 vote243 views2 answers
What is 1=2 in sql
SQL
1 vote257 views3 answers
Connection string mysql
SQL
0 vote255 views1 answer
C# mysql update statement set value to null
SQL
6 votes251 views1 answer
Check Table Exists
SQL
1 vote256 views1 answer
Postgres install unaccent extension
SQL
0 vote277 views1 answer
Sql today at midnight
SQL
1 vote271 views1 answer
Psql import backup file for windows
SQL
0 vote276 views1 answer
Ansi sql count duplicate rows
SQL
1 vote272 views2 answers
Extract weekday from date in sql
SQL
-1 vote254 views1 answer
How to switch user in mysql
SQL