MySQL 5.6.27 Installation Tutorial under Linux

MySQL 5.6.27 Installation Tutorial under Linux

This article shares the installation tutorial of MySQL 5.6.27 under Linux for your reference. The specific contents are as follows

1. Download address

https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz

2. Upload the compressed package to the server

3. Decompression

tar -zxf mysql-5.6.27-linux-glibc2.5-x86_64.tar.gz

4. Move the compressed package to the mysql folder

mp mysql-5.6.27-linux-glibc2.5-x86_64 /usr/local/mysql

5. Add mysql user group and mysql user

groupadd mysql and useradd -r -g mysql mysql

6. Install the database

Enter the mysql software directory: cd /usr/local/mysql

Change the owner of the current directory to the mysql user: execute the command chown -R mysql:mysql ./

Install the database: execute the command ./scripts/mysql_install_db --user=mysql

Change the owner of the current directory to the root user: execute the command chown -R root:root ./

Change the owner of the current data directory to the mysql user: execute the command chown -R mysql:mysql data

7. Start the MySQL service and add the boot startup MySQL service

8. Change the root user password of mysql.

./bin/mysqladmin -u root password 'password'

9. Remote authorization

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root WITH GRANT OPTION;

question:

error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'

No good solution has been found yet.

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.6 installation tutorials for various versions

MySQL 5.7 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.

You may also be interested in:
  • Detailed tutorial on installing Mysql5.7.19 on Centos7 under Linux
  • MySQL 5.7.19 (tar.gz) installation graphic tutorial under Linux
  • MySQL 8.0 installation tutorial under Linux
  • Detailed steps to install MySql 5.7.21 in Linux
  • Installation tutorial of MySQL 5.1 and 5.7 under Linux
  • How to install and configure the decompressed version of MySQL database under Linux system
  • Detailed tutorial for installing MySQL on Linux
  • MySQL 5.7 installation and configuration tutorial under Linux virtual machine
  • Detailed steps to install MySQL 5.6 X64 version under Linux

<<:  5 things to note when writing React components using hooks

>>:  15-minute parallel artifact GNU Parallel Getting Started Guide

Recommend

Detailed explanation of mktemp, a basic Linux command

mktemp Create temporary files or directories in a...

How to create dynamic QML objects in JavaScript

1. Dynamically create objects There are two ways ...

Detailed tutorial on installing MySQL database in Linux environment

1. Install the database 1) yum -y install mysql-s...

Vue3 encapsulates its own paging component

This article example shares the specific code of ...

Rsync+crontab regular synchronization backup under centos7

Recently, I want to regularly back up important i...

Two implementations of front-end routing from vue-router

Table of contents Mode Parameters HashHistory Has...

JS thoroughly understands GMT and UTC time zones

Table of contents Preface 1. GMT What is GMT Hist...

WeChat applet to determine whether the mobile phone number is legal example code

Table of contents Scenario Effect Code Summarize ...

How to make Python scripts run directly under Ubuntu

Let’s take the translation program as an example....

Detailed explanation of this pointing problem in JavaScript

Preface Believe me, as long as you remember the 7...

Detailed explanation of MySQL solution to USE DB congestion

When we encounter a fault, we often think about h...

Detailed explanation of angular parent-child component communication

Table of contents APIs used Simple Example person...

Centos7 installation of MySQL8 tutorial

MySQL 8 new features: My personal opinion on MySQ...