MySql 8 mysql_secure_installation

By | August 24, 2021

sudo mysql_secure_installation
passwordnya : mautauaja
Remove anonymous users? (Press y|Y for Yes, any other key for No) : y
Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y
Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y
Reload privilege tables now? (Press y|Y for Y
es, any other key for No) : y

login ke mysql :
sudo mysql

CREATE USER 'telo'@'%' IDENTIFIED WITH mysql_native_password BY 'passwordnya';
GRANT ALL PRIVILEGES ON . TO 'telo'@'%' WITH GRANT OPTION;