/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 vote178 views1 answer
Create database like
SQL
0 vote158 views1 answer
Mysql earlier than date
SQL
0 vote236 views1 answer
How do you insert boolean to postgresql
SQL
3 votes171 views3 answers
Raw select laravel
SQL
1 vote173 views1 answer
Mysql backup skip table
SQL
4 votes249 views4 answers
Remove duplicate old value in mysql
SQL
1 vote218 views1 answer
Postgresql where datetrunc month and year equal
SQL
3 votes272 views1 answer
Sql datetime as date
SQL
0 vote196 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote183 views1 answer
Sql delimiter to columns
SQL