/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 vote114 views1 answer
Create a table from one field of another table
SQL
20 votes110 views2 answers
Counting in sql
SQL
2 votes120 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
10 votes115 views1 answer
Query to find object dependencies in oracle
SQL
3 votes124 views1 answer
Oracle revoke
SQL
1 vote140 views2 answers
Mysql does sentance contain word
SQL
0 vote140 views1 answer
Mysql join only one column
SQL
0 vote112 views1 answer
Use where instead of join
SQL
0 vote129 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote114 views1 answer
Sql make sure every user is unqiuew
SQL