/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 vote276 views2 answers
T SQl Checking Your Username
SQL
0 vote289 views1 answer
Distinct data types in a table sql query
SQL
0 vote295 views1 answer
Function plsql
SQL
8 votes339 views2 answers
Default sql server port
SQL
0 vote294 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
5 votes337 views2 answers
How to ascending order in sql
SQL
0 vote303 views1 answer
Hour differeence in mysql
SQL
0 vote269 views1 answer
Including parameters in OPENQUERY
SQL
0 vote301 views1 answer
Mysqli last row
SQL
1 vote272 views2 answers
How to check username in mysql command line
SQL