Install debian mysql

Next, set the root password and accept other prompts to remove anonymous database users, disallow remote root login, remove test databases and reload privileges tables to effect the changes on MySQL.

Install MariaDB Save my name, email, and website in this browser for the next time I comment. Buy Me a Coffee. Sunday, December 19, Sign in.

Having added the repository and with our package cache freshly updated, we can now use apt to install the latest MySQL server package:. It will then calculate package dependencies and ask you to approve the installation. The software will install. You will be asked to set a root password during the configuration phase of the installation.

Choose and confirm a secure password to continue. Next, a prompt will appear asking for you to select a default authentication plugin. Read the display to understand the choices. If you are not sure, choosing Use Strong Password Encryption is safer. MySQL comes with a command we can use to perform a few security-related updates on our new install. This will ask you for the MySQL root password that you set during installation.

First, we are asked about the validate password plugin , a plugin that can automatically enforce certain password strength rules for your MySQL users. If enabled, you will also be prompted to choose a level from 0—2 for how strict the password validation will be. Since we just created the password when we installed MySQL, we can safely skip this. The rest of the prompts can be answered yes. You will be asked about removing the anonymous MySQL user, disallowing remote root login, removing the test database, and reloading privilege tables to ensure the previous changes take effect properly.

These are all a good idea. The script will exit after all the prompts are answered. Now our MySQL installation is reasonably secured. The -u root portion tells mysqladmin to log in as the MySQL root user, -p instructs the client to ask for a password, and version is the actual command we want to run. Source Installation Prerequisites. Choosing an Installation Package. Extracting the Install Archive. Creating an Option File. Initializing the Data Directory. Starting the Server for the First Time.

Windows Postinstallation Procedures. Windows Platform Restrictions. Postinstallation Setup and Testing. Changes in MySQL 8. Preparing Your Installation for Upgrade. Upgrade Troubleshooting. Rebuilding or Repairing Tables or Indexes. Installing ActiveState Perl on Windows.