/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 vote191 views1 answer
Myswql show full processlist
SQL
0 vote200 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote223 views2 answers
Sql if empty then
SQL
1 vote257 views1 answer
Drop column if exists sql server
SQL
0 vote226 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote216 views1 answer
Query builder doctrien return sql
SQL
0 vote186 views1 answer
Shrink database file in sql server
SQL
4 votes229 views6 answers
Select sql
SQL
1 vote219 views2 answers
Mysql does sentance contain word
SQL
0 vote231 views2 answers
Suse Linux restart MySQL
SQL