/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 vote126 views1 answer
Oracle last user logon
SQL
0 vote123 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote178 views1 answer
Delete from table where length sql
SQL
11 votes123 views2 answers
Insert date sql
SQL
7 votes128 views3 answers
Postgresql dump and restore db
SQL
0 vote128 views1 answer
Can we rollback deleted data in sql
SQL
1 vote128 views1 answer
Change old domain to new domain name wordpress
SQL
1 vote129 views1 answer
Sql update table remove spaces
SQL
-1 vote125 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
0 vote130 views1 answer
Sqlalchemy.exc.OperationalError:
SQL