Reload privilege tables now? (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 Following questions will be prompt and you have to press yes/y for all : Remove anonymous users? (Press y|Y for Yes, any other key for No) : yĭisallow root login remotely? (Press y|Y for Yes, any other key for No) : y This will remove some anonymous users and test database, disable remote root logins and load these new rules so that MySQL immediately respects the changes you have made. Now, for all next questions press Y and hit Enter key for each.

If your current password is perfect then, enter N for No at the prompt. Next, It will ask if you want to change current root user password. Press ENTER if you don’t want to set up the validate password plugin. After that, it will ask you to choose whether to use the VALIDATE PASSWORD PLUGIN or not, which can be use to test the strength of your MySQL password. Once you execute this command it will prompt you to enter root user password which you set before this step. Run then below command: sudo mysql_secure_installation You can improve MySQL security by execute the mysql_secure_installation command. Loaded: loaded (/lib/systemd/system/rvice enabled vendor preset: enĪctive: active (running) since Thr 16:40:45 UTC 20s ago It should show below output if service active: To check the MySQL service status issue below given command: sudo systemctl status mysql It will start the MySQL service automatically once the installation is completed. Before selecting the default MySQL 8 authentication plugin make sure it is supported by your application. Next, you will be presented with a message informing you about the new MySQL 8 authentication.Īfter that, it will prompt with a message informing you about the new MySQL 8 authentication. This password will be use as root user password. Enter a strong password for root user and hit Ok button. It will prompt to set root user password as below. Use the below command to install MySQL server on your Debian system: sudo apt install mysql-server

Debian install mysql server