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. MySQL.Use the below command to install MySQL server on your Debian system: sudo apt install mysql-server.Programster's Blog - Debian 8 - Install MySQL 5.6.Sudo apt install mysql-community-server -y Then use the following commands to install the MySQL server (it will install the version you selected). #!/bin/bashĪt the popup-page, select the version you want. If you really want MySQL instead of MariaDB for whatever reason, you can execute the script below to install the version you want. If you decide to just go with MariaDB 10.1 and are confused by the lack of a prompt to set the root password, just login with sudo mysql and then use mysql command to set the password: GRANT ALL ON *.* TO identified by 'myawesomepassword' Install MySQL 5.6, 5.7, or 5.8-preview However, with Debian 9, if you do this you will end up installing MariaDB 10.1 which is a drop in replacement for 5.6. You would then receive either MySQL 5.5, 5.6, or 5.7 depending on which distro you were using, but they were all versions of MySQL. Usually, to install MySQL on a distro, you would just perform the following commands: sudo apt update The steps below will show you how to install whichever version of MySQL-server you want on your Debian 9 server and why you should not just run sudo apt install mysql-server -y Similar Posts
0 kommentar(er)
