How To Install MySQL on Debian 9 (Stretch) with version selection Rumi, May 17, 2020May 17, 2020 Step 1 – Prerequisites Login to your Debian 9 system using shell access. For remote systems connect with SSH. Windows users can use Putty or other alternatives applications for SSH connection. ssh root@debian9 Run below commands to upgrade the current packages to the latest version. sudo apt update sudo apt upgrade Step 2 – Configure MySQL PPA MySQL team provides official MySQL PPA for Debian Linux. You can download and install the package on your Debian system, which will add PPA file to your system. Run below command to enable PPA. wget http://repo.mysql.com/mysql-apt-config_0.8.13-1_all.deb sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb During the installation of MySQL apt config package, It will prompt to select MySQL version to install. Select the MySQL 5.7 or 5.6 option to install on your system. Step 3 – Install MySQL on Debian 9 Your system is ready for the MySQL installation. Run the following commands to install MySQL on a Debian machine. sudo apt update sudo apt install mysql-server The installation process will prompt for the root password to set as default. Input a secure password and same to confirm password window. This will be MySQL root user password required to log in to MySQL server. Step 4 – Secure MySQL Installation Execute the below command on your system to make security changes on your Database server. This will prompt some questions. The do the high security provide all answers to yes. First start the MysQL service if not started: sudo systemctl restart mysql Then run below command: sudo mysql_secure_installation Step 5 – Connect MySQL The MySQL server has been installed on your system. Now connect to the MySQL database using the command line. mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.21 MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> Related Administrations Configurations (Linux) DebianDebian 9MySQL
Creating Software RAID-1 in Debian/Ubuntu May 26, 2013May 26, 2013 Below are the steps on how to configure the Software RAID: 1) Select the Manual for the Partitioning Method: 2) On this screen, it will show you the available hard disk for the installation. Make sure both hard disks are visible. Now select the first hard disk… Read More
Setup Tomcat with Apache2 and Java on Ubuntu 10.04 Server May 28, 2011May 28, 2011 Apache Tomcat (or Jakarta Tomcat or simply Tomcat) is an open source servlet container developed by the Apache Software Foundation (ASF). Tomcat implements the Java Servlet and the JavaServer Pages (JSP) specifications from Sun Microsystems, and provides a "pure Java" HTTP web server environment for Java code to run. … Read More
Allow ICMP Rule on Windows 7, Windows Vista, Windows Server 2008, or Windows Server 2008 R2 August 25, 2010 To allow inbound Internet Control Message Protocol (ICMP) network traffic, use the Windows Firewall with Advanced Security node in the Group Policy Management MMC snap-in to create firewall rules. This type of rule allows ICMP requests and responses to be sent and received by computers on the network. Related Read More