mysql_secure_installation
Output ... Failed! Error: SET PASSWORD has no significance for user 'root'@'localhost' as the authentication method used doesn't store authentication data in the MySQL server. Please consider using ALTER USER instead if you want to change authentication parameters. New password: First, open up the MySQL prompt:
sudo mysql
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
exit First, open up the MySQL prompt:
ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket;
sudo mysql_secure_installation
sudo mysql mysql -u root -p
CREATE USER 'sammy'@'localhost' IDENTIFIED BY 'password';
grant all privileges on bbsdb.* to bbs@localhost with grant option;
FLUSH PRIVILEGES;
