Breaking News: Grepper is joining You.com. Read the official announcement!

Mysql Install Ubuntu with native password

Obnoxious Oryx answered on October 27, 2021 Popularity 3/10 Helpfulness 1/10

answer Mysql Install Ubuntu with native password

Mysql Install Ubuntu with native password

Comment

#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

Popularity 3/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: native sql ubuntu

Link to this answer
Share Copy Link