Detailed explanation of the installation tutorial of the latest stable version of mysql5.7.17 under Linux-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

Detailed explanation of the installation tutorial of the latest stable version of mysql5.7.17 under Linux

黄舟

Mar 29, 2017 pm 01:59 PM

This article mainly introduces the linux mysql5.7.17 latest stable versioninstallation tutorial to everyone in detail. It has certain reference value and is of interest. Friends can refer to

Install the latest stable version of mysql on Linux through source code: mysql-5.7.17
In order to facilitate the installation process without being affected by boost dependency, download mysql directly from the official website- boost-5.7.17.tar.gz version. (Official explanation: Boost is required during the compilation process, but it is not actually used.)

Installation directory:

Startup script: /etc/ init.d/mysqld
Program root directory:/usr/local/mysql
Data directory:/data/mysql

Installation process

1. Install dependencies

#yum install -y cmake gcc-c++* make ncurses-devel

Copy after login

2. Create mysql user

#groupadd mysql
#useradd -r -g mysql -s /bin/false mysql

Copy after login

3. Download mysql-boost-5.7.17.tar.gz and upload it to the server

#tar xzf mysql-5.7.17.tar.gz 
#cd mysql-5.7.17
#mkdir bld
#cd bld/
#cmake .. -DWITH_BOOST=../boost/ -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql 

#在此指定参数后减少很多后面启动过程中的操作
#make
#make install
#使用默认的配置文件
#cd /usr/local/mysql/support-files
#cp my-default.cnf ../my.cnf

#编译过程中出错，清除临时文件重新编译：
#make clean
#rm CMakeCache.txt

Copy after login

4 .After installation, add the executable file path to the system environment variable:

environment variable

#echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
#source /etc/profile

Copy after login

5. Initialize the database

#mkdir /data/mysql
#chown -R mysql.mysql /data/mysql
#mysqld --defaults-file=/usr/local/mysql/my.cnf --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/data/mysql/

Copy after login

After mysql5.7 is initialized, a password will be randomly generated and will be printed directly on the screen.

6. Startup
Copy the startup script:

#cd /usr/local/mysql/support-files
#cp mysql.server /etc/init.d/mysql

Copy after login

Start directly

#mysqld_safe --user=mysql &
或
#/etc/init.d/mysqld start

Copy after login

Call the security script after startup, implement: change root password, deletetest library, prohibit rootremote login

#mysql_secure_installation

Copy after login

partial configuration (not optimized)

[client]
port=3306
socket=/tmp/mysql.sock
character_set_client= utf8
[mysqld]
basedir = /usr/local/mysql
datadir = /data/mysql
port = 3306
socket = /tmp/mysql.sock
character-set-server = utf8
read_buffer_size=131072
#innodb
innodb_data_file_path=ibdata1:100M:autoextend
#binlog
server_id=1
log-bin=mysql-bin
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysqldump]
quick
max_allowed_packet=32M
[mysql]
[myisamchk]

Copy after login

The above is the detailed content of Detailed explanation of the installation tutorial of the latest stable version of mysql5.7.17 under Linux. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress images for free

Clothoff.io

AI clothes remover

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

How to fix KB5055523 fails to install in Windows 11?

4 weeks ago By DDD

How to fix KB5055518 fails to install in Windows 10?

4 weeks ago By DDD

Roblox: Grow A Garden - Complete Mutation Guide

3 weeks ago By DDD

Roblox: Bubble Gum Simulator Infinity - How To Get And Use Royal Keys

3 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

How to fix KB5055612 fails to install in Windows 10?

3 weeks ago By DDD

Hot Tools

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

God-level code editing software (SublimeText3)

Hot Topics

Java Tutorial

1664

CakePHP Tutorial

1421

Laravel Tutorial

1315

PHP Tutorial

1266

C# Tutorial

1239

Related knowledge

Linux Architecture: Unveiling the 5 Basic Components Apr 20, 2025 am 12:04 AM

The five basic components of the Linux system are: 1. Kernel, 2. System library, 3. System utilities, 4. Graphical user interface, 5. Applications. The kernel manages hardware resources, the system library provides precompiled functions, system utilities are used for system management, the GUI provides visual interaction, and applications use these components to implement functions.

How to check the warehouse address of git Apr 17, 2025 pm 01:54 PM

To view the Git repository address, perform the following steps: 1. Open the command line and navigate to the repository directory; 2. Run the "git remote -v" command; 3. View the repository name in the output and its corresponding address.

How to run java code in notepad Apr 16, 2025 pm 07:39 PM

Although Notepad cannot run Java code directly, it can be achieved by using other tools: using the command line compiler (javac) to generate a bytecode file (filename.class). Use the Java interpreter (java) to interpret bytecode, execute the code, and output the result.

What is the main purpose of Linux? Apr 16, 2025 am 12:19 AM

The main uses of Linux include: 1. Server operating system, 2. Embedded system, 3. Desktop operating system, 4. Development and testing environment. Linux excels in these areas, providing stability, security and efficient development tools.

How to run sublime after writing the code Apr 16, 2025 am 08:51 AM

There are six ways to run code in Sublime: through hotkeys, menus, build systems, command lines, set default build systems, and custom build commands, and run individual files/projects by right-clicking on projects/files. The build system availability depends on the installation of Sublime Text.

laravel installation code Apr 18, 2025 pm 12:30 PM

To install Laravel, follow these steps in sequence: Install Composer (for macOS/Linux and Windows) Install Laravel Installer Create a new project Start Service Access Application (URL: http://127.0.0.1:8000) Set up the database connection (if required)

git software installation Apr 17, 2025 am 11:57 AM

Installing Git software includes the following steps: Download the installation package and run the installation package to verify the installation configuration Git installation Git Bash (Windows only)

How to use VSCode Apr 15, 2025 pm 11:21 PM

Visual Studio Code (VSCode) is a cross-platform, open source and free code editor developed by Microsoft. It is known for its lightweight, scalability and support for a wide range of programming languages. To install VSCode, please visit the official website to download and run the installer. When using VSCode, you can create new projects, edit code, debug code, navigate projects, expand VSCode, and manage settings. VSCode is available for Windows, macOS, and Linux, supports multiple programming languages and provides various extensions through Marketplace. Its advantages include lightweight, scalability, extensive language support, rich features and version

See all articles