Welcome to our tutorial on how to install MySQL 8 on Debian 10 Buster.<\/p>\n\n\n\n
In this guide, we are going to install MySQL 8 on Debian 10 Buster from the source code. As such, before you can continue, you need to install some required dependencies.<\/p>\n\n\n\n
Since we are installing MySQL 8 from the source code, there are a number of build tools that are required for a successful build process.<\/p>\n\n\n\n
apt install cmake libncursesw5-dev libncurses5-dev cmake build-essential libssl-dev<\/code> pkg-config<\/code><\/pre>\n\n\n\nInstall Boost C++ Library.<\/h4>\n\n\n\n
As a required dependency, MySQL currently requires boost_1_69_0. You would however install from repos, but the available version is boost_1_67. Hence, you need to build Boost C++ from source code. Therefore, download it and build it and install it as shown below.<\/p>\n\n\n\n
wget https:\/\/dl.bintray.com\/boostorg\/release\/1.69.0\/source\/boost_1_69_0.tar.gz -P \/tmp<\/code><\/pre>\n\n\n\ncd \/tmp<\/code><\/pre>\n\n\n\ntar xzf boost_1_69_0.tar.gz<\/code><\/pre>\n\n\n\ncd boost_1_69_0\n.\/bootstrap.sh --prefix=\/us<\/code>r\/<\/code><\/pre>\n\n\n\n.\/b2 \n.\/b2 install<\/code><\/pre>\n\n\n\nCreate mysql<\/code> User and Group<\/h3>\n\n\n\nA mysql<\/code> user is required to run MySQL server.<\/p>\n\n\n\nuseradd -r -M -s \/bin\/false mysql<\/code><\/pre>\n\n\n\nDownload MySQL 8 Source Code<\/h3>\n\n\n\n
Next, navigate to MySQL Download Area<\/a> and download the generic Linux (Architecture Independent) MySQL 8 source code. You can simply run the command below to download MySQL 8.16.<\/p>\n\n\n\nwget https:\/\/dev.mysql.com\/get\/Downloads\/MySQL-8.0\/mysql-8.0.16.tar.gz -P \/tmp<\/code><\/pre>\n\n\n\nOnce the download is done, verify the integrity by comparing the MD5 checksums. The MD5 checksum of the downloaded archive should be: MD5: 06f16ed2dc84abeaa77c697c2d6f07e5<\/code><\/p>\n\n\n\ncd \/tmp\nmd5sum mysql-8.0.16.tar.gz \n06f16ed2dc84abeaa77c697c2d6f07e5 mysql-8.0.16.tar.gz<\/code><\/pre>\n\n\n\nIf the integrity of the downloaded file passes, proceed to the next step.<\/p>\n\n\n\n
Extract the Source Code<\/h3>\n\n\n\n
Once the download is done, extract the MySQL 8 archive. In this demo, MySQL tarball is downloaded to \/tmp<\/strong>.<\/p>\n\n\n\ntar xzf mysql-8.0.16.tar.gz<\/code><\/pre>\n\n\n\nNavigate to the extracted source directory and create MySQL 8 build directory.<\/p>\n\n\n\n
cd mysql-8.0.16\/<\/code><\/pre>\n\n\n\nmkdir build<\/code><\/pre>\n\n\n\nNext, navigate to the build directory just created and build it as shown below;<\/p>\n\n\n\n
cd build\ncmake ..\/..\/mysql-8.0.16<\/code><\/pre>\n\n\n\nNext, run the make<\/strong> command to build the directory.<\/p>\n\n\n\nmake<\/code><\/pre>\n\n\n\nInstall MySQL 8 on Debian 10 Buster<\/h3>\n\n\n\n
Once the compilation of MySQL is done, you can install it using the make install<\/strong> command.<\/p>\n\n\n\nmake install<\/code><\/pre>\n\n\n\nThis will install MySQL under \/usr\/local\/mysql<\/strong>.<\/p>\n\n\n\nInitialize MySQL 8 Data Directory<\/h3>\n\n\n\n
Once the installation is done, you need to initialize the data directory. Hence, navigate to MySQL installation directory.<\/p>\n\n\n\n
cd \/usr\/local\/mysql\/<\/code><\/pre>\n\n\n\nNext, create a MySQL directory for import and export operations. This directory will be used a value to the secure_file_priv<\/strong> system variable.<\/p>\n\n\n\nmkdir mysql-files<\/code><\/pre>\n\n\n\nSet the user and group ownership of the the directory above to mysql<\/strong>. Also set the permissions of the directory to rwxr-x—<\/strong>.<\/p>\n\n\n\nchown mysql:mysql mysql-files\nchmod 750 mysql-files<\/code><\/pre>\n\n\n\nNext, initialize the database by executing the command below;<\/p>\n\n\n\n
bin\/mysqld --initialize --user=mysql<\/code><\/pre>\n\n\n\n2019-07-20T12:56:06.835551Z 0 [System] [MY-013169] [Server] \/usr\/local\/mysql\/bin\/mysqld (mysqld 8.0.16) initializing of server in progress as process 11174\n2019-07-20T12:56:10.680260Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: .qMkS;oEu8+(\n2019-07-20T12:56:12.782049Z 0 [System] [MY-013170] [Server] \/usr\/local\/mysql\/bin\/mysqld (mysqld 8.0.16) initializing of server has completed<\/code><\/pre>\n\n\n\nAs you can see from the output, the initial temporary password of the root@localhost<\/strong> user is generated, A temporary password is generated for root@localhost:<\/strong> .qMkS;oEu8+(<\/strong><\/p>\n\n\n\nRunning MySQL 8<\/h3>\n\n\n\n
Copy MySQL startup files from the support-files<\/strong> directory to \/etc\/init.d<\/strong>.<\/p>\n\n\n\ncp support-files\/mysql.server \/etc\/init.d\/mysql<\/code><\/pre>\n\n\n\nReload the systemd manager configuration.<\/p>\n\n\n\n
systemctl daemon-reload<\/code><\/pre>\n\n\n\nStart MySQL.<\/p>\n\n\n\n
systemctl start mysql<\/code><\/pre>\n\n\n\nWhen mysql is run, systemd-sysv-generator<\/strong> will generate the \/run\/systemd\/generator.late\/mysql.service<\/strong> file. Copy this file to \/etc\/systemd\/system<\/strong>.<\/p>\n\n\n\ncp \/run\/systemd\/generator.late\/mysql.service \/etc\/systemd\/system<\/code><\/pre>\n\n\n\nEdit the \/etc\/systemd\/system\/mysql.service<\/strong>.<\/p>\n\n\n\nexport EDITOR=vim\nsystemctl edit mysql.service<\/code><\/pre>\n\n\n\n[Install]\nWantedBy=multi-user.target<\/code><\/pre>\n\n\n\nEnable MySQL to run on system boot.<\/p>\n\n\n\n
systemctl enable mysql<\/code><\/pre>\n\n\n\nAdd MySQL binary path your PATH environment.<\/p>\n\n\n\n
export PATH=$PATH:\/usr\/local\/mysql\/bin\/<\/code><\/pre>\n\n\n\nVerify that MySQL is working as expected by connecting to it using the temporary password generated during initialization.<\/p>\n\n\n\n
mysql -u root -p<\/code><\/pre>\n\n\n\nEnter password: .qMkS;oEu8+(\nWelcome to the MySQL monitor. Commands end with ; or \\g.\nYour MySQL connection id is 8\nServer version: 8.0.16\n\nCopyright (c) 2000, 2019, Oracle and\/or its affiliates. All rights reserved.\n\nOracle is a registered trademark of Oracle Corporation and\/or its\naffiliates. Other names may be trademarks of their respective\nowners.\n\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\n\nmysql><\/code><\/pre>\n\n\n\nOnce you login, reset the root password.<\/p>\n\n\n\n
ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyP@ssWord';<\/code><\/pre>\n\n\n\nYou can further confirm the version of MySQL by running the query.<\/p>\n\n\n\n
SHOW VARIABLES LIKE \"%version%\";<\/code><\/pre>\n\n\n\n+--------------------------+-------------------------------+\n| Variable_name | Value |\n+--------------------------+-------------------------------+\n| immediate_server_version | 999999 |\n| innodb_version | 8.0.16 |\n| original_server_version | 999999 |\n| protocol_version | 10 |\n| slave_type_conversions | |\n| tls_version | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 |\n| version | 8.0.16 |\n| version_comment | Source distribution |\n| version_compile_machine | x86_64 |\n| version_compile_os | Linux |\n| version_compile_zlib | 1.2.11 |\n+--------------------------+-------------------------------+\n11 rows in set (0.02 sec)<\/code><\/pre>\n\n\n\nMySQL initial Security<\/h3>\n\n\n\n
Next, you can run the initial security script, mysql_secure_installation<\/strong> to remove anonymous database users, disable remote root login and remove the test databases.<\/p>\n\n\n\nThat is all on how to install MySQL 8 on Debian 10 Buster. Enjoy.<\/p>\n\n\n\n
Related Tutorials;<\/h3>\n\n\n\n
Install MySQL 8 on FreeBSD 12<\/a><\/p>\n\n\n\nInstall MySQL 8 on Debian 9<\/a><\/p>\n\n\n\nInstall MySQL 8 on Fedora 30\/Fedora 29<\/a><\/p>\n\n\n\n