MySQL is the most widely used open-source database management system used to keep and retrieve data for a broad variety of famous applications. In Debian 10, MariaDB comes with by default as a drop-in replacement for MySQL and in most cases, MariaDB works well.
That’s why, in our two previous articles, we have used the MariaDB database server, where we’ve shown how to install the LAMP and LEMP stack on Debian 10.
Erlang runtime system has built-in support for concurrency, distribution and fault tolerance. This tutorial will help you to install Erlang on Debian 9 (Stretch) and Debian 8 (Jessie). Step 1 – Prerequsiteis. Before starting the installation process make sure you have root or sudo privileged user access to your Debian system. Now login to your system. The USB Smargo Smartcard Reader Plus is kind of a Smart TV card reader, which can work for dreambox and most linux based satellite reciever for card sharing. It can read customer's. HD Decoder Card HDMI Encoder Holidays Industry News Installation Guide IPTV Modulator Server.
If you want features only found in MySQL, then you need to install it from the official MySQL APT repositories as shown in this article.
Step 1: Adding the MySQL Software Repository
To install the latest version of MySQL, you need to download and install the MySQL APT repository comes in
.deb
the package that manages to configure and install the MySQL software repositories on your Debian system.During the package installation, you will be prompted to configure the MySQL APT repository to select the versions of the MySQL server and other components that you want to install. Leave the default option to install the latest version. Once you are done, click Enter or go to OK and hit Enter.
Step 2: Installing MySQL on Debian 10
After adding the MySQL APT repository, update the APT packages cache and install the MySQL server package, which will also install the packages for the client and for the database common files as follows.
During the installation of the package, a package configuration dialog window will show up, asking you to set a database root user password for your MySQL. Enter a secure and strong password then confirm it by re-entering it.
Set MySQL Root Password
Then read about the new authentication system based on SHA256-based password methods, used by MySQL and click Ok. And choose the default authentication plugin you want to use (leave the default option to use the recommended plugin) and hit the Enter button to complete the installation process.
Set MySQL Password Authentication
When the package installation is complete, the installer triggers systemd to automatically start the MySQL service and configures it to start at system boot. To make sure that the MySQL service is up and running, verify its status using the following command.
Sample Output
There are several other systemctl commands that you need to know to manage (start, restart, stop, and reload) the MySQL service where necessary, these are:
Step 3: Securing MySQL in Debian 10
Any fresh MySQL server deployment is insecure by default and to improve the security of your MySQL server instance, you need to run the mysql_secure_installation shell script which prompts you to determine which actions to perform.
Then answer the questions correctly by reading the description of each. First, enter the root user password you set during the package installation. Then you can select
y
(for YES) or n
(for No) to use or not to use the VALIDATE PASSWORD component, respectively.Also, select
no
when asked to set a new root user password (which you already set during the package installation). Then carefully follow the other prompts and select y
(for YES) to remove anonymous users, disallow remote root login, remove the test database and reload the privileges table.Step 4: Testing MySQL Installation
After securing your MySQL server deployment, you can start using it for storing data for your websites or web applications. To access the MySQL shell, run the following command (enter the MySQL root password when prompted as shown in the following screenshot):
Connect to MySQL Shell
You will also find these following guides about MySQL useful:
Conclusion
In this article, we have explained how to install the latest version of MySQL database server in Debian 10. If you have any queries about this article, do send us via the feedback form below.
In this tutorial, I’m going to show you how to install docker on Debian 8 Jessie server. The Linux version of Docker is split into docker-engine and docker-compose.
Pre-requisites
Docker supports 64 bit system with Linux kernel 3.10+. To check whether your Debian system is 32 bit or 64 bit, use
uname -m
command.Debian 8 comes with a 3.16.0 Linux kernel. Use
uname -r
command to check your Linux kernel version.Use the following command to upgrade to the latest Linux kernel version available on Debian 8.
Note that if your VPS is virtualized using OpenVZ technology rather then KVM, then the kernel version might be very old and you are not allowed to upgrade kernel on OpenVZ VPS. So KVM VPS is a better choice.
Install Docker on Debian 8 Jessie Server
Add Docker GPG key.
Create a new source file under
/etc/apt/sources.list.d/
.Add this line in the file and save the file.
Because the docker repository requires HTTPS connection so we need to install apt-transport-https and ca-certificates package to make APT establish HTTPS connection with docker repository.
Update local package index and install docker on Debian 8.
Start the docker service.
Enable docker auto-start when Debian Jessie is booted up.
Check docker status.
Output:
![How To Install Smargo On Debian 8 How To Install Smargo On Debian 8](http://cdn.redmondpie.com/wp-content/uploads/2016/10/multibeast-02.jpg)
![Linux Linux](http://ae01.alicdn.com/kf/HTB1YaWZg_Zmx1VjSZFGq6yx2XXag.jpg_q50.jpg)
Verify Docker installation is working correctly with this command:
If you see this message, then it’s working correctly.
Check Docker version.
Install docker-compose
Switch to root user. Download the docker-compose binary from Github and save it to /usr/local/bin/docker-compose.
Make it executable.
At the time of this writing, the latest version of docker compose is 1.7.0, you may need to change the version number if you like a new version.
Check docker-compose version.
Exit out of root.
Congrats! Now you have successfully installed docker on Debian 8 Jessie.
[Total: 45 Average: 4.9]