/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

10 votes268 views4 answers
Mysql if else
SQL
0 vote142 views1 answer
How to get inserted id in sql server
SQL
0 vote180 views1 answer
Change redo log file size in mysql 5.6
SQL
1 vote155 views3 answers
Nth highest salary
SQL
3 votes147 views1 answer
Sql double index
SQL
0 vote132 views1 answer
Deny select insert update delete sql
SQL
6 votes134 views5 answers
Alter table oracle
SQL
1 vote141 views1 answer
Mariadb get column names from table
SQL
2 votes140 views1 answer
Sql column values comma separated
SQL
2 votes140 views3 answers
Write sql query to find the second highest salary of employee
SQL