Centos6.9 installation Mysql5.7.18 step record

Centos6.9 installation Mysql5.7.18 step record

Installation sequence rpm -ivh

mysql-community-common-5.7.18-1.el7.x86_64.rpm
mysql-community-libs-5.7.18-1.el7.x86_64.rpm (depends on common)
mysql-community-client-5.7.18-1.el7.x86_64.rpm (depends on libs)
mysql-community-server-5.7.18-1.el7.x86_64.rpm (depends on common, client)
mysql-community-devel-5.7.18-1.el7.x86_64.rpm (MySQL header files and library files)
yum install gcc gcc-c++ ncurses-devel perl 
yum install cmake -y
groupadd mysql
useradd -r -g mysql mysql
mkdir -p /usr/local/mysql
mkdir -p /data/mysqldb
tar -zxvf mysql-boost-5.7.18.tar.gz and then install vi /etc/my.cnf
datadir=/data/mysqldb/
socket=/data/mysqldb/mysql.sock
explicit_defaults_for_timestamp=true
mysqld --initialize 
ln –s /data/mysql/mysql.sock /var/lib/mysql/
chown mysql:mysql /var/lib/mysql -R
chmod -R 777 /data/mysqldb
service mysqld stop 
mysqld_safe --skip-grant-tables &
mysql -uroot -p
>use mysql;
> update user set authentication_string=PASSWORD("password") where user="root";
 update user set host='%' where user="root";
FLUSH PRIVILEGES; 
service mysqld restart
mysql -uroot -ppassword
SET PASSWORD = PASSWORD('password');

The above is the step record of installing MySQL 5.7.18 on Centos 6.9 introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!

You may also be interested in:
  • Detailed tutorial on installing MySQL 5.7.20 on RedHat 6.5/CentOS 6.5
  • Solution to the initialization error when installing mysql5.7 from rpm package in centos6.5
  • CentOS 6.4 MySQL 5.7.18 installation and configuration method graphic tutorial
  • Tutorial on installing and configuring MySql5.7 in Alibaba Cloud ECS centos6.8
  • CentOS6.8 uses cmake to install MySQL5.7.18
  • Detailed tutorial on installing MySQL 5.7.18 under CentOS 6.5
  • Deploy MySQL 5.7.17 binary installation and multi-instance configuration on CentOS 6.5
  • Tutorial on installing MySQL 5.7.28 on CentOS 6.2 (mysql notes)

<<:  A brief analysis of the configuration items of the Angular CLI release path

>>:  Nexus uses API to operate

Recommend

Example analysis of mysql variable usage [system variables, user variables]

This article uses examples to illustrate the usag...

Sample code for implementing interface signature with Vue+Springboot

1. Implementation ideas The purpose of interface ...

Implementation and optimization of MySql subquery IN

Table of contents Why is IN slow? Which is faster...

HTML Nine-grid Layout Implementation Method

Diversifying website layouts is our front-end spe...

Import backup between mysql database and oracle database

Import the data exported from the Oracle database...

How to quickly add columns in MySQL 8.0

Preface: I heard a long time ago that MySQL 8.0 s...

Sharing experience on MySQL slave maintenance

Preface: MySQL master-slave architecture should b...

How to hide a certain text in HTML?

Text hiding code, hide a certain text in HTML Copy...

VMware12 installs Ubuntu19.04 desktop version (installation tutorial)

1. Experimental description In the virtual machin...

How to use vs2019 for Linux remote development

Usually, there are two options when we develop Li...

Docker Compose practice and summary

Docker Compose can realize the orchestration of D...

mysql5.7.19 winx64 decompressed version installation and configuration tutorial

Recorded the installation tutorial of mysql 5.7.1...

Analysis of statement execution order of sql and MySQL

I encountered a problem today: Can I use the as a...