How to install MYSQL of the community version of blue whale smart cloud v3.1.7?

How to install MYSQL of the community version of blue whale smart cloud v3.1.7?

Install "blue whale smart cloud" Community Edition - record - install MYSQL of blue whale smart cloud

Q. Prerequisite knowledge:

Experimental machine: centos7
bkce_src-3.1.7.tgz community version
In "Haoding king 5: operation and maintenance automation closed loop, practice from Tencent"
https://blog.csdn.net/haoding205/article/details/82687802
Mentioned the blue whale smart cloud system, today I will start to talk about how to install the community version of MYSQL of blue whale smart cloud v3.1.7.

Install MYSQL of blue whale Zhiyun

1. installation

[root@hd103 install]# ./bkcec install mysql
             install mysql on host: 192.168.1.102         
          check dependences for mysql         
Usage: usermod [options] LOGIN
Options:
  -c, --comment COMMENT         new value of the GECOS field
  -d, --home HOME_DIR           new home directory for the user account
  -e, --expiredate EXPIRE_DATE  set account expiration date to EXPIRE_DATE
  -f, --inactive INACTIVE       set password inactive after expiration
                                to INACTIVE
  -g, --gid GROUP               force use GROUP as new primary group
  -G, --groups GROUPS           new list of supplementary GROUPS
  -a, --append                  append the user to the supplemental GROUPS
                                mentioned by the -G option without removing
                                him/her from other groups
  -h, --help                    display this help message and exit
  -l, --login NEW_LOGIN         new value of the login name
  -L, --lock                    lock the user account
  -m, --move-home               move contents of the home directory to the
                                new location (use only with -d)
  -o, --non-unique              allow using duplicate (non-unique) UID
  -p, --password PASSWORD       use encrypted password for the new password
  -R, --root CHROOT_DIR         directory to chroot into
  -s, --shell SHELL             new login shell for the user account
  -u, --uid UID                 new UID for the user account
  -U, --unlock                  unlock the user account
  -Z, --selinux-user SEUSER     new SELinux user mapping for the user account
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.aliyun.com
* epel: mirrors.ustc.edu.cn
* extras: mirrors.aliyun.com
* updates: mirrors.163.com
No package pidof available.
No package pkill available.
Package rsync-3.0.9-18.el7.x86_64 already installed and latest version
Package gawk-4.0.2-4.el7_3.1.x86_64 already installed and latest version
Package curl-7.29.0-42.el7_4.1.x86_64 already installed and latest version
Package lsof-4.87-4.el7.x86_64 already installed and latest version
Package 2:tar-1.26-32.el7.x86_64 already installed and latest version
Package sed-4.2.2-5.el7.x86_64 already installed and latest version
Package iproute-3.10.0-87.el7.x86_64 already installed and latest version
Package uuid-1.6.2-26.el7.x86_64 already installed and latest version
Package psmisc-22.20-15.el7.x86_64 already installed and latest version
Nothing to do
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.aliyun.com
* epel: mirrors.ustc.edu.cn
* extras: mirrors.aliyun.com
* updates: mirrors.163.com
Package python2-pip-8.1.2-5.el7.noarch already installed and latest version
Package 1:openssl-devel-1.0.2k-8.el7.x86_64 already installed and latest version
Package readline-devel-6.2-10.el7.x86_64 already installed and latest version
Package libcurl-devel-7.29.0-42.el7_4.1.x86_64 already installed and latest version
Package libxml2-devel-2.9.1-6.el7_2.3.x86_64 already installed and latest version
Package glibc-devel-2.17-196.el7_4.2.x86_64 already installed and latest version
Package zlib-devel-1.2.7-17.el7.x86_64 already installed and latest version
Package iproute-3.10.0-87.el7.x86_64 already installed and latest version
Package sysvinit-tools-2.88-14.dsf.el7.x86_64 already installed and latest version
Package procps-ng-3.3.10-16.el7.x86_64 already installed and latest version
Nothing to do
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirrors.aliyun.com
* epel: mirrors.ustc.edu.cn
* extras: mirrors.aliyun.com
* updates: mirrors.163.com
Package libaio-devel-0.3.109-13.el7.x86_64 already installed and latest version
Nothing to do
[192.168.1.102]20180410-184031 65   All required software are installed.
[192.168.1.102]20180410-184031 334   create directories ...
[192.168.1.102]20180410-184031 702   install mysql ...
[192.168.1.102]20180410-184031 145   >> rsync -a --delete /data/src/service/mysql /data/bkce/service/
[192.168.1.102]20180410-184031 420   expr: find /data/src/service/support-files/templates -name "*#my.cnf*"
[192.168.1.102]20180410-184031 424   templates file: #etc#my.cnf.tpl
[192.168.1.102]20180410-184031 437   target file: /data/bkce//etc/my.cnf
[192.168.1.102]20180410-184031 455   render configuration file:/data/bkce//etc/my.cnf
[192.168.1.102]20180410-184031 729   execute mysql_install_db
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/data/bkce/service/mysql/bin/mysqladmin -u root password 'new-password'
/data/bkce/service/mysql/bin/mysqladmin -u root -h 127.0.0.1 password 'new-password'
Alternatively you can run:
/data/bkce/service/mysql/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.  This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /data/bkce/service/mysql ; /data/bkce/service/mysql/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /data/bkce/service/mysql/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /data/bkce/service/mysql/scripts/mysqlbug script!
[192.168.1.103]20180410-184033 301   install mysql done
[root@hd103 install]#

2. Verify and view

Please refer to the next "Haoding king 5: how to install the basic module of the community version of blue whale Zhiyun v3.1.7"? "
https://blog.csdn.net/haoding205/article/details/82697765

OK, smart as you know, is it a pleasure to install MYSQL of the community version of blue whale smart cloud v3.1.7^_^

Others can leave a message in the comment area or scan the code for bloggers to get resources or ask questions.

Tags: MySQL shell EPEL SELinux

Posted on Wed, 01 Jan 2020 14:35:42 -0800 by golles