/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 vote194 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
1 vote157 views2 answers
Group_concat limit mysql
SQL
0 vote149 views1 answer
How to find sql server installation folder
SQL
11 votes180 views3 answers
Change column name sql server management studio
SQL
0 vote224 views2 answers
Fanyi
SQL
6 votes146 views2 answers
Oracle
SQL
0 vote163 views2 answers
Change database postgres
SQL
13 votes149 views2 answers
Mysql order by multiple columns
SQL
3 votes163 views2 answers
How to start postgresql on windows
SQL
0 vote167 views1 answer
What logs are available on RDS MySQL?
SQL