/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 vote302 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote328 views1 answer
Sqlite unique multiple columns
SQL
0 vote315 views1 answer
Mssql + bit + in python orm
SQL
24 votes311 views4 answers
Mysql datetime
SQL
3 votes345 views1 answer
Mysql group_concat distinct
SQL
0 vote315 views1 answer
How to delete python anywhere mysql database
SQL
1 vote279 views1 answer
Mysql order by desc null last
SQL
14 votes331 views3 answers
How to add default constraint in mysql
SQL
0 vote304 views1 answer
Oracle query archivemode
SQL
1 vote334 views1 answer
Backup mysql schema only
SQL