When installing MySQL, the new defaults are considered weak by most standards and raise concerns about the potential of allowing intrusion or exploitation by hackers. Restart the MySQL service: sudo systemctl restart mysqld How to Secure MySQL Start the MySQL service: sudo systemctl start mysqldĭisable the MySQL service at system startup: sudo systemctl disable mysqldĪctivate the MySQL service at system startup: sudo systemctl enable mysqld Stop the MySQL service: sudo systemctl stop mysqld
Proceed on to securing your MySQL instance.īelow are some of the most common system commands you will require to manage your MySQL systemd service. Pin systemctl status MySQL community example debian 11 bullseyeįor new installations, everything should be status ok. Once entered, press the enter key or the tab key to select the and hit the enter button to proceed with the installation. Now that you have completed the import of the repository for MySQL, execute the command to install as follows: sudo apt install mysql-community-server -yĪ new pop-up will appear during the installation, prompting you to enter the database root password. echo 'deb bullseye mysql-tools' | sudo tee -a /etc/apt//mysql.listĮcho 'deb-src bullseye mysql-tools' | sudo tee -a /etc/apt//mysql.list Users that are using MySQL for development can additionally import the following repositories. echo 'deb bullseye mysql-8.0' | sudo tee /etc/apt//mysql.list sudo wget -O- | gpg -dearmor | sudo tee /usr/share/keyrings/mysql.gpg Import the MySQL Community Repositoryīy default, MySQL 8.0 Community Edition is unavailable on Debian 11’s repository luckily, a repository exists from the MySQL official repository allowing you to import the latest stable version.įirst, import the GPG key using the following command. Note, wget should be installed automatically but run the command to verify if you are unsure. sudo apt install software-properties-common apt-transport-https wget ca-certificates gnupg2 -y These may be already present as they are very common packages if unsure, just run the command. The tutorial will require the following packages installed. sudo apt update & sudo apt upgrade Install Required Packages First, before proceeding any further, update your system to ensure all existing packages are up to date.
0 kommentar(er)
