Shulou(Shulou.com)06/01 Report--

Because the version of centos7 and the version of mysql5.7 have changed compared to the older version, make a note of it.

First install the rpm package that is required for mysql:

Yum-y install perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-Config-IniFiles ncftp perl-Params-Validate perl-CPAN perl-Test-Mock-LWP.noarch perl-LWP-Authen-Negotiate.noarch perl-devel

(MariaDB is installed when the perl-DBD-MySQ package is installed. Delete it next)

Check if NySQL is installed, if it is installed and uninstalled

Rpm-qa | grep mysql

Yum remove mysql*

Check if MariaDB is installed, if it is installed and uninstalled (important)

Rpm-qa | grep mariadb

Yum remove mariadb*

New user / group parameter file

Groupadd mysql

Useradd-d / home/mysql-g mysql-m mysql

Passwd mysql

Mysql

# create mysql data storage path

Mkdir / data

Mkdir / data/mysql

# binlog storage path

Mkdir / data/mysql/binlog

# error log storage path

Mkdir / data/mysql/log

# Storage path of disk temporary table

Mkdir / data/mysql/tmp**

# Grant linux permission to mysql account

Chown-R mysql:mysql / data/mysql

# decompress the binary package

Tar-xvf mysql-5.7.19-linux-glibc2.5-x86_64.tar.gz

# move to / usr/local path

Mv mysql-5.7.19-linux-glibc2.5-x86_64 / usr/local/

# rename the compilation path

Cd / usr/local

Mv mysql-5.7.19-linux-glibc2.5-x86_64 mysql

Chown-R mysql:mysql / usr/local/mysql

# initialize mysql

. / mysql/scripts/mysql_install_db-- basedir=/usr/local/mysql/-- datadir=/data/mysql/data/-- user=mysql

# registering mysql commands

Echo "PATH=/usr/local/mysql/bin:\ $PATH" > > / etc/profile

Source / etc/profile

# set Boot Startup

Cp. / mysql/support-files/mysql.server / etc/init.d/mysqld

Chown-R mysql:mysql / etc/init.d/mysqld

Chown-R mysql:mysql / etc/my.cnf

Chkconfig-add mysqld

Chkconfig mysqld on

(using the optimized version of my.cnf requires adding indb02 files and modifying permissions

Dd if=/dev/zero of=indb02 bs=1M count=64

If=FILE: specifies the input file, or reads from the dimension input if not specified. Specified here as / dev/zero is a pseudo file of Linux that produces a continuous null stream (binary 0)

Of=FILE: specifies the output file, if not specified, outputs to standard output

Bs=BYTES: the number of bytes per read and write, in units K, M, G, and so on. In addition, input and output can be specified with ibs and obs, respectively. If bs is used, both ibs and obs use this parameter.

Count=BLOCKS: the number of block read. The size of block is specified by ibs (for input parameters only)

Service mysqld start

When startup fails, check the trace file.

The common errors that cannot be found in pid files are: 1. The previous startup failed, the generated index file is not deleted * .index, 2 does not have a tracking file, you need to manually create and modify permissions, and 3 lock files are not deleted)

View initial password

Cat / root/.mysql_secret

Or grep 'temporary password' / var/log/mysqld.log

# modify root password

/ usr/local/mysql/bin/mysqladmin-u root password 123456

Mysql-uroot-p123456-e "update mysql.user set password=password ('123456') where user='root'; flush privileges;"

Or ALTER USER 'root'@'localhost' IDENTIFIED BY' root123'; or set PASSWORD=PASSWORD ('root')

# Delete empty account

Mysql-uroot-p123456-e "delete from mysql.user where user=''; flush privileges;"

# allow public network to access mysql using root

Mysql-uroot-p123456-e "grant all privileges on *. * to 'root'@'%' identified by' 123456 'with grant option;flush privileges;"

Exit

Configure two-way master-slave:

Modify the service_id and bin_log file names in the configuration file. Create and authorize repl users to synchronize, close GTID,show master status to record binlog log pos numbers, changge master each other and turn on.

Pay attention to the issue of permissions.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.