Home Database Mysql Tutorial Detailed introduction to the entire process and precautions of installing MySql5.7.17 under the latest Linux system

Detailed introduction to the entire process and precautions of installing MySql5.7.17 under the latest Linux system

Mar 23, 2017 pm 01:52 PM

This article is the latest versionlinuxUnder the systemInstallationmysql 5.7 The whole process of .17 and Notes are very good and have reference value. Friends who need it can refer to it

1. cd /usr/local/ ##Enter the local directory

2. cp /home/soft/MySQL-5.7.15-Linux-glibc2.5-x86_64.tar.gz /usr/local/

##Copy mysql compressed to the local directory

3. cd /usr/local/ ##Enter the local directory

4. tar -xzvf mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz

##Decompress the mysql compressed package

5, mv mysql-5.7.15-linux-glibc2.5-x86_64 mysql ##Rename the mysql directory

6, groupadd mysql ##Add A mysql group

7, useradd -r -g mysql mysql ##Add a user

8, chown -R mysql mysql/ ##Authorize the mysql directory to the mysql user

9. mkdir /home/mysql-data ##Create the mysql-data directory

10. chown -R mysql:mysql /home/mysql-data ##Authorize the mysql-data directory to the mysql group Mysql user

11, chgrp -R mysql /home/mysql-data ## The chgrp command can use the group name or group identifier to change the group to which a file or directory belongs (-R: Process all files in the specified directory and its subdirectories) The usage permission is super user

12. cd /usr/local/mysql ##Enter the mysql directory

13. cp support-files. /my-default.cnf ./my.cnf ##Copy the my-default.cnf file in the support-files directory to the my.cnf file in the current directory

14, vi /usr/local/mysql/ my.cnf ##Edit my.cnf file

basedir = /usr/local/mysql
##basedir is the path to mysql
datadir = /home/mysql-data
## datadir is the data package of mysql, which stores mysql's own package
port = 3306 ##mysql port
#server-id = 100
##Server ID

socket = /tmp /mysql.sock

15. cp -fr my.cnf /etc/my.cnf ##Copy the my.cnf file to the etc directory (replace it if it exists in the etc directory)

16. vi /etc/profile ##Edit the profile file in the etc directory

export PATH=/usr/local/mysql/bin:$PATH
##Add

# at the end of the profile file ##17. source /etc/profile ##Reload the profile file in the etc directory

18. cp -a ./support-files/mysql.server /etc/init.d/mysqld

##Copy

19../bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/home/mysql-data

##Initialization

Important:

You need to pay attention to recording the generated temporary password, as above: jgghKqQhZ8*e

Note:

If the error message after execution is ./bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file:

No such file or directory

CentOS7.2 needs to install libaio, execute the following command to install it

[root@localhost mysql]# yum install libaio

Re-execute the initialization command after the installation is complete

20, [[[password]]]] ##Note the generated temporary password, such as: jgghKqQhZ8*e

21, /etc/init .d/mysqld start ##Start mysql

22、/etc/init.d/mysqld status ##View mysql status

23、bin/mysql -u root –p ##Log in mysql

24. Enter the temporary password ##The temporary password generated by mysql, such as: jgghKqQhZ8*e

25. set password=password('A123456'); ##Change password

26. grant all privileges on *.* to root@'%' identified by 'A123456';


##27. flush privileges;

##28. use mysql;

##29. select host,user from user;

##30. Remotely connect to the database, or restart.


The above is the detailed content of Detailed introduction to the entire process and precautions of installing MySql5.7.17 under the latest Linux system. 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

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

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

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What computer configuration is required for vscode What computer configuration is required for vscode Apr 15, 2025 pm 09:48 PM

VS Code system requirements: Operating system: Windows 10 and above, macOS 10.12 and above, Linux distribution processor: minimum 1.6 GHz, recommended 2.0 GHz and above memory: minimum 512 MB, recommended 4 GB and above storage space: minimum 250 MB, recommended 1 GB and above other requirements: stable network connection, Xorg/Wayland (Linux)

Linux Architecture: Unveiling the 5 Basic Components 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 run java code in notepad 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.

vscode terminal usage tutorial vscode terminal usage tutorial Apr 15, 2025 pm 10:09 PM

vscode built-in terminal is a development tool that allows running commands and scripts within the editor to simplify the development process. How to use vscode terminal: Open the terminal with the shortcut key (Ctrl/Cmd). Enter a command or run the script. Use hotkeys (such as Ctrl L to clear the terminal). Change the working directory (such as the cd command). Advanced features include debug mode, automatic code snippet completion, and interactive command history.

How to check the warehouse address of git 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.

Where to write code in vscode Where to write code in vscode Apr 15, 2025 pm 09:54 PM

Writing code in Visual Studio Code (VSCode) is simple and easy to use. Just install VSCode, create a project, select a language, create a file, write code, save and run it. The advantages of VSCode include cross-platform, free and open source, powerful features, rich extensions, and lightweight and fast.

What is the main purpose of Linux? 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.

vscode terminal command cannot be used vscode terminal command cannot be used Apr 15, 2025 pm 10:03 PM

Causes and solutions for the VS Code terminal commands not available: The necessary tools are not installed (Windows: WSL; macOS: Xcode command line tools) Path configuration is wrong (add executable files to PATH environment variables) Permission issues (run VS Code as administrator) Firewall or proxy restrictions (check settings, unrestrictions) Terminal settings are incorrect (enable use of external terminals) VS Code installation is corrupt (reinstall or update) Terminal configuration is incompatible (try different terminal types or commands) Specific environment variables are missing (set necessary environment variables)

See all articles