/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

3 votes351 views1 answer
Oracle show trigger code
SQL
0 vote309 views1 answer
Java spring boot connect to sql server
SQL
1 vote399 views1 answer
Mariadb get column names from table
SQL
0 vote327 views1 answer
Default column value in sql same as other column
SQL
0 vote355 views1 answer
To Create directory
SQL
0 vote340 views1 answer
Mysql select last 15 minutes
SQL
0 vote341 views4 answers
Mysql select bottom 10 rows
SQL
0 vote362 views1 answer
Mysql exception output
SQL
4 votes366 views2 answers
Tsql utf to local time
SQL
2 votes352 views1 answer
How to insert string variable into sqlite database
SQL